Access 2016 Advanced

Lesson 12 - Using Switchboards

Access 2016

E XERCISE

U SING S WITCHBOARDS



Task

Use switchboards.

1. Open Train36x . accdb. 2. Open the Training Switchboard form in Design view. 3. Change the Format properties of the form as shown in the following table:

Property

Setting

Default View

Single Form

Scroll Bars

Neither

Record Selectors

No

Navigation Buttons

No

Auto Resize

Yes

Auto Center

Yes

4. Close the property sheet. 5. Disable the Control Wizards, if necessary. Add a command button to the upper left corner of the form. 6. Open the property sheet for the command button. 7. On the Event page, set the On Click property to run the Open Payment/Invoice Forms macro. On the Format page, enter the text Open Forms as the caption. 8. Close the property sheet. 9. Create another command button on the form approximately 1/2” below the Open Forms button. Open the property sheet for the command button. 10. On the Event page, set the On Click property to run the Customer Macros.Print the Report macro. On the Format page, enter the text Print Report as the caption. 11. Close the property sheet. 12. Enable the Control Wizards. Add another command button to the form approximately 1/2” below the Print Report button.

Page 150

OFFICEPRO, Inc.