Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

organising queries access

Forum home » Delegate support and help forum » Microsoft Access Training and help » Organising Queries in Access

Organising Queries in Access

ResolvedVersion 2003

Jon has attended:
Access Introduction course

Organising Queries in Access

Is there a way of organising some queries into folders. So that queries relating to a task could be kept together?

RE: Organising Queries in Access

Dear Jon

Thank you for attending Access Introduction course!! I hope you enjoyed the course and benefited from it.

In Access 2007 (the latest version of Office) you have various options in the objects bar such as viewing the tables and related views, by date created, etc.. and you also have the option of creating separate groups where you can simply drag and drop your queries or any objects that relate to that group for organising the objects.

In Access 2003 you can create groups as well. You simply right-click on the group on then choose new group...

Type the name of the New Group e.g. Management

Press OK

Drag and drop the objects (in your case all the relevant or related queries) and drop them in the new group.

Please note that the queries will be shortcuts to the main queries.

So if you just wanted to see the management queries for example you just have to click on the Management group.

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007

Wed 4 Feb 2009: Automatically marked as resolved.

Access tip:

Creating Parameter wildcard queries

To creat a parameter query that also uses a wildcard, in the query design type in like []+*.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.