Access 2007 's Ribbon Ribbon detailed

The Ribbon ribbon of Office Access 2007 is the primary alternative to menus and toolbars, providing the main command interface in Access 2007. One of the main advantages of the Ribbon ribbon is that it will normally require tasks or entry points to be displayed by using menus, toolbars, task panes, and other UI components to focus on one place. This way, you only need to find commands in one place instead of looking around for commands.

When you open a database, the Ribbon appears at the top of the Office Access 2007 main window, where the commands in the active command tab are displayed.

The ribbon consists of a series of command tabs that contain commands. In Office Access 2007, the main command tabs include Start page, create, external data, and database Tools. Each tab contains multiple sets of related commands that show some of the other new UI elements (such as the Style Gallery, which is a new type of control that can visually represent selections).

The commands in the Ribbon relate to objects that are currently active. For example, if you open a table in Datasheet view and click Form on the Create tab of the Forms group, Office Access 2007 creates the form based on the active table. That is, enter the name of the active table in the RecordSource property of the form.

You can use keyboard shortcuts in the Ribbon. All keyboard shortcuts in earlier versions of Access can continue to be used. The keyboard access system replaces the menu accelerator keys for earlier versions of Access. This system uses small indicators that contain a single letter or letter combination, which is displayed in the Ribbon, indicating what keyboard shortcuts are used to activate the lower control.

After you select the Command tab, you can browse the commands that are available on that tab.

There are several ways to execute commands. The quickest and most straightforward method is to use the keyboard shortcuts associated with the command. If you know the keyboard shortcuts used in earlier versions of Access, you can also use this shortcut in Office Access 2007. Refer to the "Use the ALT key to play Office2007 shortcut keys small magic."

Click the tab that corresponds to the command. The following table shows the typical examples of tabs and the commands available on each tab. The tabs and the available commands change as you perform the action.

Command tab	Common actions that you can perform
Start Page	Select a different view.
	Copy and paste from the Clipboard.
	Sets the current font characteristics.
	Sets the current font alignment.
	Apply rich text formatting to the Memo field.
	Use Records (refresh, new, save, Delete, rollup, spell check, and more).
	Sort and filter records.
	Find Records.
Create	Inserts a new, blank table.
	Use a table template to create a new table.
	Create a list on a SharePoint site and create a table in the current database that is linked to the newly created list.
	Create a new, blank table in Design view.
	Creates a new form based on the active table or query.
	Create a new PivotTable report or chart.
	Creates a new report based on the active table or query.
	Create a new query, macro, module, or class module.
External Data	Import or link to external data.
	Export data.
	Collect and update data by e-mail.
	Use the online SharePoint list.
	Create saved imports and saved exports.
	Move some or all of the databases to a new or existing SharePoint site.
Database Tools	Start the Visual Basic editor or run a macro.
	Create and view table relationships.
	Show/Hide Object dependencies or property worksheets
	Run the database document or analyze performance.
	Move data to a Microsoft SQL Server or Access (table only) database.
	Run the linked Table Manager.
	Manage Access add-ins.
	Create or edit the Visual Basic for Applications (VBA) module.