importing queries
Microsoft Office TrainingThe UK's Number 1 for Microsoft Office Training add this page to your favourites/bookmarksBookmark page

view a printable version of this pagePrintable version
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Importing queries from 2003

Importing queries from 2003

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

resolvedResolved · Medium Priority · Version 2007

No ranking yet
3 posts
replyReplyMon 8 Jun 2009, 14:51Delegate Alan said...

Alan has attended:
Access Introduction course
Access Intermediate course
Excel Intermediate course

Importing queries from 2003

Can I import existing queries from 2003 when I upgrade from 2003 to 2007?

Access Advanced 1 day course
Version Date Location Places
available
Book Next place rate (£)
Pay by
Card
Pay by
Invoice
2003 Fri 19 Mar 2010 Bloomsbury 4 Book now £235 £240
2007 Wed 24 Mar 2010 Bloomsbury 5 Book now £240 £245
2003 Tue 6 Apr 2010 Southwark 9 Book now £203 £208
2007 Thu 13 May 2010 Bloomsbury 7 Book now £188 £193
2003 Tue 18 May 2010 Bloomsbury 9 Book now £182 £187
2003 Fri 2 Jul 2010 Bloomsbury 7 Book now £85 £90
Full Schedule: See all 11 Access Advanced course dates.
Bookings currently available until 14th December 2010.

Platinum
870 posts
replyReplyTue 9 Jun 2009, 06:46Trainer Rajeev said...

RE: Importing queries from 2003

Dear Alan

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


Please remember that you can open an earlier version database in Access 2007 and then choose Office button and save it as 2007 version.

This will ensure all your database objects get saved as 2007 version.

If you want only specific queries to be imported into Access 2007 then you can choose the External Data Tab on the Ribbon. Then in the Import group you can choose the Access button and import the objects from the relevant database.

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

Mon 15 Jun 2009: Automatically marked as resolved.


Related articles

· Have You Ever Wanted To Create A Combo Control On An Access Form?
· Take an Access Course to Learn About Relational Databases
· Use Microsoft Access to manage your work/life balance
· How Reorganising Your Data Can Take Your Business to the Next Level
· When To Use Access, When To Use Excel

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

Access tip:

Add date to a field

Press CTRL+SEMICOLON

View all Access hints and tips


Rate this page:
2.1/5 (108 votes cast)
Institute of IT Training - Accredited Training Provider ILM
Microsoft Certified Partner
Microsoft Office Specialist Authorised Testing Centre (MOS and MCAS)

Prodigy Platinum Learning Partner

Institute of IT Training - Accredited Training Provider
McAfee Secure sites help keep you safe from identity theft, credit card fraud, spyware, spam, viruses and online scams
Association of Computer Trainers verified by visa, mastercard securecard