Access 2016 Advanced

Access 2016

Lesson 11 – Using Macros

12. Select the text in the Caption property. 13. Type the text you want to appear on the button. 14. Press [F4] to close the property sheet.



Step-by-Step

Create a command button that is attached to a macro.

If necessary, open the Customers form in Design view, display the Design tab on the Ribbon , and click the Control Wizards button in the Controls group to disable it.

If you have not been using the Customers form, open the Customers1 form in Design view.

Steps

Practice Data

1. Click the Button button in the Controls group.

Click

The mouse pointer changes into a copy of the tool with a plus sign (+) when positioned over the form or report. 2. Click in the desired location in the form or report where you want to create the command button. The command button appears on the form or report . 3. Press [F4] to display the property sheet. The property sheet for the selected control opens.

Click in the lower left corner of the form

Press [F4]

4. Select the Event tab.

Click the Event tab, if necessary Click in the On Click property

The Event page appears .

5. Select the desired property.

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

OFFICEPRO, Inc.

Page 127