Access 2016 Advanced

Lesson 10 - Creating Macros

Access 2016

Steps

Practice Data

1. Right-click the macro you want to run. The macro name is selected and the shortcut menu appears .

Right-click Open Order Form , if necessary

2. Select Run .

Click Run

The macro runs.

Close the form window.

E DITING AN E XISTING M ACRO



Discussion

After creating a macro, you may decide to add or delete existing actions or change actions or action arguments. In the Macro Tools Contextual tab, you can cut, copy, and paste to edit a macro. You can also insert and delete rows. After you make the desired changes, save the macro to save the changes. It is a good idea to test the edited macro using single step mode. You must remember to disable single step mode after testing a macro.



Procedures

1. Open the desired database. 2. Select All Access Objects in the Navigation Pane, if necessary. 3. Right-click the macro you want to edit. 4. Select Design View from the shortcut menu. 5. Edit the macro as desired. 6. Save the changes to the macro.



Step-by-Step

Edit an existing macro.

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

Page 116

OFFICEPRO, Inc.