Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

Use the Navigation Options dialog box to show or hide groups of database objects that appear in the Navigation Pane, manage custom categories and groups, set display options, and open database objects in the Navigation Pane with single or double mouse clicks.

The Navigation Options dialog box

Select a category on the left to show assigned groups on the right.

For background information, see Use the Navigation Pane and Customize the Navigation Pane.

Grouping Options

Use these options to show or hide the groups in the predefined categories and to create and manage custom categories and groups.

Categories

To manage the predefined and custom categories in the Navigation Pane, do the following:

  • To see the groups assigned to a category in the Groups for <Category Name> section, select a category.

    For example, if you select Tables and Related Views under Categories, you see a list of assigned objects under Groups for "Tables and Related Views".

  • To reorder the list of custom categories, if any are defined, select one, and then click the up or down arrow. In the following example, you have a custom category for all Northwind Traders objects:

    The controls for reordering categories

    Note    You cannot reorder the predefined categories of Tables and Related Views and Object Type which normally appear at the top of the Categories list and the Navigation Pane.

  • To modify the custom categories, do the following:

    • Add   To create a new custom category, select Add Item and then enter the name in the box.

    • Delete    To remove a custom category, select Delete Item, and then confirm the operation.

    • Rename   To change the name of a custom category, select Rename Item and then enter the name.

    Note    You cannot modify the predefined categories, Tables and Related Views and Object Type.

Groups for <Category Name>

To manage the groups assigned to the category selected in the Categories section, do the following:

  • To display or hide a group in the Navigation Pane, select or clear the check box next to the predefined or group name.

  • To reorder the groups of a custom category, select the group want to move, and then click the up or down arrow that appear next to it. In the following example, you have a custom group for all objects related to Suppliers:

    The controls for reordering groups
  • To modify the groups of a custom category, do the following:

    • Add     To create a custom group, select Add Group.

    • Delete   To remove a category, select a custom group, select Delete Group, and then confirm the operation.

    • Rename    To change the name of a category,  select a custom group name, select  Rename Group, and then enter the name.

Note    You cannot modify groups assigned to the Tables and Views and Object Type predefined categories.

Display Options

To set display options, do the following:

  • Show Hidden Objects    Select to show hidden database objects in the Navigation Pane. This setting is cleared by default.

  • Show System Objects    Select to Show system tables and other system objects in the Navigation Pane. This setting is cleared by default.

    By default, some system objects are hidden in Access. To see all system objects, enable the Show Hidden Objects option as well.

Open Objects with

To control how many clicks open an object, do the following:

  • Single-click    Select to open with a single mouse click.

  • Double-click    Select to open with a double mouse click. This is the default.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×