Software Tips & Tricks Organize Objects In Access 2000 & 2002

By Laura Noble

As a database is being built, the number of objects (forms, queries, tables, etc.) can become quite large and cumbersome. Though each of these objects is required for the database to function efficiently, there may only be a few you need access to on a regular basis. Finding these few often can be like finding "a needle in a haystack."

You can solve the problem of finding these frequently used objects by adding the objects to a group in a custom category/folder.

1. Open Database.
   
   
2. Decide which objects to group. It is often best to group related objects in the same category/folder.
   
   
3. Below the Objects bar there is a Group Bar, which contains the default folder/category Favorites. View all groups by clicking Groups bar heading to see list.
   
   
   
4. Create a new group by right-mouse clicking in the Groups section and select New Group.
   
   
   
   
5. In the New Group box, fill in name of group and click OK.
   
   
6. New group will be displayed under the Group bar.
   
   
   
7. Drag the objects you want into the new group folder. These "dragged" objects will be shortcuts/copies of the original objects.
   

Formatting and field name changes to the original object will also take place in the “shortcut.”

Stay tuned to Networking Today in the coming months for more Software Tips & Tricks from Noble Software Solutions.

Laura Noble is the owner of Noble Software Solutions. Laura can be contacted at 519-680-2689 or by e-mail at lnoble@noblesoftwaresolutions.com. www.NobleSoftwareSolutions.com

Published in Networking Today, April 2002.