web analytics

EXPLORING THE NAVIGATION PANE IN MICROSOFT ACCESS 2010

Microsoft Access 2010

This article explores the Navigation Pane in Microsoft Access 2010. It will teach you how to use the Navigation Pane to view and organise database objects and also how to search for database objects by name.

The Navigation Pane is on the left side of the Microsoft Access window. This pane contains links to all of the objects in the database. By default objects are grouped by their type, such as Tables, Forms, Queries, Reports and Macros. However Access allows you to group the objects in many ways and to search the objects based on their names.

1

1. Once you open an Access document, click on the All Access Objects button at the top of the pane. Here we see all objects in the database organised by the Object Type category. This view is excellent for smaller databases, but if you have a database with a lot of objects then it will be difficult to see what do you want in this view, the Tables and Related Views category is better suited for you then.

2

Note: Now if we select the Tables and Related Views category, notice that the heading of the Navigation Pane changed to all tables in order to indicate what we are seeing. This category lists related objects together.

3

2. In addition to the previous category you can also organise objects by the date they were modified or by the date they were created and you can create custom categories that contain the objects that you want. As well you can filter by a particular group so that only the database objects in that group are visible. Let’s filter our objects by the tables group. First select back the Object Type category from the Navigation Pane. And afterwards open the All Access Objects list and click on the Tables button.

4

Note: Now only the tables in our database are visible.

3. Do step 2 again, just select the Queries button.

5

Note: The Navigation Pane now shows only the queries in our database and again changed the title at the top of the pane to reflect the objects we can view.

6

4. If we want to view our entire database objects once again, simply click on the downward arrow in the Queries button on top of the pane and from the list select All Access Objects.

7

5. With the pane you can also reduce the number of objects that are visible without having to actually change the view. You can hide objects groups by simply clicking on their title.

8

Note: Now the query objects are no longer visible on the pane, but if you want to go back, just click on the title again.

9

6. You can also hide the entire pane from view if you need the extra space. You can do this by clicking on the shutter bar that is on the top right side of the pane.

10

Leave a Reply