Hiding a Table in Microsoft Access

You may wish, at times to hide tables in Microsoft Access. To do this:

Right-click on the table and select 'Properties' from the drop-down list. Next to attributes, click on Hidden then, click on Apply. This will hide your table.

Close the window. Your table will be gone.

To view your table:

On the menu bar, click on Tools > Options.

On the general tab, check 'Hidden objects' > Apply,

Close the window, your table will now be visible but paler than the other tables. Just uncheck 'Hidden Objects' to re-hide the table.

I realize this is not foolproof, but unless the users of your Microsoft Access  database are proficient, they most likely will not know about this.

Do you like this tip? Subscribe to my free Newsletter to receive tips via email. Click Here to subscribe.