  Tables
 Queries
 Forms
 Reports
 Modules
|
Macros in Access could be considered a limited programming language that allow for automated responses to many different events.
The use of macros is intended to automate the database by doing repetitive or roundabout tasks that a user would normally have to do. Some of the events that a macro can perform are:
- Open or close any table, query, form, report in any type of view available to that object
- Act with a custom made toolbar for processes to operate on a database
- Execute select and action queries
- Perform any of the commands found within an Access menu
There are many more possibilities open to macros, because of the ability to create highly involved macros that can include conditionals, nested commands, as well as multiple commands like those seen in the list above. It is best to experiment a bit with macros to see how they initiated and to what abilities they possess.
|
Macros
What is a macro?