Creating a Database Switchboard

Switchboards are forms that provide easy access to many of your database's features. With a properly designed switchboard, your database users can display forms, print reports , and run macros with a single click of an action button. You can even hide all the other features of Access, making your switchboard the only thing the users see when interacting with your database. To help you create a switchboard, Access provides the Switchboard Manager add-in. The Switchboard Manager makes it easier to create new switchboards or edit the content of existing switchboards .

Create a Switchboard

Click the Tools menu, point to Database Utilities, and then click Switchboard Manager.

Click Yes when you are asked to create a switchboard.

Click Edit to edit the content of the switchboard's main page.

Type a name for the main page.

Click New to add an action button to the page.

Enter text for the button.

Click the Command list arrow, and then select a command.

Click the Report list arrow, and then select a form, report, macro, switchboard or function name.

Click OK.

Repeat steps 5 through 9 to add additional action buttons to the switchboard.

Click Close.

Click Close.