How to Show All Objects in the Access 2016 Navigation Pane
Question details
The user needs to display all hidden database objects, such as tables and queries, in the Access 2016 Navigation Pane.
- Product
- Microsoft Access 2016
- Device & OS
- not provided
- Scenario
- Navigating and managing database components when the Navigation Pane filter is restricting visibility to a single object type like Reports.
- Observed behavior
- The Navigation Pane only displays Reports or specific groups, and other database objects are hidden from view.
Ensure that your Access database is open and that you have the appropriate administrative permissions to view all elements within the database file.
Use the Drop-Down Menu to Show All Access Objects
This is the fastest method to clear any existing category filters and display every table, query, form, and report in your database.
The Navigation Pane uses a grouping and filtering system to help manage large databases. When you select a specific filter, other objects temporarily disappear from view.
Look at the top of the Navigation Pane on the left side of the Access window. You will see a title bar that currently reflects the active filter, such as 'Reports'.
Click the drop-down arrow (or the circle icon containing a down arrow) located directly on the Navigation Pane title bar.
From the drop-down menu that appears, locate the 'Filter By Group' section and click on 'All Access Objects'. All your database items will immediately reappear.
Enable Object Groups in Navigation Options
If the drop-down menu does not resolve the issue, specific object categories may have been disabled in the Navigation Options.
Looking for a Lightweight Office Suite? Try WPS Office
While WPS Office does not include a direct replacement for Access databases, it offers powerful, free alternatives for Word, Excel, and PowerPoint. If your primary goal is organizing and analyzing data, the advanced pivot tables and formula functions in WPS Spreadsheet can handle most reporting tasks flawlessly.
- 1. Download the Installer: Visit the official WPS Office website and download the free software package.
- 2. Install WPS Office: Run the setup file and follow the standard on-screen instructions to complete the installation.
- 3. Open Your Data Files: Launch WPS Spreadsheet to import your exported Access data, CSV files, or Excel workbooks for seamless editing.
Frequently Asked Questions
Why did my Access Navigation Pane hide everything except Reports?
This commonly occurs when the Navigation Pane's category filter is accidentally clicked or intentionally changed. Choosing a specific group like 'Reports' acts as a filter, temporarily hiding Tables, Forms, and Queries to reduce visual clutter.
How do I show hidden system objects in Access 2016?
To reveal system objects, right-click the Navigation Pane header and select 'Navigation Options'. Under the 'Display Options' section in the bottom left of the dialog box, check the 'Show System Objects' box and click OK.
Can I customize how objects are grouped in the Navigation Pane?
Yes, Microsoft Access allows you to create custom groups. Right-click the Navigation Pane title bar, select 'Navigation Options', click on 'Custom' under the Categories list, and use the 'Add Group' button to create personalized folders for your database objects.
