Skip to content
Step by Step Internet 馃寪 Guides for learning to surf the Net

How to customize the Microsoft Access toolbar to get easier access to the tools I use most? Step by step guide

It should be mentioned that all the programs belonging to the Office suite they have the same toolbar, so the customization of it will be similar in all programs. It should be mentioned that this element is one of the most important and fundamental when working in any of these softwares.

And the one that it allows the user to access certain functions in a way a lot faster and easier, so it allows save time when working, which is very important when you are working with a very extensive database. It is also key to mention that this bar is composed of a set of independent commands belonging to the options bar.

Being a very important element when working with any of the Microsoft programs and being highly customizable, here we are going to explain how you can start to change its appearance in Microsoft Access, this will allow you to work a lot more comfortable. To do this, follow in detail everything that we will teach you next in the post.

What is the Access Toolbar and what is it for?

The toolbar or quick access toolbar is the one that has different commands that allow executing different types of actions in a more direct way. By default, it usually has activated the commands of “Save”, “Redo” and “Undo”. In this way users can access these three functions with just one click.

But luckily, this bar can be customized and which contain a set of independent commands that are part of the options bar. This allows users to add many more options, as well as delete some of them that you don’t think necessary.

It is also possible change the place of this element, it can be set to two locations within the program and in turn you can add the new buttons to represent more commands available there. All of this allows people who make use of these Microsoft programs may work more comfortably and above all it offers a higher work performance.

What are the benefits of customizing the Access toolbar?

Without a doubt power customize this quick access toolbar will offer you a lot of benefits to users, especially since this element of By default it does not have the necessary commands to help improve the person’s performance in the program.

That is why here we show you the main benefits that you can obtain when executing this procedure:

  • Allows you to have on hand the commands that you use the most.
  • Can add all the commands you think necessary and that they help you minimize working time.
  • You can locate it in two possible positions, this will allow you to choose which of them is for you more comfortable at the time of use.
  • Helps you access one way more direct to most Access functions, taking into account that they are located in the ribbon.
  • Can delete and add new commands to the bar in a very simple and fast way.
  • You don’t need to be a program expert in order to customize this item.

Learn step by step how to customize the Access toolbar

As has already been mentioned throughout the post, the procedure for customizing the Access toolbar is very easy. That is why here we are going to teach you the different methods what can you do for your personalization.

To do this, follow each of the steps that we are going to indicate below:

Add a new command to the toolbar

One of the most important aspects when wanting customize this item in Access is to know how to add new commands, since this will allow you to have there the functions that you use the most and that will help you minimize your work time in the program.

In order to add new functions, you must follow these steps:

  • The first thing will be to go to the ribbon and there select the tab where you are the function you want to add.
  • Once you find yourself where it is the command you want to add, you must place mouse cursor there and right click on it.
  • Then a dropdown menu, there you must choose the option “Add to Quick Access Toolbar“This way you can start adding the features you need the most there.

Add a new command to the toolbar

Add a command to the bar that is not on the ribbon

Remember that not all the features available in Access are located on the ribbon.

Therefore, in order to add commands that are not there, it is necessary that you follow each of these steps:

  • In this case you must click the arrow at the bottom of the Quick Access Toolbar.
  • As you can see there a dropdown menu where you will see the commands that you have activated there and those that are not.
  • Here you must click on the option “More commands.”

Add a command to the bar that is not on the ribbon

  • Then the window of “Access Options” there you will find the list of “Available commands” and the list of “Customize the toolbar.”
  • At this point you should start selecting the commands you want to add to the bar and to do this click on the add button, in this way you can add all the functions you think necessary.
  • Once added all necessary functions you must click “To accept”.

Add a command to the bar that is not on the ribbon

Remove a command from the Quick Access Toolbar

It is possible that for some reason you want to remove some of the functions you have there, either because you do not use it or because you do not consider it really necessary to have it there.

To do this, you must follow these steps:

  • This process is completely similar to the previous one, in this case you must access the options of the bar again and there select “More commands.”
  • Once you are in the “Access Options”, you must place yourself on the list of “Customize Quick Access Toolbar.”
  • There you must select the command you want to remove, once selected you must click on the button “Remove”, this will allow you to remove those functions that you no longer need.

Remove a command from the Quick Access Toolbar

Modify the order of the commands in the Quick Access Toolbar

  • In this case the first thing you should do is right click in the quick access toolbar and then click on “Customize the Quick Access Toolbar ” in the drop-down menu.
  • Now in “Customize the toolbar” you must select the command you want to move and then you can change position with the up or down arrows.

Groups commands by adding a separator between commands

It is also possible group commands through the use of separators, this will allow the toolbar to have an appearance of sections, which will allow you to place similar functions in the same group.

To do this, follow these steps:

  • For this process you must right click on the quick access tool bar and then click on “Customize the Quick Access Toolbar” in the drop-down menu.
  • Now on the list “Available commands” you must click “Most used commands”.
  • Now select on Separator” and then in “Add”.
  • To place the separator where you prefer you must move it with the arrows up or down.

Change the position of the toolbar

As already mentioned the toolbar in Access It can locate in two places, the first one is at the top of the screen where it appears from default way.

But if for some reason you don’t want to have it there anymore, you can follow these steps:

  • Here you must select the toolbar and in the drop-down menu that appears in it you must select the option of “Show Below Ribbon.”
  • Automatically this will change place and it will appear to you now as it can see in the following image.

Change the position of the toolbar