What I like you to do now is open up the Restaurant Application Database in your Project Files folder. So, click the Microsoft Office button, select open and then browse to the location of where you save the Project Files folder. Double click on Restaurant Application.ACCDB. You are going to be working with this database throughout many areas of this series. This form that opens up is a Welcoming Screen. You can either close this form by clicking the Close button here or this X in the upper right corner, so do that now. What I like to talk about is the Quick Access toolbar. The Quick Acces Toolbar is a new component of the user interface within Access 2007, that's up here to the right of Microsoft Office button.
This special toolbar gives you easy access to some of the more commonly used commands that you will use in Access 2007. You can also customize this toolbar to include additional commands. By default it displays Save, Undo and Redo. If you click Save, that saves any changes to the currently database objects. Undo will undo the last change that you made to a record or a database object and vice-versa, the Redo command will cancel the last undo change you made to a record or database object. At the right end of the Quick Access toolbar is a small drop down arrow. So, click this button and this opens the Customize Quick Access toolbar.
The top section of the menu displays common commands that you might want to add to the Quick Access toolbar. Note that the three default commands Save, Undo and Redo have check marks next to them which means that they will automatically display in the Quick Access toolbar. If I un-check say Undo, you will notice it disappears of the Quick Access toolbar. I am going to Edit again and you will see it reappear. I am going to click the arrow one more time and you will see eight additional options, New, Open, E-mail, Quick Print, Print Preview, Spelling, Mode and Refresh All.
Any of these options also you put a check mark next to it. So, if I click Print Preview, you will now see Print Preview has been added to the Quick Access toolbar. I am going to click this off again and then click the arrow one more time and you will see three options down near the very bottom. More Commands, Show Below the RIBBON and Minimize the Ribbon. If you click More Commands -- I will do this now, you will see the Access Options dialog box displayed and what it does; it opens to the Customize category on the left side. Up near the top you will see a combo box that says, Choose commands from.
By default this shows the Popular Commands. If you click this down arrow you will see lots of options from the various Ribbon tabs and Contextual tabs. I am going to show you, I will scroll down here and you see lots of different Design tabs, Arrange tabs, Page Setup tabs, these are all Contextual tabs. If you click on any of these options -- I am going to click on Office menu now. Now, you will see all the commands that you see on the Office menu when you clicked Microsoft Office button in the upper left corner. I will scroll down so you can see them all. And any commands that have more than one options such as a Menu have this arrow, such as Publish, Save As Other Format or Server. Below this list you will see an option that says, Show Quick Access toolbar below the Ribbon.
Let me show you what the looks like. I am going to put a check in there and then click OK to dismiss this dialog box. Notice now, that the Quick Access toolbar has moved below the ribbon. If you like to show the Quick Access toolbar below the Ribbon so you can have less space between these commands you can move it down here. I am going to click the arrow again and down here at the bottom, you will see two additional options, Show Above the Ribbon and Minimize the Ribbon. If you click Show Above the Ribbon -- try that right now, you will see it moves back up to above the Ribbon. I am going to click it one more time and notice now that it says show below the Ribbon. The text on here will change depending upon the position of where the Quick Access toolbar is located.
The last option on here is Minimize the Ribbon and if you notice when I click there, the entire Ribbon collapses to just showing the four main tabs. If I click on any of these tabs, you will see that the Ribbon comes back into focus, but it overlaps the Navigation pane and part of the Object window. If I click Off, you will notice it collapses again. So, if you need some more space in the Object window or in the Navigation pane you can click the option to have it collapsed. To change it back you click the arrow and un-check the option next to minimize and you will see the Ribbon come back to full size and push the Navigation pane and the Object window down.
