Once you’ve got something working in Access you might want to make it available to others without buying a version of Access for everyone. You can download Microsoft’s free “Runtime” version of Access for this purpose. First, though, you’ll need to create a form with buttons or a Navigation form. Set this form as the startup form (File, Options, Current Database, Display Form, select your menu form). Now when users double click on the database file, your menu will come up and they can go from there.
To create a Navagation form, select the “Create” tab, then “Navigation”. Click on the first button and change its name. Then switch to Design mode, right click the button and select “Build Event…”, “Macro Builder”. Now you can run a macro or ask for a certain form or table using “OpenForm”, “OpenTable”, etc. Add other buttons to expose useful forms, tables, and so on. This menu form will always be available in the upper left corner of Access’s menu bar when you’re loaded with the Runtime version.