Control how an Access file looks and behaves when it opens

1. Create a macro containing the actions you want to run when you open the database.
2. Save the macro with the name AutoExec.

The next time you open the database, Microsoft Access runs this macro automatically.

Note  If you don't want to run the AutoExec macro when you open the database, hold down the SHIFT key when the database opens.