Realdolmen Education

Details

Access Module 2 - Querying Databases

This course is currently not scheduled on the open calendar, but can be organized on request.

Request Course

Duration

1 day(s)

MS Access : Module 2 – Querying databases

Duration

1 day

Audience

The course is intended for all users who want to query MS Access databases.

Prerequisites

Knowledge of creating MS Access databases, tables and relationships is required. A good knowledge of working in a Windows environment and file management is necessary. Knowledge of MS Excel or other database programs is an advantage.

Objectives

Understand the terminology involving queries. Being able to create and use the different types of queries.

Methods

Instructor-led classroom training with hands-on exercises and intensive interaction between instructor and students.

Description

The scope of this is course is limited to the Query object.

Contents

  • Review of databases, tables and relationships
  • Types of queries
  • Creating Select queries
    • Tables and fields
    • Sorting
    • Criteria
  • The query result
  • Formulas in queries
  • Creating and using parameter queries
  • Action queries
    • Make Table
    • Delete
    • Update
    • Append
  • Query wizards
    • Crosstab queries
    • Find Duplicate Records
    • Find Unmatched records
  • Join types (equi-join, outer join, self-join)
  • Union Query
  • Query properties