Access 2016 Advanced

Access 2016

Lesson 10 - Creating Macros

Steps

Practice Data

1. Select the down arrow in the Add New Action field. A drop-down list appears.

Click Add New Action

2. Select the desired action.

Scroll as necessary and click OpenForm

The action appears in the field and a list of corresponding arguments appears. 3. Select the applicable argument in the Action Arguments . The insertion point appears in the appropriate argument field and an arrow appears to the right of the field 4. Type the argument or select the corresponding list. The argument appears in the argument field or a list of arguments appears. 5. Select an object from the list, if applicable. The argument appears in the argument box .

Click in the Form Name

Click Form Name

Click Payment Form

S AVING A M ACRO



Discussion

After creating a macro, save it before you can test or run it. When you attempt to save a macro or close the Macro window without saving, a Save As dialog box opens with the default name of Macro# (numbered consecutively). It is best to use a short name that clearly indicates the function of the macro. The name Macro1 , for example, does not mean much to other users who may be working with the macro.

The name that you give the macro appears in the Macros object list in the Navigation Pane .

OFFICEPRO, Inc.

Page 111