1-866-245-5224 sales@keystonelearning.com

Access 2007: Touring the Access Environment

Access 2007: Touring the Access Environment

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.























Folded Corner: Object Window

Figure 5. Access Window



Each labeled item is described in full on the next page.




Window Part


Control Buttons:

Located   in the upper-right corner of your window, these buttons (in order) will   inimize, maximize/restore and close your window.

Object Window:

The   Object window displays the opened objects as a series of tabbed documents so   you can quickly switch between multiple, open Access objects.

Office Menu:

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.

Scroll Bars:

Vertical   and horizontal bars allowing you the view other areas of the worksheet.

Status Bar:

In   the Status Bar, you see a document page and word count, plus macro and   editing indicators.

Title Bar:

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.

Navigation Pane:

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.