COVID-19: Choose between our familiar (but now socially distanced) classroom training courses and our excellent new live online courses.
Classroom training -  Access Querying

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

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?

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).

"Enjoyed the pace, content, manuals & exercises. Great!"

Deji Benson (Amigo Loans)

"Very enjoyable, informative course. Good value for money and well put together."

Dan Milton (Howard Kennedy)

"Best training I have ever received on any subject at any point! Trainer very engaging, encouraging and knowledgeable. Course recommended by all colleagues."

Danny Hopton (Derbyshire County Council)

"Great course, informative and thought provoking. Full of content and exercises are a great way to practice what you've been learning about. Wonderful course materials to help you after - and let's not forget the lunches. (I have received training from you previously.)"

Sarah Kenn (National Fostering Agency (NFA))

"Trainer was very good and engaging. Great course. Loved it."

Kirsty Robertson (Hertfordshire Constabulary)

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

Related Courses

Access Developers RECOMMENDED

Introduction/Intermediate

3 day course

Access VBA macros

Advanced

2 day course

Other Microsoft Access training resources

Access exercises

Access exercises

If you're just starting to teach yourself Access, have a look at our Access exercises to see if they're for you!

View Access VBA or Access 2010 exercises

Access skills assessment

Access skills assessment

You can assess how well you know Access by doing one of our tests online.

View Test your Access skills skills assessment tests

Access blogs

Access blogs

Have a look at some of our blogs on Microsoft Access, which are full of little nuggets of information!

View Access or VBA macros blogs

This page has 0 threads Add post