Need some guide with macros in database

Asked By lark yency 20 points N/A Posted on - 01/27/2013

Can anyone please explain the meaning of macros in database?

I am trying to create certain functions with the use of Microsoft Access, however I have read somewhere that there are a lot of limitations when using macros.

However I am taking this with a grain of salt, and I would like to better understand it before deciding whether to go with it or not.

What is the meaning of macros in database, and what are the advantages of using it via MS Access?

• Status: Open
• Question Views: 656
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Access

Answered By Kay Sheri 0 points N/A #196294

Need some guide with macros in database

Hi Lark,

The Microsoft Access macros are another tool that has access to automate tasks such as updates, show reports, etc.

Macros are limited to environments that are to be used:

 

Desktop DataBase: using macros and VBA code, being aware if this database is shared or for a single user

Web Database: can only be used macros of access (without VBA code) for compatibility and security.

The advantages are saving time, improving functionality, etc

 

Hope it helps

 

Kay Sheri.

 

About Kay Sheri

Questions
2

Answers
19

Best Answers
5

• Vote Up 0 Vote Down

• Posted on - 01/30/2013
• Question Category: MS Access