I don't have access to 2007 but I assume they haven't mucked qaround with this!
Goto Tools - Startup - Display Form/Page and select the Switchboard. When Access opens it should open the Switchboard.
Don't have 07 on this machine... but if I remember correctly... Click the Microsoft Office Button Button image (upper left), and then click Access Options. You will find your startup options there.