Realdolmen Education

Details

Querying MS Access Databases

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

Request Course

Duration

1 day(s)

Audience

The course is intended for users who wish to use MS Access to query databases.

Prerequisites

Knowledge of creating MS Access databases, tables and relationships is required. A good knowledge of Excel is a great advantage.

Objectives

At the end of this course, students will: understand the terminology involving queries; be 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. Each student disposes of a workstation.

Description

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

Contents

  • Introduction
    • Review of databases, tables and relationships
  • Queries
    • 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
    • Query properties