Access 2016 Advanced

Access 2016

Lesson 10 - Creating Macros

If the Open Payment Form macro is open, close it then open it in Design view with the Macro Tools Design contextual tab appears.

Steps

Practice Data

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

Right-click Open Payment Form , if necessary

2. Select Design View .

Click Design View

The Macro Tools Design tab appears.

3. Edit the macro as desired.

Follow the instructions below the table before continuing to the next step

The changes appear in the Macro Tools window .

4. Save the changes to the macro. The macro is saved.

Click

Add a third step to the macro. In the Actions pane, select the OpenTable and make the following selections for each field:

Table Name - Payment.

•

View – Print Preview.

•

Data Mode – Read Only.

•

Return to the table and continue to step 4.

Save the macro. Enable single step mode and run the macro. Step through the macro, as necessary. The Payment table will open. Close both windows and disable single step mode. Close the macro tab window.

Close MACROS1.ACCDB .

OFFICEPRO, Inc.

Page 117