This might be a very basic tip for those of you who have been working with Access for years. But this week I had to open my very first Access application ever. And the application had a startup form - to which it would directly go without allowing me to see the tables, forms, etc that sat behind the application.
For a while, I thought I was locked out. And then..... I clicked on the SHIFT key while opening the database - and viola! the MDB file opened just like any normal Access database file.
I was happy as a Clam at high tide!
Ps: The normal view for Access is called the Database Window.
Also - if you want the Access database to always open to the database window, then you can set it by first opening the MDB file with the shift key depressed. Then change the startup settings by going to Tools->StartUp....