Microsoft Access Masterclass Training

Many organisations have large databases in Access that have built up over the years; staff have learned enough to build a database with a good relational structure, create forms to enter data and write queries to generate some useful reports.

Advanced Microsoft Access Training

However, when databases get big making your queries and forms effective can become more complex and it is worth investing in Microsoft Access Masterclass training to get the most from your data and save time.

Our Microsoft Access Masterclass course teaches delegates how to analyse data by creating complex queries, make forms and reports more efficient, speed repetitive tasks by creating macros.

If you are a looking for training specific to your business, we can provide private and in-company Microsoft Access Courses. Call us on +44 (0)1273 622272 to discuss your needs.

Prerequisites

There are no prerequisites for this course. 


Course Objectives

By the end of this MS Access Masterclass training course, delegates will be able to:

  • Demonstrate an advanced understanding of Microsoft Access
  • Design advanced queries, forms and reports
  • Use macros to increase productivity and perform advanced functions

Who is this course for?

This course is aimed at Microsoft Access users who want to expand their knowledge to include advanced techniques and macros.

Introduction

  • Review of basic concepts:
  • Design concepts
  • Relationships between tables

Designing Queries

  • Using And and Or statements
  • Totals Queries
  • Creating calculations in queries
  • Parameter Queries
  • Autolookup Queries

Designing Forms

  • Adding controls
  • Working with combo boxes
  • Working with calculated controls
  • Control properties
  • Working with subforms

Report Design

  • Creating a report using the Wizard
  • Designing grouped reports
  • Adding sub-totals to reports

Macros

  • Creating simple macros
  • Creating grouped macros
  • Creating conditional macros
  • Assigning macros to command buttons
  • Creating a Switchboard
  • Using macros to pass conditions between forms
  • Using macros to pass conditions to run reports

Steve understood exactly what I was trying to do. the course was personalised and progressive - excellent step by step method.

Andie Davidson - Mecmesin Ltd

Great teaching - very enjoyable & helpful.

Claire Thackway, Brighton College

Feel I have had a rounded introduction to Access, which is exactly what I required from the course. Very friendly and patient trainer who ran the course at a flexible pace

Paul Clarke - Hampshire Probation Trust

Keypoints

keypoints

Starting Price:£1095

Duration:1 Day

Microsoft Access Masterclass Training Calendar

Filters

Select Your Course

Select Your Location

Select Delivery Method

Keypoints

keypoints

Starting Price:£1095

Duration:1 Day

Microsoft Access Masterclass Training

Best Selling Course in UNITED KINGDOM

flag

Middlesbrough, UNITED KINGDOM

duration

Duration : 1 Day

dates

22 Mar 2024

£2995

Microsoft Access Masterclass Training

Best Selling Course in UNITED KINGDOM

flag

Wakefield, UNITED KINGDOM

duration

Duration : 1 Day

dates

22 Mar 2024

£2995

Microsoft Access Masterclass Training

Best Selling Course in UNITED KINGDOM

flag

Stoke-on-Trent, UNITED KINGDOM

duration

Duration : 1 Day

dates

22 Mar 2024

£2995

Microsoft Access Masterclass Training

Best Selling Course in UNITED KINGDOM

flag

Chester, UNITED KINGDOM

duration

Duration : 1 Day

dates

22 Mar 2024

£2995

Microsoft Access Masterclass Training

Best Selling Course in UNITED KINGDOM

flag

Buxton, UNITED KINGDOM

duration

Duration : 1 Day

dates

22 Mar 2024

£2995

Microsoft Access Masterclass Training

Best Selling Course in UNITED KINGDOM

flag

Teesside, UNITED KINGDOM

duration

Duration : 1 Day

dates

22 Mar 2024

£2995

Microsoft Access Masterclass Training

Best Selling Course in UNITED KINGDOM

flag

Virtual, UNITED KINGDOM

duration

Duration : 1 Day

dates

12 Apr 2024

£995

Microsoft Access Masterclass Training

Best Selling Course in UNITED KINGDOM

flag

Virtual, UNITED KINGDOM

duration

Duration : 1 Day

dates

14 Jun 2024

£995

Microsoft Access Masterclass Training

Best Selling Course in UNITED KINGDOM

flag

Virtual, UNITED KINGDOM

duration

Duration : 1 Day

dates

16 Aug 2024

£995

Microsoft Access Masterclass Training

Best Selling Course in UNITED KINGDOM

flag

Virtual, UNITED KINGDOM

duration

Duration : 1 Day

dates

18 Oct 2024

£995

Microsoft Access Masterclass Training

Best Selling Course in UNITED KINGDOM

flag

Virtual, UNITED KINGDOM

duration

Duration : 1 Day

dates

20 Dec 2024

£995

Microsoft Access Masterclass Training

Complete the steps below to receive a quote or more information

Enter Your Details

What is your name?*
user
Course Name
course

How Many Employees Need Training?

Enter More Details

call
company
address
message

When Would You Like to Take the Course?

Add Additional Features

6 Months Access - £219
1 Year Access - £439

Your Online (Microsoft Access Masterclass Training) Package

Upon purchase you will receive a password via the email you used to purchase the course.

You will then be able to login to our online learning platform with your email and password.

You will have access to the platform for 90 days to complete your course.

Enroll Now for Our Online Course

£1095

enquire Enquire Now
meeting

Upcoming Dates

Onsite Training

Our Onsite/In-house Training method is most selected by organisations, as it allows them to train their employees at their choice of place. We can also tailor the course content to focus on your needs.

Leading Path to Success

step-1

Find a course and let us know how you would like to learn.

Step 1

step-2

Select your preferred method of training for the course.

Step 2

step-3

Confirm your seats.

Step 3

step-4

Get an excellent experience with our qualified instructors.

Step 4

step-5

Acquire skills and achieve your career goals.

Step 5

460+

Courses

92+

Locations

126K+

Learners

Some Facts Worth Shouting About

To win in this competitive world, you need to be constantly moving forward, and Silicon Beach Training is the one that can help you. Our courses are highly engaging as we have high-quality and certified training courses for both individuals and organisations that are structured in easy to digest modules. We don't compromise on the quality of our trainers. We have:

Our Clients

With extensive experience working with large organisations, national and local government, universities, charities, SMBs and individuals we believe that no client is too big or too small. This creates a diverse atmosphere on our scheduled courses with the opportunity to discuss solutions for a wide range of problems. We excel at developing bespoke training solutions for prestigious clients including EDF Energy, Sport England and Tesco PLC.

Banco Central Do Brasil

Nationwide Building Society

EDF Energy

EDF Energy

Sport England

Sport England

Tesco PLC

Tesco PLC

Imperial College London

Imperial College London

Request info Get Free Advice Quick Enquiry
LOADING