Macros   -   Macro design   

 Tables

 Queries

 Forms

 Reports


  Macros

    What is a macro?

    Macro design

    Tutorial


 Modules
The development of a macro is simple in that technical jargon is not really necessary. All of the actions are captured in pull down lists within the macro design view.

To begin, select the New button with the Macro tab in the foreground or alternatively select the New Macro button from the drop-down New Object button. A macro design view window appears that looks similar to the table design view. This is where the low-level programming will occur.

The window is setup up with the Action and Comments column on top, with the specific properties and mini-help window at the bottom. To begin defining actions for the macro, select the pull down list in any of the cells within the Action column. After selection of an action, the properties will appear in the bottom left of the window and will vary from action to action.

Action List with Selected Properties

After finishing the macro, save it. This macro can then be triggered by double-clicking the name within the Macro tab or by associating the macro to an event within the database (i.e. a click of a button on a form).


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