Access 2016 Advanced

Lesson 12 - Using Switchboards

Access 2016

A DDING A C OMMAND B UTTON TO A S WITCHBOARD



Discussion

After creating the switchboard form, add controls, such as command buttons, to it. As your database changes, you can modify the switchboard, as necessary. To improve the appearance of your switchboard, you can add labels and graphics, change object colors and fonts, and modify other form properties.

If a control performs a single function, such as opening a form or printing a report, and the form or report already exists, you can add the control using the Control Wizards. If the form or report has not been created, you can create the control without using the Control Wizards. Then, after the form or report is created, you can assign an action to the control and change any other properties, as desired.

When a control performs two or more functions, assign the control’s action to a macro. As with single function controls, use the Control Wizard. This method of assigning control actions to macros is the most common because many switchboard controls perform two actions, such as opening a form and closing the switchboard.

Switchboard Design view

NOTE A quick way to add a control to a switchboard is to open the switchboard in Design view and drag a macro to it. When you create a control this way, the control action is automatically assigned the On Click event property.

Page 144

OFFICEPRO, Inc.