Making a main menu
First create a form called "frmMainMenu"
Then from the menu
View -> Code
paste the following
Option Compare Database
Option Explicit
Private Sub Form_Current()
DoCmd.Maximize
End Sub
Then from the menu
Tools -> Database utilties -> Startup
Display form/page
Select "frmMainMenu" from the dropdown list
When ever the user opens the database "frmMainMenu" opens and maximises.
Create buttons to open various forms and reports.