How to Unhide Hidden Objects in Access Database? – (2025 Guide)

Microsoft Access is an excellent database tool, which is mainly used to organize and list out the information, and it also helps users to prepare various types of designed reports. But sometimes objects like tables, queries, forms, or reports get hidden. Unhiding them is crucial for editing purposes. Here’s a complete step-by-step guide on how to unhide hidden objects in Access database quickly and easily.

What Is Database Objects?

A component of the database structure is called database objects. And in other words, a database object is a configuration that is mainly used to store or manipulate data.

But the most essential thing is that it covers a wide variety of database objects, and people interact through the help of the table. Microsoft Access provides several objects that are mainly used to recover and store data from the database.

What Are The Types Of Database Objects?

Microsoft Access uses the “objects” to organize and list out the information and it also helps the users to prepare various types of designed reports.

But when you try to create an Access database, it offers the queries, tables, reports, forms, macros, and modules.

The major four objects of the database in MS Access are as follows:

1. Queries
2. Tables
3. Reports
4. Forms

Although all these database objects will allow you to store, enter, compile, and analyze your data.

No,w here is a summary of some of the basic objects in Microsoft Access database.

1. Queries

A query is an object which offers you a custom view of the data from one or more tables, and it is a way of compiling and searching data from one or more tables.

• When you try to form a query in Microsoft Access, for doing so, you have to define the specific search conditions to find out exactly the data you need.
• Running a query is something like asking a question of the Access database.
• In MS-Access, you can simply make use of the graphical query. And you can also write the (SQL) statements to form your queries.
• Queries can help you build a new table from the data in one or more tables.

2. Tables

The table object is mainly used to store and define data. While you form a new table, MS-Access uses it to ask you to describe the fields, which are known as the column headings.

• Tables contain columns and fields which used to store various types of data, like address, name, rows, and records, which collect all the data.
• Each field must have a unique data type.
• And you can easily express a primary key, which helps you to retrieve all your data quickly.

3. Reports

The report object in the Access database is mainly used to design for calculating, formatting, summarizing, and printing the selected data.

• If your forms are for input, then the reports are for output purposes.
• You can easily view the report on the screen before getting a print it.
• MS-Access proposes the capacity to build a report from a query or table.

4. Forms

The form object is mainly designed for data input, control, or display of application execution.

• The forms are mainly used to guide people towards entering the data appropriately.
• Forms are also used for modifying, entering, and viewing the records.

How To Unhide Hidden Objects In MS-Access Database?

Unhide Query & Table In MS-Access 2000, 97, XP, 2003

• First of all, go to the Tools -> Options on your menu bar.

• Then, make click on the View tab after that, check all your Hidden objects in the Show.

• Now, click on OK.
• After that, you have to go to Queries pane to see all your queries.

• All hidden objects should now be showing but its icon is grayed out.
• Then, make right-click on object’s name and uncheck the checkbox, Hidden, so efficiently you can modify your option back to unhidden.

Unhide Query & Table In MS-Access 2007

In Microsoft Access 2007, the method of configuring all things has been intensely improved by Microsoft. To unhide Access objects, you have to make use of the Office Button.

• First of all, you have click on Office Button at the top left side corner of your Access window.

• Then, you have to make click on “Access Options”.

• Now, this time simply click to the “Current Database tab” on the left side of the navigation

• After display the Current Database tab, you have to simply make click on Navigation Options.

• In that Navigation Options window, then you have to tick checkbox Show Hidden Objects in the Display Options.

• Again you have to click on OK to close all your opened windows.

• Then, just go back to navigation pane to view all your hidden objects are unhide or not.

Unhide Reports & Forms In MS-Access

If you want to unhide the Access objects, Access doesn’t offer you Close button. That time you may need to add your own buttons to close the object and also instruct users to make click on CTRL+F4.

• First of all, you have to choose File> Options.
• Then, In the MS-Access Options in the dialog box, you have to simply choose the Current Database option.
• Now, in Application Options, choose Display Document and then check the box.
• At last for this setting to take effect, you have to close and then re-open Access database.

How to Unhide Hidden Objects in Access Using VBA? (Advanced Users)

If you’re an advanced user and are comfortable with VBA code, you can unhide objects using a simple script. Simply run the below VBA code in the Visual Basic Editor to view the hidden objects.

vba

CopyEdit

DoCmd.SelectObject acTable, “TableName”, True

DoCmd.RunCommand acCmdObjectProperties

Note: Here, you have to replace “TableName” with the name of your hidden table, query, or form. After this, uncheck the “Hidden” box in the properties window.

Frequently Asked Questions:

Where Is the Show Hide Button in Access?

1. To show the Navigation Pane in the desktop database, you have to press F11.
2. To hide a Navigation Pane, click. Along the top of a Navigation Pane, or press F11.

How Do I View All Access Objects?

The answer to your query is ‘yes’, you can do MS Access view hidden objects easily by Right-click to the top of the Navigation Pane, then you have to select the “All Access objects“. After that, you’ll find the “Navigation Options” to choose from the popup menu.

When Navigation Options appears in your window, then you have to check the option “Show Hidden Objects“. Lastly, you have to click on the OK button.

How Do I Unhide Tabs in Access?

To unhide tabs in an Access database, follow the steps below:

• Choose File > Options.
• Under Access Options dialog box, choose Current Database.
• Under the Application Options section, you have to select or clear the Display Document Tabs check box.
• Finally, close & re-open the database.

How Do I Show All Queries in Access?

To show all the queries in Access, click on the Navigation Pane menu >> choose “Queries” from a popup menu. After this, the Navigation Pane should show all of the queries that’re in your database.

Final Words

To Unhide Hidden Objects in Access 2010, you need to simply read this post. After discussing all Access objects, I hope you’ve got full knowledge about how to unhide a field in Access 2016.

Although all the above-given data are going to help you out to unhide tables in Access 2013 and to view all your hidden data effectively and efficiently.

Hopefully, all these mentioned manuals and processes will work for you too.

References:

• https://support.microsoft.com/en-us/office/use-the-navigation-pane-274dfc5a-281b-472b-94e2-ef931c5cc590

Still having issues? Fix them with this Access repair tool:

This software repairs & restores all ACCDB/MDB objects including tables, reports, queries, records, forms, and indexes along with modules, macros, and other stuffs effectively.

1. Download Stellar Repair for Access rated Great on Cnet (download starts on this page).
2. Click Browse and Search option to locate corrupt Access database.
3. Click Repair button to repair & preview the database objects.

Pearson Willey

Pearson Willey is a website content writer and long-form content planner. Besides this, he is also an avid reader. Thus he knows very well how to write an engaging content for readers. Writing is like a growing edge for him. He loves exploring his knowledge on MS Access & sharing tech blogs.