Courses

Access Data Analysis & Reporting

= Scheduled class    = Guaranteed to run    = Fully booked

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.

Prerequisites

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.

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

Tools
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