The Ribbon Microsoft Office 2007

The Office Fluent Ribbon is the primary replacement for menus and toolbars and provides the main command interface in Office Access 2007. One of the main advantages of the Ribbon is that it consolidates, in one place, those tasks or entry points that used to require menus, toolbars, task panes, and other UI components to display. This way, you have only one place in which to look for commands, instead of a multitude of places.

When you open a database, the Ribbon appears at the top of the main Office Access 2007 window, where it displays the commands in the active command tab.
The Ribbon contains a series of command tabs that contain commands. In Office Access 2007, the main command tabs are Home, Create, External Data, and Database Tools. Each tab contains groups of related commands, and these groups surface some of the additional new UI elements, such as the gallery, which is a new type of control that presents choices visually.

The commands on the Ribbon take into account the currently active object. For example, if you have a table opened in Datasheet view and you click Form on the Create tab, in the Forms group, Office Access 2007 creates the form, based on the active table. That is, the name of the active table is entered in the form's RecordSource property.

You can use keyboard shortcuts with the Ribbon. All of the keyboard shortcuts from an earlier version of Access continue to work. The Keyboard Access System replaces the menu accelerators from earlier versions of Access. This system uses small indicators with a single letter or combination of letters that appear on the Ribbon and indicate what keyboard shortcut actives the control underneath.

When you have selected a command tab, you can browse the commands available within that tab.
Select a command tab
Start Access.
Click the tab that you want.
-or-
Start Access.
Press and release the ALT key.
The keyboard tips appear.
Press the key or keys shown in the keyboard tip on or closest to the command tab that you want.

You can execute a command a number of different ways. The quickest and most direct route is to use the keyboard shortcut associated with the command. If you know the keyboard shortcut used from an earlier version of Access, it should also work in Office Access 2007.

http://nando007.blogspot.com