Whether you’re experienced with Access (or other Microsoft Office products, for that matter) or not, this initial screen probably looks very new. That’s because in Access 2007, Microsoft has eliminated all of those toolbars that we’ve become very accustomed to using. But, the good news is they’ve replaced the toolbars with Ribbons and Contextual Tabs that only appear when you need them. You see, Microsoft Access is now even more intuitive and flexible than before.
It may come as a shock to experienced Access users to know that a new Navigation Pane has replaced the Database window seen in previous versions of Access. And, when working with Database objects, Tables, Queries, Forms, Reports and Macros are displayed as tabbed documents versus individual windows.
Figure 5. Access Window
Each labeled item is described in full on the next page.
Located in the upper-right corner of your window, these buttons (in order) will inimize, maximize/restore and close your window.
The Object window displays the opened objects as a series of tabbed documents so you can quickly switch between multiple, open Access objects.
A button that displays a menu of common functions such as Open and Print.
Page View Controls:
Located in the lower-right corner of your window, the Page View Controls include quick access to page views include a zoom slider control.
Quick Access Toolbar:
Contains buttons to your most frequently used tasks such as Save, Undo and Print.
Displays commands and features that were previously hidden under menus in easy-to-access task-oriented tabs such as Insert, Page Layout and Formulas.
Vertical and horizontal bars allowing you the view other areas of the worksheet.
In the Status Bar, you see a document page and word count, plus macro and editing indicators.
Located at the very top of your screen, the Title Bar displays the name of the program you are running and the name of the document you are working in.
The Navigation Pane replaces the old Database Window and can be used to quickly navigate between the different Access objects.
Exploring the Ribbon
The Access 2007 Ribbon contains four tabs across the top of the Access window. Each tab contains groups of core tasks and each Group contains related sets of commands.
Many of the Ribbon groups contain a Dialog Box Launcher arrow ().This arrow is always found in the lower-right corner of a group and typically opens a Dialog Box with familiar Access settings. Occasionally, this button options a Task Pane instead of a Dialog Box.
Figure 6. Home Tab
The Home tab contains your most often-used commands including cut, copy and paste. You’ll also see groups for Views, Font, Rich Text, Records, Sort & Filter and Find.
Figure 7. Create Tab
The Create tab contains commands related to creating new database objects including tables, forms, reports and queries. The Create tab contains groups for Tables, Forms, Reports and Other.
Figure 8. External Data Tab
The External Data tab contains commands related to importing and exporting data as well as working with SharePoint lists. This tab contains groups for Import, Export, Collect Data and SharePoint Lists.
Figure 9. Database Tools Tab
The Database Tools tab contains commands related to advanced database commands such as macros and passwords. This tab contains groups for Macro, Show/Hide, Analyze, Move Data and Database Tools.