Mail us
Home » Forms » Microsoft Access Database Tutorial: Creating a Menu Form

Microsoft Access Database Tutorial: Creating a Menu Form

Microsoft Access Database Tutorial: Creating a Menu Form

In this tutorial you will learn how to create a main menu form in your Microsoft Access Database.

Take a quick look at the video tutorial below which will step you through the very basics as I’m often asked how easy is it to build your own MS Access menu forms.

Ignore the general look and feel of the forms demonstrated but more importantly, notice how easy it really is to create command buttons using the built-in wizard generator tool.

Microsoft Access Tutorial: Creating a Menu Form

So here’s a recap of the basic steps…

First and foremost, you need to make a separate form that contains the data that will be retrieved when the user clicks a button in your menu form.

Listed below are the steps in creating a main menu form.

  1. Open your Microsoft Access.
  2. Go to the create tab and click on blank form.
  3. Create a label. To do this, go to the design tab and click on Aa. Type whatever label you want for the form. You can change the color and size of the text on the home tab.
  4. Create a button.
  5. Go to the design tab.
  6. Click on xxxx, the item next to Aa.
  7. Drag it where you want the button to be positioned.
  8. The Command Button Wizard will pop up. It will ask you what action you want to happen when the button is pressed.
  9. Under the categories list, select form operations.
  10. Under the actions list, choose open form.
  11. Click the ‘next‘ button.
  12. It will show you the forms you have created. Choose the one that you will be using for the menu form.
  13. Click the ‘next‘ button. 
  14. You will have to choose between: ‘Open the form and find specific data to display‘ or ‘Open the form and show all records‘.
  15. Click the ‘next‘ button. 
  16. You have two options here. You either want to display a text or an image in your button.
  17. Click the ‘next‘ button. 
  18. The wizard will let you have a specific name for the button that will help you identify it when coding later.
  19. Click the ‘finish‘ button.

Microsoft Access Database

You can add other types of button into your form:

  • A button that can delete or add records.
  • A button that can show records one after the other and vice versa.
  • A button that can close the form.

Depending which version of Microsoft Access you use, to create a main menu form in your Microsoft Access Database will either generate VBA Access code or Access Embedded Macros both which will run the action of your choice which the latter can be converted to VBA code should you wish to add some enhancements to your procedure.

To learn more about Access Macros, why not consider my eBook on How To Use Microsoft Access Macros & Automate Your Application which comes with a fully refunded ‘no questions asked’ money back guarantee plus a 30 day email support! What do you have to lose?

Tags: , , , ,

7 Responses so far.

  1. Eric Au says:

    I first declare myself as the owner of baudb.com. bau db is a instant database management tool, which also use MS Access as the back-end database. One of it’s special features is the one-click ready-to-use worksheet, so that users have no need to spend time on creating forms. I wish this information will be helpful for you.

  2. roxine says:

    Thank you very much

  3. rusty shakleford says:

    it worked for me 🙂

  4. Peter says:

    Excellent. Just what I was after.
    Thank You

  5. HERU says:

    guys u keep showing how to open forms.But what about to open a TABLE when button is pressed not form.

    • benadt2017 says:

      Instead of using the wizard to generate the button, use the event tab for a command button and in its click event tab, use the following code:
      DoCmd.OpenTable “TableName”
      You will need to add more code to tidy up and trap for any errors but the above code line will open a table.