In Microsoft Access you can use startup options to specify, for example, what form to display, whether toolbars can be customized, and whether shortcut menus are available in your Microsoft Access file.
You can also use a special macro named AutoExec to carry out an action or series of actions when your database first opens. When you open a database, Microsoft Access looks for a macro with this name and, if it finds one, runs it automatically.
If you want to open a particular form, for example a switchboard form, when opening Microsoft Access, you will need to create the macro. To create an AutoExec macro, that opens a form, follow the steps listed:
After you perform these actions, Microsoft Access will run the macro automatically when the database is opened.
In Microsoft Access 2000 and later, rather than use the AutoExec macro, you can use the startup form to control many options, including:
Showing the Startup options dialog box available in Microsoft Access
2000 onwards.
See more on The Autoexec macro in Microsoft Access over at vb123.com