Access Data Analysis & Reporting
Overview
This course is designed for users of Microsoft Access that have completed our Access Essential Skills course or have equivalent experience.
Our aim is to provide you with the skills necessary to analyse data and enhance reports.
It is important that you use your new skills as soon as possible on completion of this training course. We encourage you to take your own notes, and to review the Course Guide once you are back at your workplace.
This course in conjunction with Access: Essential Skills and Access: Creating Applications covers the material examined in the Microsoft Office Specialist Access Core exam.
Who should attend
Current users of Microsoft Access that have completed our Access Essential Skills course or have equivalent experience and want to analyse data and enhance reports.
Prerequisites
We require that students have either:
- Completed Access Essential Skills and practised recently with topics covered in this stage
or
- Have equivalent experience using Access and a sound familiarity with other Microsoft packages, particularly Excel.
What you'll learn
This course takes you from using Queries for answering simple questions about records, to advanced statistical analysis of records. This course is for the analyst who uses Access and Excel regularly, but finds too much of their time spent getting data to Excel for analysis when Access can do it, if only they knew how.
Course content
- Revising the Essential Skills
- Extending the Essential Skills
- Crosstab Query
- Make Table Query
- Append and Delete Queries
- Update Query
- Functions in Query Calculations
- Join Types
- Enhancing Access Reports
- Main/Sub Report
Common questions
When does Access Data Analysis & Reporting next run?
The next date is Tue, 13 Oct 2026, and there are 4 further dates scheduled. Delivered ACE Training Auckland, ACE Training Hamilton, ACE Training Christchurch, ACE Training Wellington. Every date and its format is listed on this page.
How much does Access Data Analysis & Reporting cost?
From $475 + GST per person. Pricing can differ by date and location, so check the option you want before booking.
Do I need any prior experience?
We require that students have either: Completed Access Essential Skills and practised recently with topics covered in this stage or Have equivalent experience using Access and a sound familiarity with other Microsoft packages, particularly Excel.
Can I attend online, or does it have to be in a classroom?
Both. Some dates run live online and others in-class — each date on this page shows its format, so pick whichever suits.
Can you run this course for my team?
Yes. Any ACE course can be delivered in-house at your workplace and tailored to your team's tools and goals — quote course code Access-Data-Analysis-and-Reporting when you enquire.