Analysing Data with Access

Analysing Data with Access

1 Day

This course is designed to provide delegates with the knowledge of how Access can be used as a powerful tool to analyse and report on data, imported from Excel. This course mainly focuses on queries and data manipulation with only a brief introduction to forms and reporting.


On completion of this course attendees will be able to: Import data from Excel, Work with Tables, Create relationships between Tables, Create Select Queries, Create Action Queries, Create basic Reports and Forms.


Attendees do not need any previous experience of Access but must have a good working knowledge of Excel.


Courses are delivered in 2007, 2010, 2013, 2016.

What will I learn?
Database Introduction
  • - Relational database concepts and terminology
  • - Getting started in Access
Importing Data
  • - Importing data from Excel
Working with Tables
  • - Table properties
  • - Setting a primary key
  • - Sorting and filtering records
Table Relationships
  • - Creating relationships between Tables
Select Queries
  • - Select queries
  • - Parameter queries
  • - Calculated queries
  • - Multi table queries
Action Queries
  • - Make table queries
  • - Delete queries
  • - Append queries
  • - Update queries
Introduction to Forms and Reports
  • - Creating basic Forms and Reports
Related courses
Run this
course at
your offices
Request a quote
Speak to a friendly advisor


0333 344 6630

or visit our

Online Chat