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.