I use a lot of tables and seldom do I complete a table without rearranging the data, at least a bit. The good news is that you don’t have to overwrite existing data, which is tedious and inefficient. How do you can adjust table rows up and down?
Last week we asked…
“How do you hide and unhide system and custom objects in Access?” The answer follows:
- To hide an object, right-click it in the Database window or Access 2007’s Navigation Pane, choose Properties from the resulting submenu, and check the Hidden option in the Attributes section on the General tab.
- To unhide hidden objects, choose Options from the Tools menu and check the Hidden Objects option in the Show section on the View tab. In Access 2007, right-click the Navigation pane’s menu bar, select Navigation Options, select Show Hidden Objects, and click OK. If hiding the object doesn’t work (it’s still visible in the Database window or Navigation Pane) most likely, the Hidden Objects option is currently checked. Uncheck it, and the hidden objects should disappear.
- Access hides System objects by default. To unhide them, choose Options from the Tools menu. Then, check the System Objects option in the Show section on the View tab. In Access 2007, right-click the Navigation pane’s menu bar, select Navigation Options, select Show System Objects, and click OK.
For additional insight into hiding objects, read tip 6, Hide objects — a subtle form of protection in 10 tips for security a Microsoft Access database.