Microsoft Access 2019 Query Training Course Outline

Audience: This course is designed for new or self-taught Microsoft Access 2019 users. The course will cover all aspects of database queries and reporting.

We are happy to arrange for a trainer to contact you to help tailor you course.

Course Duration: 1 day.

Course Availability: Monday – Saturday

Course Types: Group bookings, public courses, 1-2-1 sessions, bespoke tailored courses and office migrations.

Course Location: This Microsoft Access 2019 queries training course can be delivered either at our London training venue or at your offices. 

Tailored Course Content: Course content can be customised to meet your specific requirements, with scheduled dates to suit you.

At Course Completion

After completing this course, students will be able to:

  • Understand the role of Microsoft Access objects
  • Create Table and Query Relationships 
  • Create fields and tables
  • Understand Select queries
  • Create calculated fields
  • Create Select queries
  • Group queries
  • Create Action queries
  • Create calculated fields
  • Crosstab queries
  • Find unmatch and duplicate queries
  • Union Queries

Course Outline

Module 1: Tables

  • Creating tables
  • Setting field properties
  • Setting the primary key
  • Defining relationships

Module 2: Creating Relationships 

  • Creating Relationships
  • Different Relationship types
  • Viewing subdatasheets
  • Setting referential integrity
  • Cascade options

Module 3: Select Queries

  • Select queries explained
  • Creating select queries
  • Working with query views
  • Adding and deleting fields
  • Sorting records in the Design View
  • Using query criteria
  • Adding calculated fields

Module 4 : Designing Advanced Queries

  • Setting join types between tables and queries
  • Setting top values in a query
  • Creating Calculated fields
  • Creating Summary queries
  • Grouping queries
  • Creating Parameter query

Module 5: Action Queries

  • Update Query
  • Make Table Query
  • Delete Query
  • Append Query
  • Union Query

Module 6: Advanced Query Techniques

  • Working with Join properties
  • Unmatched data
  • Crosstab queries
  • Union queries
  • Find duplicates query
  • Find unmatched query

Module 7: Working in Report Design View

  • Manipulating controls in a report
  • Changing report control properties
  • Adding calculations to a report