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.