Analysing Data with Access Course

What will I learn?

Our Analysing Data with Access course teaches you how Access can be used as a powerful tool to analyse and report on data imported from Excel.

This course focuses predominantly on queries and data manipulation with only a brief introduction to forms and reporting.

Learn how to:

import data from Excel
work with tables
create relationships between tables
create select queries
create action queries
create basic reports and forms.

To attend no previous experience of Access is required but you should have a good working knowledge of Excel.

Book Analysing Data with Access Training

For companies who need to train groups of staff either remotely or in-person.

One day course
Up to 8 delegates
Flexible in-house training dates

Face-to-face training
In-house or a venue of choice
Virtual training option

Enquire & Book

MEET THE TRAINER

Paul Watson

Paul brings a wealth of understanding and knowledge, specialising in technical training and development in Excel, Power BI and Access. His knowledge with IT systems has been gained both academically and through more than 20 years practical experience in the industry. His strengths are demonstrated as both an IT trainer and as a developer.

Full Analysing Data with Access Course Content

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

Enquire & Book

Access Training – Business Benefits

By investing in people, you can give your team all the necessary skills they need to help support your organisation’s goals.

Access Training - People Development

Completing our Access training course will give you additional skills you need to help support your career development.

Flexible Access Training Courses

Online or face-to-face in-house training
Individual delegates or group training
Flexible dates to fit schedules

BOOK YOUR ACCESS TRAINING

Why choose TrainingU?

Passionate

Established over a decade ago by a team of knowledgeable training experts, we are passionate about delivering excellent training that makes a real difference.

Experienced

All our trainers are qualified and experienced Access trainers that will deliver the highest level of training to you and your team.

Collaborative

Working together with our clients, understanding their needs and desired learning outcomes, to deliver a personalised learning solution.

Your complete training solution

Before Training

Our Skills Assessment will ensure staff attend the correct level of training. Based on results, we will organise the training sessions required, who will take them and the level to best match the skills needed.

During Training

We provide first class training with highly experienced trainers. Courses include lots of exercises, practise and interactivity throughout, maximising learning whether delivered online or at your offices.

After Training

We will grant you organisation free access to our suite of online Access resources. In addition, we provide free post training support to ensure your staff utilise their new skills effectively.