Access 2016 Advanced

Access 2016

Lesson 12 - Using Switchboards

Steps

Practice Data

11. Type the desired name for the button. The name appears in the What do you want to name the button? box .

Type Prints Report

12. Select Finish .

Click

The Command Button Wizard closes and the command button appears on the switchboard form.

Practice the Concept: Add a label to the right of the button with the text Print Customer Sales Report . Add another command button approximately 1" above the existing one. Using the Command Button Wizard, select the Miscellaneous category and the Run Macro action. Assign the Phone list macro to the button. Select the Show All Pictures option below the Picture list box and the Phone 1 picture. Name the button Phone List . Add a label to the right of the button and enter the text Phone List . Align the buttons and text, if necessary.

Save the switchboard form. Switch to Form view and test the switchboard command buttons. Notice that the telephone list appears and the report prints. Close all open windows, except for the database window.

S ETTING S TARTUP O PTIONS



Discussion

Setet startup options for a database. Startup options control what appears when the database opens. For example, you can choose to hide the Navigation Pane and the status bar. You may also select a default form to appear automatically when the Database window opens.

Switchboard forms are often specified in the startup options as the default form. This option allows you to create a form with all the options a user needs and have it appear automatically when the user opens the database.

NOTE Autoexec macros run after the options selected in the Startup dialog box are executed.

OFFICEPRO, Inc.

Page 147