Queries

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

Resolved · Low Priority · Version 2003

1 post

ReplyWed 20 May 2009, 14:06Delegate Ian said...

Ian has attended:
Access Introduction course

Queries

What Access course level is best to learn how to write my own queries for a system that is Access based using different tables?

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

ReplyFri 22 May 2009, 09:14Trainer Rajeev said...

RE: Queries

Dear Ian

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

I would recommend you to look into SQL (Structured Query Language) as it is the most common language used for extracting certain records in various database applications.

We do cover basics of SQL but if you are looking into creating complicated queries using SQL I would request you to put that in one of the post or call our inquires to find out if we can cater your needs!!

If you want to learn about the SQL statements the best thing to do would be create the query you want and then simply choose the SQL view from the View Button.

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

Thu 28 May 2009: Automatically marked as resolved.

· Why a Microsoft Access Course Could Change the Way You Do Business
· Get More Out of MS Access Courses
· Be Top Of The Form With Access 2007
· Quick Microsoft Access Course: Creating an Inventory Control Database in 8 Simple Steps
· Access Corruption Avoidance Tip #3: Stay Connected

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

Access tip:

Zoom feature for queries

If youare working on on query design and creating a calculated field, it can be hard to view the whole statement. You can hold the shift key down and press F2, to show the zoomed up version of the query field

View all Access hints and tips

All prices offered for business users and exclude VAT. E&OE · Terms and Conditions

Queries

Queries

RE: Queries

Related articles

Access tip:

Zoom feature for queries