Microsoft Access 2016 Query Training Course Outline

Audience: This course is designed for new or self-taught Microsoft Access 2016 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 2016 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

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
, Microsoft Access 2016 Query Training Course Outline
, Microsoft Access 2016 Query Training Course Outline