Access 2016 Advanced

Access 2016

Lesson 11 – Using Macros

NOTE Embedded macros are trusted because they are automatically prevented from performing certain potentially unsafe operations. An embedded macro is not visible in the Macros list in the Navigation Pane.



Procedures

1. Open the desired database. 2. Open the desired form or report in Design view. 3. Select the desired object or control to associate the macro. 4. Press [F4] to open the property sheet. 5. Select the Event tab. 6. Select the desired Event property. 7. Click the Build button . 8. Select Macro Builder from the dialog box.

9. Select . 10. Select the desired action from the Action drop down list. 11. Add the required arguments in the Action Arguments, if necessary, and move to next row. 12. Save the macro.



Step-by-Step

From the Student Data directory, open MACROS2.ACCDB . Create an embedded macro using the Macro Builder.

Open the New Entry form in Design view.

Steps

Practice Data

1. Select the desired object or control to associate with the macro. Sizing handles appear around the object or control.

Click the Enter New Record button

OFFICEPRO, Inc.

Page 121