Query names access 2007

The UK's most regular instructor-led training courses.
Training information: advanced access training · Access course microsoft training · Microsoft Access Training
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version 2007

2 posts

ReplyMon 8 Jun 2009, 14:51Delegate Craig said...

Craig has attended:
Access Introduction course
Access Intermediate course

Query names access 2007

After having created and named a query, can I rename it at a later date in Access 2007?

Thanks.

Version	Date	Location	Places available	Book	Next place rate (£)
Access VBA 2 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2003	Wed 24 + Thu 25 Mar 2010	Southwark	8		£445	£450
2003	Wed 5 + Thu 6 May 2010	Bloomsbury	10		£275	£280
2003	Mon 28 + Tue 29 Jun 2010	Bloomsbury	10		£275	£280
2003	Wed 4 + Thu 5 Aug 2010	Bloomsbury	10		£275	£280
2003	Thu 9 + Fri 10 Sep 2010	Bloomsbury	10		£275	£280
2003	Wed 27 + Thu 28 Oct 2010	Bloomsbury	10		£275	£280
Full Schedule: See all 7 Access VBA course dates. Bookings currently available until 6th December 2010.

870 posts

ReplyTue 9 Jun 2009, 06:05Trainer Rajeev said...

RE: Query names access 2007

Dear Craig

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

Yes it possible to rename the query after saving it.

Please ensure that you close the query first. Then simply right click on the query that you wish to rename and choose rename from the short cut menu. Or alternatively you can click on the query and press F2 key on the keyboard and give the new name.

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
MCT

· Microsoft Access and Customer Surveys
· Microsoft Access Flaws and Ways to Overcome Them
· Want to Become the Office Hero? MS Project Training Could be the Answer
· Data validation in MS Access
· Access VBA Handling Errors and Debugging Code

Please browse our web site to find out more about
advanced access training and other Microsoft training courses.

Access tip:

Hiding Multiple Table columns

If you want to hide non-adjacent Access table columns. In Datasheet view, open the table that contains the columns you want to hide.

On the Format menu, click Unhide Columns.
In the Unhide Columns dialog box, clear the check box next to the name of each column you want to hide.
Click Close.

This method makes having to use the Hide Columns command repeatedly unnecessary

View all Access hints and tips