Access 2016 Advanced

Lesson 10 - Creating Macros

Access 2016

E XERCISE

C REATING M ACROS



Task

Create, test, and edit a macro.

1. Open MACROS1X.ACCDB . 2. Create a new macro. Enter the following actions and comments:

Action Comment OpenForm Opens the Invoice Form OpenForm Opens the Payment Form in Datasheet view

3. Save the macro as Open Invoice/Payment Forms . 4. Enable single step mode and run the macro to test it. 5. Close the Invoice and Payment Form windows. 6. Save the macro and disable single step mode. Close the macro tab. 7. Close the database file, without saving.

Page 118

OFFICEPRO, Inc.