Access 2016 Advanced

Lesson 11 – Using Macros

Access 2016

Creating a group macro

NOTE If you have already created macros, cut and paste them into a new group macro sheet or edit an existing macro sheet.



Procedures

1. Open the desired database. 2. Display All Access Objects in the Navigation Pane, if necessary. 3. Open the macro in Design View . 4. Click the Add New Action arrow and choose Submacro from the list. 5. Type a name for the macro. 6. Add the actions to the group you want the macro to carry out. 7. To add another macro, click anywhere outside the group and repeat steps 4-6. 8. When finished, click the Save button and provide a descriptive name for the Macro Group .



Step-by-Step

Create a group macro.

If necessary, display All Access Objects in the Navigation Pane.

Page 132

OFFICEPRO, Inc.