Querying MS Access Databases
This course is currently not scheduled on the open calendar, but can be organized on request.Request Course
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.
- 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
- Outer join
- Self join
- Query properties