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

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.