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.
Made with FlippingBook - Online magazine maker