Call us today: 0800 028 3045
NEW! Microsoft Access Query Writing Training Course
What does it cover?
Our Access Query Writing course is designed for new or existing users of Microsoft Access who need to write and use queries for extracting information out of databases. It covers query writing techniques for quick, easy and accurate data extraction. You should be competent in using a PC for general business use, familiarity of Access would be an advantage.
What will I get out of it?
By the end of the course you will be able to:
- Create select queries from multiple tables
- Include calculations and parameters in queries
- Create unmatched queries
- Create action queries to manipulate data
- Create de-duplication queries
Versions available
2003, 2007, 2010
Related courses in our range
What does it cover?
The database structure
- Database objects
- Table structure
- Keys and indexes
- Relational databases
Query writing principles
- Extracting data using select queries
- Setting criteria
- Creating parameter queries
- Calculations in queries
Multi table queries
- Linking tables in queries
- Join types
- Creating queries to find unmatched data
Query options
- Top values queries
- Unique values queries
- Formatting query output
Summary queries
- Adding totals to your queries
- Building crosstab queries
Action queries (Part 1)
- Using make table queries
- Using append queries
Action queries (Part 2)
- Using delete queries
- Using update queries
De-duplication techniques
- Using the duplicates query wizard
- Eliminating duplicates using an append query
- Finding differences between tables
Course Summary
Send to a colleague
Please enter details below and click 'submit'
Tailor this course
If you are interested in this course but would like it tailored to your specific needs, contact Karen Osborn on 0800 028 3045.
Alternatively, enter your details below and one of our team will contact you.
Thales Training & Consultancy is a highly successful training services company based in Crawley. We help companies to develop advantage through learning and development. Highly trusted by leading enterprises, we deliver a full range of dedicated training solutions that enable organisations to achieve key business goals. The 4 core services we offer are Training Courses, Supply Management, Bespoke Services and Managed Services. Our successful partnerships with clients prove that the delivery and management of the right training and development can significantly enhance the pursuit of business excellence.
