WinBook Tech Article
For more information visit www.winbookcorp.com
Subject: Creating a Switchboard in Access 2000
Keywords: Microsoft Office Access 2000 Creating Switchboard
Tech Article Number: WBTA00000873

NOTE: You, the customer, are solely responsible for data security. WinBook strongly recommends that you perform a backup of all personal data contained on your system prior to performing this procedure. Warning: WinBook will NOT be held responsible for any data loss incurred during this process.


Access 2000 makes it easy to set up a user-friendly Switchboard for your existing project. Here's how its done:

  1. Open one of your databases.
  2. Click on Tools, then Database Utilities, and finally Switchboard Manager.
  3. If no Switchboard form exists, Access will display a message telling you that no Switchboard exists and will ask if you want to create one.
  4. Click Yes to display the Switchboard Manager screen, and click the Edit button to edit your options.
  5. From this screen, you can change the Switchboard default name from Main Switchboard to whatever you'd like.
  6. Click the New button to display the Edit Switchboard Item dialog box.
  7. In the Text field, type a brief description of the first item you want to add.
  8. In the Command field, select the appropriate option from the drop-down list. The option you select will determine what options you'll receive in the third drop-down list.
  9. For example, if you choose Open Form In Edit Mode, the Switchboard Manager will display a list of your database's forms. Choose the form and click OK.
  10. Repeat this process until you've added all the items you want to the Switchboard form and click Close.

If you want to give users a second option for closing the Switchboard (besides the Close box), create a new Switchboard item named Exit and associate it with the command Exit Application; that option will close the Switchboard and the database.

The final step is telling Access 2000 to run the Switchboard form when you open the database. To do so:

  1. Right-click on the database window and choose Startup from the context menu.
  2. Click the drop-down arrow for the Display Form/Page option, choose Switchboard, and click OK.

The next time you open this database, Access will run the Switchboard form.


Your feedback is greatly appreciated. If you have noticed any problems with this tech article, or if you feel that something is not clear enough, please E-mail our Technical Support department by clicking on the link below. Please include the Technical Article Number and the specific area that you feel is inaccurate. Thank you. 
WinBook Tech Article Feedback

Disclaimer: This information is being provided to you as a service from the Technical Support Department of WinBook Computers. It is intended to assist you in the resolution of your technical problems or questions. If you feel uncomfortable implementing any of the information or suggestions contained herein then you should e-mail the WinBook Technical Support Department. WinBook will not be held responsible for any loss of information, data or programming as a result of the use of this TechNote.

©2007 IPSG. All rights reserved. PowerSpec and WinBook are registered trademarks of Micro Electronics, Inc. Policies