NOBLE SOFTWARE SOLUTIONS - WE MAKE IT CLICK!

Organize Objects In Access 2000 & Up

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

©Noble Software Solutions - www.NobleSoftwareSolutions.com - 519-680-2689

Home    Why NSS?    Tips & Tricks   Overview    Course Topics    Contact NSS   Training Rates  Media Room  Privacy

Copyright 2000-2008. Noble Software Solutions, London, Ontario, Canada. All Rights Reserved.

Logo Designed by Elly Fox Graphic Designer