How to Make a Switch Board in Database

A switchboard makes a database easier to use

Databases are widely used in the business world, and database programs like Microsoft Access provide a user-friendly interface for employees to use. A quality database program combines a robust back-end with an easy to use front end that includes simple data entry forms and access buttons. Creating a switchboard for the database lets users choose the actions they want to perform each time they open the database.

Things You'll Need

• Computer
• Microsoft Access
• Database

Instructions

1. Log on to your computer and open the database. Click on the "Tools" menu.

2. Choose "Database Utilities" from the menu and then select "Switchboard Manager." Click "Yes" to create a new switchboard.

3. Click "New" and type a name for the switchboard. Click on the switchboard and choose "Edit."

4. Click "New" and type the text for the first item on your switchboard. For instance, if the first button on the switchboard will open the "Orders" data entry form, type "Open Orders Form."

5. Choose a command in the "Command" box. For instance, if you want to open a form for data entry, choose "Open Form in Edit Mode" from the list. Repeat these steps until you have all the buttons you want on the switchboard.

References

• Microsoft Support: Creating a Switchboard