Advanced Querying in Access 2003

Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number

---

Overview/Description
To use advanced queries such as joins, parameter, action, and SQL queries

Target Audience
Anyone wishing to become familiar with Microsoft Access 2003 at an advanced level; students seeking to obtain Microsoft Office Specialist certification in the use of Microsoft Access 2003

Prerequisites
The Microsoft Office 2003: Beginning Access 2003 learning path; familiarity with any Windows user environment

Expected Duration (hours)
1.7

Lesson Objectives

Advanced Querying in Access 2003

use joins and parameter queries to obtain specific data.

use an action query to modify records.

use action queries to delete and copy data.

edit a SELECT query using SQL.

create queries to combine, update, and filter data.

Course Number:
126944_eng