Access Module 2 - Querying Databases
This course is currently not scheduled on the open calendar, but can be organized on request.Request Course
MS Access : Module 2 – Querying databases
The course is intended for all users who want to query MS Access databases.
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.
Understand the terminology involving queries. Being 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.
The scope of this is course is limited to the Query object.
- Review of databases, tables and relationships
- Types of queries
- Creating Select queries
- Tables and fields
- The query result
- Formulas in queries
- Creating and using parameter queries
- Action queries
- Make Table
- Query wizards
- Crosstab queries
- Find Duplicate Records
- Find Unmatched records
- Join types (equi-join, outer join, self-join)
- Union Query
- Query properties