Access 2016 Advanced

Lesson 11 – Using Macros

Access 2016

By linking a command button or control with a macro, you can make commonly used functions easier. Initiating macros this way is particularly useful because it does not require the user to know or use the Access menu structure. For example, associate a macro with a command button on a form to print a report. The user can then print the report by clicking the command button, without having to open the report or know the correct menu commands.



Procedures

1. Open the desired database. 2. Open the desired form in Design view. 3. Select the desired control. 4. Press [F4] to open the property sheet. 5. Select the Event tab. 6. Select the desired property. 7. Select the property list. 8. Select the desired macro. 9. Press [F4] to close the property sheet.



Step-by-Step

Assign a macro to a control.

Open the Customers form in Design view.

Steps

Practice Data

1. Select the desired control.

Click the Credit Limit text box control

Sizing handles appear around the control.

2. Press [F4] to open the property sheet. The property sheet for the selected control opens.

Press [F4] , if necessary

3. Select the Event tab. The Event tab appears .

Click the Event tab, if necessary

Page 124

OFFICEPRO, Inc.