MS Access: Display all objects (tables, queries, forms, reports, modules) in the Navigation Pane in Access 2007

To view all objects in the Navigation Pane, click on the Navigation Pane menu and select "Object Type" from the popup menu.

Click on the Navigation Pane menu one more time and select "All Access Objects" from the popup menu.

Now the Navigation Pane should display all of the tables, queries, forms, reports, and modules that are in your database.