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
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
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
- 542 references viewable online
- Free USB stick containing course files
- Genuine Wise Owl trainers only
- Unbelievably good courseware
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).
Sarah Penn (Sellafield Ltd)
Richard Finn (Edge Hill University)
Stefan Store (Moneybarn Limited)
Claire Howarth (Lex)
Michael King (NICE (National Institute for Health & Care Excellence))
There are lots more where these came from (or just refresh this page to change the quotes shown).
Related Courses
Other Microsoft Access training resources
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 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