Access Working With Queries

This course focuses on the role of the database designer in the specification and creation of queries and will cover Access queries in detail. Covering both the theory and practicalities of query design this course takes the delegates through the various queries available in Access. It will explain the theory and practical elements of select, multi-table and action queries, ensuring a comprehensive understanding of this particular type of Access object.

Having designed and created perfect tables to ensure that data has been entered consistently, a logical progression is to create Queries to select and manipulate the data. Users typically either struggle or rely on technical IT users to create queries for data analysis. Being able to create ad-hoc statistics or simple selection criteria for others; and understanding how to query any database is an advantageous skill set.

 

One Day Course 

Course Outline (PDF)

Course Objectives:

  • Understand the theory behind queries
  • Create technical specification/requirement documents for developers
  • Convert specification/requirement documents into real solutions
  • Transferable skills to other database applications
  • Start to build knowledge of SQL
  • Be able to link tables in a query
  • Create simple & complex criteria
  • Perform statistical analysis on the data
  • Practical examples of good and bad queries
Microsoft Access Logo Dark Red
Price: £175 + vat

Dates

  • Tuesday 21st January 2025
  • Monday 17th February 2025
  • Wednesday 19th March 2025
  • Monday 14th April 2025
  • Thursday 15th May 2025
  • Thursday 19th June 2025
  • Thursday 10th July 2025
  • Monday 18th August 2025
  • Monday 15th September 2025
  • Thursday 16th October 2025
  • Tuesday 18th November 2025
  • Tuesday 9th December 2025
Back to all Courses