You know you created that report, so why doesn’t it show up in the Access 2007 Navigation Pane when you open the database? By default, the Navigation Pane is set to display table objects only — or only those objects the user has chosen to display.

To display the report in the Navigation Pane, follow these steps:

  1. Click the arrow by the Tables button at the top of the Navigation Pane.
  1. Under Filter by Group, click on Reports.

Access now displays the list of reports in the Navigation Pane. You’ll have to repeat this procedure for any other object you want displayed. If you want to display all objects in your database at once, select All Access Objects.

To open an object, you can double-click its name or drag it from the Navigation Pane to the work area.

Miss an Access tip?

Check out the Microsoft Access archive and catch up on other Access tips.

Help users increase productivity by automatically signing up for TechRepublic’s free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.