Realdolmen Education


Querying MS Access Databases

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

Request Course


1 day(s)


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


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


At the end of this course, students will: understand the terminology involving queries; be able to create and use the different types of queries.


Instructor-led classroom training with hands-on exercises and intensive interaction between instructor and students. Each student disposes of a workstation.


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


  • 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