Macros   -   What is a macro?   

 Tables

 Queries

 Forms

 Reports


  Macros

    What is a macro?

    Macro design

    Tutorial


 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.


Access is a copyright of Microsoft, Inc. No infringement of those rights is intended.
Questions or comments -- Contact the author
1