---

MS Access 2007: Display tables and related objects in the Navigation Pane

This MSAccess tutorial explains how to display the tables and related objects in the navigation pane in Access 2007 (with screenshots and step-by-step instructions).

Question: In Microsoft Access 2007, how do I get the Navigation Pane to display each table and its related objects?

Answer: To view the tables and related objects in the Navigation Pane, click on the Navigation Pane menu and select "Tables and Related Views" from the popup menu.

Now the Navigation Pane should group by table and display each object related to that table.

In this example, there are 3 tables - Employees, Order Details, and Orders.

For the Employees table, there are 2 objects - the Employees table and a form called frmEmployees.

For the Order Details table, there is 1 object - the Order Details table.

For the Order table, there are 3 objects - the Orders table, a query called qryFind_Orders, and a form called frmOrders.