Access 2016 Advanced

Access 2016

Lesson 11 – Using Macros

Steps

Practice Data

1. Right-click the macro you want to rename. The context menu appears.

Right-click Open Form

2. Select Rename .

Click Rename

The macro name appears in edit mode.

3. Type Autoexec .

Type Autoexec

The text Autoexec replaces the old macro name.

4. Press [Enter] .

Press [Enter]

The macro is renamed and repositioned alphabetically in the list of macros.

Close the database. Reopen MACROS2.ACCDB to see the macro run. Notice that the Orders form and the Order Items query open. Close the form and query windows. Close MACROS2.ACCDB .

OFFICEPRO, Inc.

Page 135