How To Unhide The MS Access Hidden Objects

MS-Access is a famous Windows database program. And the primary cause for its success is its objects interface. And the “Objects” in the database is mainly used 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.

But, sometimes it may be the objects in Access database which are formed for growth purposes but, do not need to be seen by the common users of a database. In such a case, the Access objects can be hidden.

So, to Unhide Hidden Objects in Access 2010, you need to simply go through with this article. Here in this post, you’ll get a complete guide for how to unhide a field in Access 2016.

But before knowing about what is database objects, what are the types of database objects? And how to unhide queries in Access 2016, we’ll first look towards the scenarios.

Practical Scenario

First, take look towards the scenarios

Can someone walk me through the steps to create a macro that will Show Hidden
Objects.
I can do it in VBA code: Application.SetOption “Show Hidden Objects”, True but I want to create an AutoExe macro to display hidden objects in one of my
databases.
Thanks in advance.

Source: https://www.pcreview.co.uk/threads/show-hidden-objects-macro.4014268/

In prior versions of Access I had hidden queries that were part of ‘query-chains’ and left only the final query visible.  In prior versions of Access, there was a VERY SIMPLE checkbox to unhide objects from the ‘Tools’, ‘Options’ menu.  How is this accomplished in Access 2007?  I’ve tried everything I can find or think of and I’m getting desperate.

Original post from: https://answers.microsoft.com/en-us/msoffice/forum/all/unable-to-view-hidden-objects-in-microsoft-access/418661fe-4711-4fb2-9c4d-ad143517e7cc

What Is Database Object?

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

But the most essential thing is that it covers a wide variety of database objects and the 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.

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 make click on the OK button.

By doing so, you can easily unhide the hidden objects or Access show navigation pane.

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.

Now 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 the one or more tables.

  • When you try to form a query in the Microsoft Access, for doing so, you have to define the specific search conditions to find out exactly the data you need.
  • Running query is something like asking the 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 to build a new table from the data in one or more tables.

2. Tables

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

  • Tables contain columns and fields which used to stores various types of data, like address, name, rows, and records which collects 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

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 propose you the capacity to build a report from 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 seeing 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.

Options

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

Hidden objects

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

Queries pane

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

Unhide Query & Table In MS-Access 2007

In Microsoft Access 2007, the method of configuring all the things have 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.

Office

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

Access Options

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

navigation

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

Navigation Options

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

Hidden Objects

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

Hidden Objects

  • 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, an 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 FileOptions.
  • 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.

By following the above-given steps you can easily do MS Access view hidden objects or unhide reports and forms navigation pane.

Final Words

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

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

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

You Might Also Interested In:
How To Unhide The MS Access Hidden Objects