At the database window on the Tables button, go to Window, Unhide. Select the
hidden tables.
This will not work with System tables. For that you need to go to Tools,
Options, View tab then select Hidden and System objects. Warning: Don't mess
with these tables.