Navigation Options dialog box

Use the Navigation Options dialog box in Access to show or hide the groups of database objects that appear in the Navigation Pane. You also use the dialog box to create and manage custom categories and groups, to set display options for the Navigation Pane, and to control whether you open the database objects in the pane with single or double mouse clicks.

To open the Navigation Options dialog box in Access, do one of the following:

  • Click File > Options to open the Access Options dialog box. Note, if you're using Access 2007, click the Microsoft Office Button and then click Access Options. Click the Current Database tab on the Access Options dialog box and then click Navigation Options in the Navigation section.

  • Right-click the top of the Navigation Pane and then click Navigation Options.

Grouping Options

Use the items in this section to show or hide the groups in the predefined categories that are provided in Access, and to create and manage custom categories and groups.

Categories

Displays the predefined and custom categories in the currently open database. When you select a category, the groups assigned to it appear in the Groups for section — for example, Groups for "Tables and Views." To show or hide a group, select or clear the check box next to it.

Also, you can reorder any of the custom categories in the Groups for list — that is, move them up or down in the list. To do so, select the custom category in the list and then click the up or down arrow that appears next to it.

The controls for reordering groups in a category

In addition, if you select the Tables and Related Views category, you can reorder some of its groups. To do so, click the category and then, in the Groups for pane, click the group that you want to move and use the up or down arrows to reorder the group.

It is important to note that you cannot delete a predefined category or the groups in that category, but you can prevent predefined groups from appearing in the Navigation Pane. To distinguish between predefined and custom categories, pay close attention to the buttons below the Categories section. If the Delete Item and Rename Item buttons are enabled when you select a category, it means you have selected a custom category.

Add Item    Click to create a new custom category.

Delete Item    Click to delete a custom category. These buttons are enabled only when you select a custom category.

Rename Item    Click to rename an item. These buttons are enabled only when you select a custom category.

Groups for

Displays the group or groups assigned to the category selected in the Categories section. Select or clear the check box next to a group to display or hide that group in the Navigation Pane. To distinguish between predefined and custom groups, pay close attention to the buttons below the section. If the Delete Group and Rename Group buttons are enabled, it means you have selected a group in a custom category.

Also, you can reorder the groups in any custom category, plus the groups in the Tables and Views predefined group. To do so, select the custom category, select the group want to move, and then click the up or down arrow that appears next to it.

The controls for reordering groups in a category

Add Group    Click to add one or more custom groups to a custom category. These buttons are enabled only after you select a custom category.

Delete Group    Click to delete the selected custom group. These buttons are enabled only when you select a custom group.

Rename Group    Click to rename a custom group. These buttons are enabled only when you select a custom group.

Display Options

Show Hidden Objects

Shows hidden database objects in the Navigation Pane. The check box is cleared by default.

Show System Objects

Shows system tables and other system objects in the Navigation Pane. The check box is cleared by default.

Note: By default, some system objects are hidden in Access. To see all system objects, you must also enable the Show Hidden Objects option.

Open Objects with

Single-click

Allows you to open the tables, forms, queries, and other objects in a database with a single mouse click. The default is double-click.

Double-click

Allows you to open the tables, forms, queries, and other objects in a database with a double mouse click. The default is double-click.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×