Access Query Writing – Microsoft Training Course

Book this course

Course description

We show you all the tools and techniques you need to understand in order to quickly, easily, and accurately extract data from Microsoft Access, enabling you to be more efficient and effective in your role.

Is it right for me?

Whether you’re a new or existing Access user, this Access training course will provide you with the skills and knowledge to write and use queries that can extract information from databases.


Very knowledgeable and enthusiastic. He had taken the time to understand our backgrounds and what we would use Access for.  The exercises were good and as there were extra exercises, we could work at our own pace.  The venue and food were excellent.

Scientific Officer, Home Office

What does it cover?

  • Database objects
  • Table structure
  • Keys and indexes
  • Relational databases
  • Extracting data using select queries
  • Setting criteria
  • Creating parameter queries
  • Calculations in queries
  • Linking tables in queries
  • Join types
  • Creating queries to find unmatched data
  • Top values queries
  • Unique values queries
  • Formatting query output
  • Adding totals to your queries
  • Building crosstab queries
  • Using make table queries
  • Using delete queries
  • Using append queries
  • Using update queries
  • Purpose of a union query
  • Union query rules
  • Using the duplicates query wizard
  • Eliminating duplicates using an append query
  • Finding differences between tables

Book this course

Other recommended courses

Show more courses +

Course leader

Richard Harker

Technical & Digital Learning Consultant

Need a bespoke solution?

Talk to us about setting up a course that is tailor made for you.

Recent blog posts

Developing Strategic Leadership

It doesn’t matter how long you’ve been in a leadership role, there is always something new to learn...

Press Coverage

Supporting the agents of change

Change is scary, at least for a lot of people it is. It creates uncertainty and a sense of unease, especially when it’s sudden or not handled correctly...

Enhance Magazine