I would like to show you now is to how to add some Custom Commands to this Quick Access Toolbar. So click the arrow again and let's go back to the More Commands option. By default, this always shows the Popular Commands option. On the right side, under Customize Quick Access Toolbar, you see a combo box that says For all documents (default). This first option has Save, Redo and Undo. Any changes that you make to this particular Quick Access Toolbar will apply to any databases you open in Access 2007.
So if you would like to use some common commands over and over again, this will be a good place to add them because you will see them in every database that you are working with. If we click this down arrow on here, you can actually make changes to just the specific database you currently have open. So click that option now. You will notice now that the box on the right has no commands. What I would like you to do is add some options to this particular Quick Access Toolbar for the specific database.
A common command that I like to use is the Access Options dialog box. That is located under the Office Menu. So click Popular Commands, scroll down until you click Office Menu, and you will see Application Options listed as the fourth option down. I like to use the Application Options quite often, so I usually add this to my Custom Quick Access Toolbar. To add this to the right side, you have two options. You can double click on it and you will see it moves to the right side.
If you change your mind and you don’t what to have this on there, you can highlight on the right side and click this Remove button and Access removes it from the list. You can also single click on an item and then click this Add button to add it to the right side. Another command that I would like you to use is the Manage Option, and the Manage option has an arrow next to it down here. So I am going to scroll down and let’s add that one to our Quick Access Toolbar. You can double click or as I said previously, click the Add button.
Scroll back up to the top and you will see an option that says Separator. Separator will add a Separator Bar to your Quick Access Toolbar options. So you can use this to break up a logical groups of options that you have. So let’s add this on here. I am going to click on it once, I will click the Add button and you see the word Separator appeared. You can add as many separators as you like on a Quick Access Toolbar. To the right, you will also see an up arrow and a down arrow. These are the Move Up and Move Down commands.
You can shuffle the order of these commands on the Quick Access Toolbar. So I am going to move the Manage, down one. So I click on it and then click the Move Down button and you will notice the Separator is now in between these two options. I like you to add one more option to this Quick Access Toolbar. So go back up to this down arrow where it says Office Menu, and select the option that says Macros. This specific database has one saved Macro object in it called AutoExecXmpl. So click on this and then click Add to add it to your Quick Access Toolbar.
With Macros, you have one additional option that you can use to customize, and this is only available to Macros. If you notice down here, this Modify button is now enabled. So I am going to click on this Modify button and you will see a 169 icons that you can use for this specific Quick Access Toolbar. So I am just going to pick the very last one here and you can even change the Display name. I am going to type in Sample macro, and now I am going to hit OK, and you will notice it says Sample macro up here now and it has a different icon.
If you click the OK button, take a look at your Quick Access Toolbar now, you have three new options. You have the Access Options, there is our Separator bar, you have Manage and if you notice this has that arrow, and if you click that arrow, here are the three options that you see on the Office Menu, Compact and Repair Database, Back Up Database and Database Properties. And here is our third option, the Sample Macro, and it has our custo
Transcription by:
Scribe4you Transcription Services