Access 2016 Advanced

Access 2016

Lesson 11 – Using Macros

Steps

Practice Data

4. Select the desired property.

Click in the On Got Focus property

The insertion point appears in the appropriate property and an arrow and a Build button appear to the right of the property.

5. Select the property list.

Click On Got Focus

A list of events for the property appears.

6. Select the desired macro.

Click Limit

The selected macro appears in the property.

7. Press [F4] to close the property sheet. The property sheet closes.

Press [F4]

Close the Customers form and save the changes. Open the Customers form in Form view and click the Credit Limit field. Notice that a message box generated by an existing macro opens. Select OK to close the message box. Close the form window.

C REATING A C OMMAND B UTTON



Discussion

Command buttons are controls to which you can assign actions. They are often used to run macros in a form or report. Place descriptive text or a picture on a command button so that user’s can easily identify the button’s purpose.

Create a command button in Design view. On the Design tab in the Controls group the Button button. After you create the command button on the form, set the properties, such as the event property to initiate the action and the text or picture to appear on the button.

OFFICEPRO, Inc.

Page 125