queries

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » Queries

Queries

resolvedResolved · Low Priority · Version 2003

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?

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.


 

Access tip:

Compact database automoatically

To ensure optimal performance, you should compact and repair your

Open the Access database or Access project that you want Access to compact automatically.
On the Tools menu, click Options.
Click the General tab.
Select the Compact on Close check box.

View all Access hints and tips


Server loaded in 0.09 secs.