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

Price: £175 + vat

Dates

Friday 17th May 2024
Monday 17th June 2024
Wednesday 17th July 2024
Friday 16th August 2024
Wednesday 11th September 2024
Monday 14th October 2024
Tuesday 12th November 2024
Friday 13th December 2024