AUCKLAND (09) 378-0411       HAMILTON (07) 838-0700       WELLINGTON (04) 472-4830      CHRISTCHURCH (03) 365-5020      |      
Home Courses Access Data Analysis & Reporting


Access Data Analysis & Reporting

Length: 1    Cost: $375 + GST    Version: Access

= Scheduled class    = Guaranteed to run    = Fully booked
Click on the dates to book online

Can't find a class in your area? Contact our sales team and request a class date.
Not sure about the version of your software? Click here to find out.
Want to know if this course is right for you? Assess your skills level with our online Skills Assessment tool.


Completion of the Access Essential Skills course in conjunction with having practiced the topics covered. Or equivalent experience. Specifically, creating queries, including criteria and reports.

At Course Completion

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 Outline

Revising & Extending the Essential Skills
Having shown you how to make select queries on the Essential Skills course, we now show you how to build on those skills to answer a higher level question.

Further Queries
By now we should be comfortable with the mechanics of creating a query. So now we look at the Crosstab Query, the Action Queries, Finding Unmatched Records and look at some of the ways to calculate figures in a query.

Just as with the queries, here we build on the skills learnt in Access: Essential Skills. We will show you how to enhance your reports and even how to include a report within a report.

Do you want your database to take up less space on your hard drive or even within your e-mail message? Do you want it to run more efficiently?

 Print this page