What will I learn?

Full Course Details

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
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.
Read More

Full 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
Excel Training Business benefits

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.

Excel Training Business benefits

Access Training - People Development

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

Excel Training Business benefits

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?

Excel Training Business benefits

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.

Excel Training Business benefits

Experienced

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

Excel Training Business benefits

Collaborative

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

Your complete training solution

Excel Training Business benefits

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.

Excel Training Business benefits

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.

Excel Training Business benefits

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.

Our Clients

International SOS Pioneer DJ

Enquire & Book Access Training

Simply fill out the contact form or call 0333 344 6630 to make an enquiry or book your Access training.