Reference: Locations of Access 2003 commands in Access 2007

This article introduces the Ribbon and other components of Microsoft Office Fluent user interface. It also provides a list of some Office Access 2003 commands and shows you where those commands reside in Microsoft Office Access 2007.

Important: This article is designed as a quick reference tool only and is not intended for training or learning purposes.

In this article

Introducing the new interface

Adding commands to the Quick Access Toolbar

New locations of familiar commands

Introducing the new interface

In Office Access 2007, the new Microsoft Office Fluent user interface replaces menus, toolbars, most of the task panes, and the Database window from previous versions of Access with a single, simplified mechanism that makes the commands easier to find. The new user interface is designed to help you be more productive in Access, more easily find the right features for various tasks, discover new functionality, and be more efficient.

This article is designed for experienced Office Access 2007 users — Help desk personnel, IT professionals, and others who are already accustomed to the Access 2003 interface — who want to find familiar commands quickly in Office Access 2007.

Office Fluent user interface

The primary replacement for menus and toolbars in Office Access 2007 is the Ribbon, part of the new Office Fluent user interface (UI). Designed for easy browsing, the Ribbon consists of tabs that are organized around specific scenarios or objects. The controls on each tab are further organized into several groups. The Ribbon can host richer content than can menus and toolbars, including buttons, galleries, and dialog box content.

access 2007 home tab

1. Tabs are designed to be task oriented.

2. Groups within each tab break a task into subtasks.

3. Command buttons in each group carry out a command or display a menu of commands.

Tabs that appear only when you need them

In addition to the standard set of tabs that you see on the Ribbon whenever you start Office Access 2007, two other kinds of tabs appear in the interface only when you perform a given type of task.

Contextual tools    Contextual tools enable you to work with an object that you select on the page, such as a form control. When you click the object, the pertinent set of contextual tabs appear in an accent color next to the standard tabs.

A contextual tab on the Access Ribbon

1. Select an item in your document.

2. The name of the applicable contextual tools appears in an accent color, and the contextual tabs appear next to the standard set of tabs.

3. The contextual tabs provide controls for working with the selected item.

Program tabs    Program tabs replace the standard set of tabs when you switch to certain authoring modes or views, including Print Preview.

A program tab on the Access 2007 Ribbon

Menus, toolbars, and other familiar elements

In addition to tabs, groups, and commands, Office Access 2007 uses other elements that also provide paths for accomplishing your tasks. The following elements are more like the menus and toolbars that you are already familiar with from previous versions of Access.

Microsoft Office Button Office button image     This button is located in the upper-left corner of the Access window and opens the menu shown here.

The Access 2007 File menu

Quick Access Toolbar    The Quick Access Toolbar is located, by default, at the top of the Access window and provides quick access to tools that you use frequently. You can customize the Quick Access Toolbar by adding commands to it.

The Quick Access Toolbar

Dialog Box Launchers    Dialog Box Launchers are small icons that appear in some groups. Clicking a Dialog Box Launcher opens a related dialog box or task pane, providing more options related to that group.

Clicking a Dialog Box Launcher

Top of Page

Adding commands to the Quick Access Toolbar

As indicated in the tables at the end of this article, some Access 2003 commands are available in Office Access 2007 only from the list of all commands in the Access Options dialog box. To use these commands in Office Access 2007, you first add them to the Quick Access Toolbar as follows:

  1. Click the Microsoft Office Button Office button image, and then click Access Options.

  2. In the list at the left, click Customization.

  3. In the Choose commands from drop-down list box, select All commands.

    The Customize screen in the Access Options dialog box

  4. In the Customize Quick Access Toolbar list, select either For all documents (default) or the current database.

  5. In the Choose commands from list, click the command that you want to add, and then click Add.

    Repeat for each command that you want to add.

  6. Click the Move Up and Move Down arrow buttons to arrange the commands in the order in which you want them to appear on the Quick Access Toolbar.

  7. Click OK.

Top of Page

Was this information helpful?

How can we improve it?

How can we improve it?

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!