Advanced Querying in Access 2003

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


100 Minutes

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