Access 2010 - Queries Advanced
ACC-10-08
Duration
2 hours
Who should attend?
Anyone who needs to create more complex queries to perform tasks such as copying, deleting, updating data.
Pre-requisites
Attendees should have experience of creating forms using the Forms Wizard and of creating basic queries. Familiarity with the topics covered in modules:
Objectives
To design queries to perform tasks with the data in a database.
Course Content
Overview
The different types of query: action, select and crosstab.
Calculations
Create calculations (text and numeric functions) in queries. Queries based on other queries. Links in a query.
Action Queries
Use of action queries to update, delete or archive data. Make new tables and move data between tables automatically.
