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