How to Create a Switchboard in Access 2007
Access switchboards add automation to your database. Creating switchboards lets you put a form in front of your end users so they don't have to work with the database details. The switchboard gives your users buttons and commands to click so they can obtain or enter information into the database. Create the switchboard by using the Switchboard Manager. Add tasks and commands to your switchboard that allow the end user to do data entry or run queries and reports.
Other People Are Reading
Instructions
-
-
1
Open Access 2007 and select a database. Click the "Office" button and select "Open." Browse your files and locate the database. Click the file and select "Open." The database opens.
-
2
Click the "Database Tools" tab and click "Switchboard Manager." At the creation prompt, click "Yes." Click "Edit" when the Switchboard Manager opens. The Edit Switchboard Page opens. Click "New."
-
-
3
Type an action name in the "Text" field. This is the field that will give end users instructions on the button they are clicking. Select a command from the "Command" drop-down menu. For example, if you want to run your invoice report, select "Open Report." Select the report from the "Report" drop-down menu. Click "OK."
-
4
Click "Close" twice. You have just created a switchboard. Click the switchboard in the Navigation Pane to see the new button you just created.
-
1
