Classroom Training

Microsoft Access Querying

Available as classroom training course only

£375 + VAT for most venues (£495 + VAT for London)

1 day

This one-day course is aimed at people who don't know how to use Access, but have a database that they want to interrogate. The course explains the principles underlying your corporate database (if you bring a copy in, we'll do much more than this), then shows how to create queries to get at the data it contains. Learn how to select data, how to aggregate it and how to create expressions, then at the end of the course see a brief introduction to how forms and reports work.

We don't have any dates scheduled for this course, but we may well consider adding them - it's always worth asking.

Alternatively, you could enquire about running the course in your office or even (if available) as a tailored online course.

Course Contents - PDF

Course Contents

The contents of this course are as follows:

Designing a database

Identifying the tables
What are relationships?
Setting a primary key
Using multivalue fields

Creating tables

Defining fields
The types of field
Entering data

Covered if time allows If time

Drawing relationships

Creating relationships
Referential integrity

Creating queries

The query design grid
Sorting
Setting criteria
Combining criteria

Advanced queries

Grouping and totalling
Creating expressions
Parameter queries

Covered if time allows If time

Joins

Creating ad hoc joins
Types of join

Creating forms

Layout and design view
Using the form wizard
Split forms
Creating controls

Creating reports

Using the report wizard
The group, sort and total pane
Report design

You should already be a confident Windows user to attend this course, but do not need to have used Access before. Note that most people find Access harder to learn than Excel.

Why Choose Us?

No more than 5 people per class
Proper restaurant lunch included
535 references viewable online
Free USB stick containing course files
Genuine Wise Owl trainers only
Unbelievably good courseware

View full list of benefits

Sample customer feedback

Our thanks to everyone who agreed to share their thoughts (note that some of these reviews may be for our online courses).

"Good that there are varying levels of exercises for those to go ahead with during the course and nice to have practice for each section that is taught."

Sophie Carder-Jones (Hertfordshire Constabulary)

"Excellent course. Very good pace and examples."

Colin Halliday (North West Ambulance Service)

"Exactly what is required."

Paul Horwood (First Ark)

"The course went very well and has given me a good insight into the SQL scripts and data extraction. The course structure was very good and covered a lot of the processes that I was unsure about. The trainer was great and made sure we were all progressing through the training sessions together, and was more than happy to explain any questions we had, or processes we did not understand. I have now been able to put into practice what I have learned from the course. "

Jaik Joseph (Derby and Burton Hospitals NHS FT)

"Loved the Power BI training and our trainer was excellent, fun and full of life, could improve his jokes though! The course was fast paced and covered a lot of content, lots of useful tips and examples."

Lesley Munro (The City of Liverpool College Group)

There are lots more where these came from (or just refresh this page to change the quotes shown).