Microsoft Office training - Access Querying

Access Training

Microsoft Access Querying Training Course

£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 (or consider an onsite Access training course).

Course Contents - PDF

Course Contents

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

Why Choose Us?

No more than 6 people per class
Proper restaurant lunch included
491 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

"I did very much enjoy the course. The pace was good and there was plenty of opportunity to ask questions. I was slightly worried beforehand that I may be in the minority and there would be many things that I wouldn’t understand, but the group meant that this wasn’t a problem. I now need to have time to practice what I’ve learnt! Lunch in a restaurant was good too, it made a good break in the day to clear the mind for the afternoon session. Many thanks for all your help. I will certainly bear you in mind for any further training we may need. "

Ginny Lefebvre (Aiglon College)

"Very good course content and trainer, great venue."

Philip Goudal (Southbank Centre)

"I attended the 2 Day SSRS course in London this week. Just wanted to say a big thank you - the content and pace was excellent. The trainer was very engaging and knowledgeable - happy to help with off topic questions. Would definitely use you guys again."

Alison Atterbury (Collinson Group)

"Well structured, interesting and just the right level of excel humour."

Dan Charlish (Tech21)

"Great that we have course manuals. Content great, great pace. Excellent trainer willing to customise learning. Recommended by two colleagues. Will recommend."

Aiden Lonergan (The Christie NHS Foundation Trust)

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

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.