Data Management

Add a Switchboard to your Access application

Most IT pros use the Database Window in Microsoft Access to access forms and reports. Mary Ann Richardson explains why a better method is to create a Switchboard, which allows users to go directly to a specific form or report.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

Rather than accessing forms and reports from the Database Window in Access, you can create a Switchboard, which allows users to go directly to a specific form or report.

For example, suppose you want to present your users with a menu from which they can access the Employee data form and Employee Email Address form. You can do so by adding a Switchboard to your applications. Simply follow these steps:

  1. Go to Tools | Database Utilities | Switchboard Manager.
  2. You'll see this message: "The Switchboard Manager was unable to find a valid Switchboard in this database. Would you like to create one?" Click Yes.
  3. Click the Edit button.
  4. Click the New button and enter Open Employee Data Form for the Switchboard text.
  5. In the Command drop-down menu, select Open Form In Edit Mode.
  6. In the Form drop-down menu, select the Employee Data Form and Click OK.
  7. Click the New button.
  8. In the Text box, enter Open Employee Email Address Form.
  9. In the Command drop-down menu, select Open Form In Edit Mode.
  10. In the Form drop-down menu, select the Employee Email Address Form.
  11. Click OK and then click Close.

To automatically display the Switchboard when the database is opened, follow these steps:

  1. Go to Tools | Startup.
  2. Under Display Form/Page, choose Switchboard.
  3. Click OK.
0 comments