Microsoft Access Queries 1/2 day Workshop


Date(s) - 31/10/2019
1:30 pm - 4:30 pm

Glasgow Training Centre


Microsoft Access Query Workshop

Audience: This short half day session is ideal for those who wish to interrogate existing Access databases, create queries and manipulate database data through action queries.

Course Duration: 1/2 day (0.5)

Select Queries

  • Select queries explained
  • Creating select queries
  • Working with query views
  • Adding and deleting fields
  • Sorting records in the Design View
  • Understanding Join Types between data sets
  • Using query criteria
  • Adding calculated fields

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 queries

Action Queries

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


Bookings are now closed for this event.