21 British American Blvd.
Latham, NY 12110
Microsoft Access is great, but there’s a common problem I see whenever I’m handed a database from a client: organization. Is your database filled with objects cluttering up the Navigation Pane as far as the hand can scroll? Or perhaps you have more than 50 queries with helpful names such as CMP2a or qryEverythingInThisTableExceptThisAndThat?
This is the need that Custom Groups seeks to fill. The way Custom Groups work is to let you create organizational buckets, like folders, to hold and contain your related objects. Then you simply drag and drop your objects into these buckets. This simple step can save you tons of headaches.
Most Access databases already organize objects into groups based on the object type: Tables, Queries, Forms and Reports. One grouping alternative may be to elaborate further on these headings, such as Tables, Lookup Tables or Forms, Subforms and Lookup Forms. Or you can group related items together if they all contribute to the same end output, such as placing 3 queries and a report into an Event Report group. Even simply making a group for I Don’t Know What These Do can help reduce the clutter!
To create your own groups you first have to switch to Custom view and type in your group names.
1. Click the down arrow at the top of the Navigation Pane and choose Custom.
2. At the top of the Navigation Pane, right click on Custom and choose Navigation Options. The Navigation Options dialog appears.
3. Click on the Custom category, then click the Add Group button to start creating your own group names. Click OK when finished.
4. All your Access objects will now appear in one group called Unassigned Objects. Simply drag and drop them into their new groups.
Now, if you could just forward this tip to everyone you know who uses Access, it’d make my life much easier.
Author: Ryan Donelan
Remember, if you are a MicroKnowledge customer and have a software question to ask, feel free to contact us at any time by using our Support link at the top of the site. Your question might be featured in our next blog entry!
Do you have a related tip to share? Leave a comment. We’d love to hear from you!
Category: Tech Tips