How to Create a Custom Menu Bar for Access 2007


Microsoft Access provides users the option to create a customized menu toolbar including the features and shortcuts desired by the individual user. This toolbar allows the user to collect all of the crucial functions and shortcuts in Access in one place and prevents the user from having to go to different areas of the menu if only a few functions are needed. Toolbars can be customized in Access 2007 as well as previous and newer versions of the software and may be transferred from one version of Access to another. The following steps walk the user through the process of adding a custom menu toolbar.

Create a Custom Toolbar in Access

  • Open Microsoft Access. Go to the File menu.

  • Select 'Access Options' from the bottom right area of the screen.

  • Select 'Customize' from the Options menu.

  • Two menus will appear on the screen. The left menu includes the full list of commands available in Access. The commands are separated by type, popularity, or area. You can also choose to view all commands. The menu on the right shows the current commands included in the Quick Access Toolbar. The Quick Access Toolbar is the one that you will be customizing.

  • Find the commands that you wish to include on your custom toolbar in the column on the left and move them to the column on the right. Popular commands include print, formatting, export file, create form and create query.

  • After selecting your desired commands, you can choose to 'Show quick access toolbar beneath the ribbon.' This option will add the toolbar underneath the main toolbar ribbon at the top of the screen. If you do not choose this option, the customized toolbar will appear at the very top of the screen.

  • Select 'For all documents' to apply the toolbar to all instances of Access on your computer or you may choose your current file if you prefer for the toolbar to only be associated with the current database.

  • Click ok to save.

  • The customized toolbar will appear at the top of screen or under the toolbar ribbon depending on which option you chose above.

Tips & Warnings

  • If you have certain commands that you use in Access on a regular basis, it is a good idea to create your own custom toolbar and save the toolbar for all documents so that you have access to it no matter what file you are using.

Related Searches


  • Photo Credit Ryan McVay/Photodisc/Getty Images
Promoted By Zergnet


You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!