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 » Queries

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

resolvedResolved · Low Priority · Version 2003

No ranking yet
1 post
replyReplyWed 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?

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

Platinum
870 posts
replyReplyFri 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.


Related articles

· 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


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