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 what 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”.

Printer Friendly Version

Published in Networking Today, April  2002.