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.

About this Course

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.

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.

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

 Print this page