Show or hide database objects

1. Under Objects in the Database window, click the type of database object whose properties you want to change.
2. Click Properties on the toolbar.
3. Select or clear the Hidden check box.

Note  In a Microsoft Access project, you cannot change the properties of a table, query, or database diagram because these objects reside in the Microsoft SQL Server database. However, you can change the properties of a form, report, macro, or module, because these objects reside in the Access project itself, not in the Microsoft SQL Server database. You can also change the properties of a data access page.

If you need to work with objects that are defined as hidden without changing their status as hidden, you can display them in the Database window.

1. On the Tools menu, click Options.
2. Click the View tab.
3. Under Show, select or clear the Hidden objects check box. Microsoft Access displays hidden objects with dimmed icons to distinguish them from objects that aren't defined as hidden.

Microsoft Access automatically creates system objects when you create a new database.

1. On the Tools menu, click Options.
2. Click the View tab.
3. Under Show, select or clear the System objects check box.