Organizing Queries and Reports

[Jan]

Is there any way to organize queries and reports into
folders or some sort of subgrouping?

We manage all box office and donor functions with
Access. The Customer table contains 48,000 records. Two
of us create all the queries and reports, and there are,
probably, 1500 queries stored, dating from 2000. I
hesitate to delete a query for fear there's another query
or report relying on its existence.

If I could organize these in any logical way, my job
would be much easier!

TIA for any ideas,
Jan
Patron Services Manager
Tucson Symphony Orchestra

 

[Lynn Trapp]

The database windows shows all objects in alphabetical order. If you rename
your queries with a prefix for the group it belongs to, then they would sort
into those groups. Of course, if you do this you would need to make sure
that all reports that reference these queries are modified to point to the
queries with the new names.

 

[L Schmandt]

I've been dealing with the same thing and decided to try
using Groups. I haven't used them long enough to decide
if it really helps. Here's the description from Help:

About groups of database objects
You can organize different types of database objects into
a group. For example, you can manage a form with multiple
subforms more easily if you create a group that contains
the main form, the subforms, and the tables or queries
that they are based on. You can also create a group for
the forms and reports that you use most often; when you
click the icon for that group, both the forms and the
reports appear in the Object list in the Database window.

A group consists of shortcuts to the database objects that
belong to it; adding an object to a group does not change
that object's original location. When you click Objects
and then click the icon for a particular object type, any
database object of that type appears in the Object list -
even if that object also belongs to a group. When you
click the Groups bar in the Database window and then click
the icon for your group, all of the database objects that
you have added to the group appear in the Object list.

Deleting a database object shortcut from a group does not
delete the object itself. For example, if you delete a
form shortcut from your group, and then click Forms under
Objects in the Database window, that form still appears in
the list of all forms.