Access 2003 - Queries Advanced
ACC-03-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:
- ACC-03-01 - Introduction
- ACC-03-02 - Using Forms and Data Input
- ACC-03-03 - Form Design Basic
- ACC-03-04 - Queries Basic
- ACC-03-05 - Reports Basic
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.
