O'Reilly Hacks
oreilly.comO'Reilly NetworkSafari BookshelfConferences Sign In/My Account | View Cart   
Book List Learning Lab PDFs O'Reilly Gear Newsletters Press Room Jobs  

Buy the book!
Access Hacks
By Ken Bluttman
April 2005
More Info

Help Users Find the Objects They Need
Place shortcuts to pertinent objects in custom groups so that users don't have to wade through all the database objects.
[Discuss (0) | Link to this hack]

The Access database window can be overwhelming to some users. Tables, queries, forms, reports; determining where to find objects you need within these object collections isn't exactly a user-friendly process. Besides, sometimes a user needs just a handful of objects to complete his work. And yet he might be confronted with considerably more objects than he needs.

Luckily, the Access database window allows you to create custom groupings in which you can place shortcuts to only the desired objects. Just as the Windows desktop has shortcuts to folders, files, and applications, Access lets you make shortcuts to your database objects. And it's a cakewalk to do so!

Using Groups

By default, there is one Favorites group, in which you can place shortcuts to objects. It's easy to do; just find the object wherever it exists within the various tabs, and then click and drag it to the Favorites group. shows the result of doing just that. The Favorites group has been filled with shortcuts to some of the database objects. Note that these are shortcuts. The original objects are still where they belong within the object collections. You can delete a shortcut in the Favorites group, and the original object remains.

Figure 2. Placing shortcuts in the Favorites group

Clearly, using the Favorites group lets you focus user activity! However, you can also go a step further by adding additional groups for even better organization. How about a group for each user or type of user? For example, data entry operators and supervisors might use the same database application, but with different objects; the data entry operators might use certain forms, and supervisors or managers might use queries and reports to see overall activity.

It's easy to add a new group. Just right-click in the Groups area, select New Group from the list of options, and give the group a name. At this point you can drag objects to the new group. shows how two new groups have been added to the application. Each has its own list of shortcuts.

Another good point about groups is that the same objects can reside in more than one group. If you have a reason to place a shortcut to a particular report in three different groups, Access won't hold you back. In fact, you can even copy shortcuts from one group to another.

Figure 3. Creating and using a custom group

O'Reilly Home | Privacy Policy

© 2007 O'Reilly Media, Inc.
Website: | Customer Service: | Book issues:

All trademarks and registered trademarks appearing on oreilly.com are the property of their respective owners.