For training call 07702 166301

Your basket is empty View Cart shopping cart

Microsoft Access Masterclass Training

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

Andie Davidson - Mecmesin Ltd

MAKE AN ENQUIRY Download Course Outline

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

Course Feedback

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

Microsoft Access Masterclass Training Course Content

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

Booking

* Required

For in-company or private training please request a quote

 
 

Course Details

  1. Course Title

    Microsoft Access Masterclass Training

  2. Duration

    1 Day

  3. Price Starting From

    £695.00 + VAT

Upcoming Dates

Aberdeen, UK

  1. 23 Mar 2018
  2. MORE DATES

Belfast, UK

  1. 23 Mar 2018
  2. MORE DATES

Birmingham, UK

  1. 23 Mar 2018
  2. MORE DATES

Bournemouth, UK

  1. 23 Mar 2018
  2. MORE DATES

Brighton, UK

  1. 23 Mar 2018
  2. MORE DATES

Bristol, UK

  1. 23 Mar 2018
  2. MORE DATES

Cambridge, UK

  1. 23 Mar 2018
  2. MORE DATES

Cardiff, UK

  1. 23 Mar 2018
  2. MORE DATES

Dublin, UK

  1. 23 Mar 2018
  2. MORE DATES

Edinburgh, UK

  1. 23 Mar 2018
  2. MORE DATES

Glasgow, UK

  1. 23 Mar 2018
  2. MORE DATES

Leeds, UK

  1. 23 Mar 2018
  2. MORE DATES

Liverpool, UK

  1. 23 Mar 2018
  2. MORE DATES

London, UK

  1. 23 Mar 2018
  2. MORE DATES

Manchester, UK

  1. 23 Mar 2018
  2. MORE DATES

Milton Keynes, UK

  1. 23 Mar 2018
  2. MORE DATES

Newcastle, UK

  1. 23 Mar 2018
  2. MORE DATES

Norwich, UK

  1. 23 Mar 2018
  2. MORE DATES

Nottingham, UK

  1. 23 Mar 2018
  2. MORE DATES

Reading, UK

  1. 23 Mar 2018
  2. MORE DATES

Sheffield, UK

  1. 23 Mar 2018
  2. MORE DATES

Southampton, UK

  1. 23 Mar 2018
  2. MORE DATES

Onsite Training

This course can be run in-company anywhere in the world & we can tailor the content to focus on your requirements.

We regularly provide training in London, Manchester, Bristol and all over the United Kingdom.

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.