Access 2007

Parts of a database

A Microsoft Access database is made up of several components, including tables, forms, queries, and reports. These components are called database objects. One or more of these objects is formed when a database is created, and all of the objects appear in the Navigation Pane. To make the database easier to navigate, beginning Access users may want to reorder the objects in the Navigation Pane.

To change how objects are ordered in the Navigation Pane:

• Click the drop-down arrow at the top of the Navigation Pane to see ordering options.

Change Object Order in Navigation Pane

• Select a menu option. The Navigation Pane will appear reordered based on your selection.

If you are new to databases, arranging the objects by type in the Navigation Pane is usually a good idea. This will group tables, forms, queries, and reports into individual groups in the pane.

To expand or collapse a group:

• Click any downward-pointing double arrow to expand a group so all objects are displayed.
• Click any upward-pointing double arrow to collapse a group and hide all objects.

Display Objects