With the introduction of Access 2007 (and 2010), users will have noted not only the Fluent Ribbon Bar but the new Access Navigation Pane replacing the older database window.
This utility has some nice and simple features to further enhance how you manage your Access objects and in particular, filter and search objects when sharing an Access database.
From the standard object type including tables, queries, forms and reports, users can add as many groups and collect related objects in one view which makes it a very handy tool for collaborating workgroups and roles.
Objects are not copied (duplicated) when being assigned to a group but instead have a shortcut link pointing to the natural storage of the object type.
Access Navigation Pane: How To Use And Customise Microsoft Access Navigation Pane View
The following features are as follows:
- Easily show and hide the Access navigation pane view
- Select a type of category including the custom built categories
- Sorting items and groups
- Searching for objects
- Create and modify custom groups
- Copy and paste Access objects
- Hide and unhide objects
For example, you may want to add a new group and assign existing objects (as shortcuts) to the new group.
Create a new group by going to any object in the Access navigation pane and right mouse click to display the following pop-up menu
Click the New Group… option and a new group appears in the Navigation pane ready to be named.
Whichever object you may have selected, it will add a shortcut link to the new group. If you want to add or remove objects, then right mouse click and choose the required action.
You can also manage and create groups via the Access Navigation Pane options by simply right mouse clicking the top banner area and choose Navigation Options…
Sorting is also easy! Just right mouse click on the banner of the group to sort and choose the required action.
Take the time to browse and investigate this utility as many users seem to notice realise the potential when managing your Access objects.
To learn more about Microsoft Access and the tips ‘n’ tricks, why not consider my eBook range.
Tags: access 2007 database, access 2010 database, access database objects, access navigation pane, how to use the navigation pane, MS Access
Here’s a quick keyboard shortcut (key) to hide and unhide the Access Navigation Pane view. Press the F11 function key!