This MSAccess tutorial explains how to setup the switchboard so that is opens automatically when the database is opened in Access 2007 (with screenshots and step-by-step instructions).
Question: In Microsoft Access 2007, my switchboard is not opening when I open my application. How do I fix it?
Answer:Click on the Microsoft Office button in the top left of the Access window and then click on the Access Options button.
When the Access Options window appears, click on the "Current Database" option on the left. Then under the "Display Form" option, select Switchboard from the drop down list. Then click on the OK button.
Now when you open your Access database, the Switchboard should start up automatically.
(scroll to see more)