CBH Training

Call Now: 01524 424678, Email: This email address is being protected from spambots. You need JavaScript enabled to view it. or open Contact Form

Microsoft Access Advanced


This one-day course is designed for experienced users of Access who wish to develop their knowledge in order exploit the advanced functionality of Access in order to build more complex databases.

It will cover using Switchboards to allow users easy access to reports or data entry; cover using expressions to total reports as well as exploring different join types between relational tables.

The courses is highly interactive to provide practical as well as a theoretical understanding of the advanced functionality of Access.

Upon completion of this course, you will be equipped with knowledge and tools that enable you to:
  • Customise and develop secure databases
  • Use database tools and utilities
  • Automate a database with macros

Session 1: Performance and Database Design

  • Setting up Indexes
  • Creating and editing table relationships
  • Importing and exporting database objects
  • Creating Custom Toolbars

Session 2: Using Different Join types

  • Working with outer join
  • Working with inner join
  • Editing join types

Session 3: Automated Form Design

  • Creating Calculated Fields
  • Using the Expression Builder
  • Understanding Form Events

Session 4: Automating a Database

  • Controlling the Start-up of a database
  • Creating and running macros
  • Setting conditions in macros
  • Attaching macros to events

Session 5: Database Utilities

  • Security methods for a database
  • Convert, compact & repair a database


This course is designed for experienced users of Access who wish to exploit the advanced facilities of this software package to build more sophisticated applications

The course will:

  • Develop your knowledge of Access showing how to design efficient Databases
  • Show how database relationships can be edited
  • Show how to import data effectively into Access Table structures
CBH have been delivering training into businesses for over seven years. All our Trainers come from industry so you are assured of their competence to deliver professional and practical knowledge throughout the course. All training is backed by our 90-day free support line, which can assist you when putting your learning into practice.


Latest Articles

How to take Minutes Effectively WHY SHOULD YOU LEARN TO TAKE MINUTES? Minute Taking is a key skill and is often far more involved than given credit.  Many people start taking minutes with...
Finance for non-financial Managers COURSE AIMS This one day training course will look at the tools and processes you need to build, present and work with your budget, understand a Profit and Loss Statement, Cash Flow...
Business Writing COURSE AIMS Every email, report or letter speaks volumes about you and you organisation. This is why it is important to ensure that every document that leaves your organisation is crisp, professional...

Contact Us

You are here: Home Microsoft Microsoft Access Training Microsoft Access Advanced

CBH Training Logo White

CBH Training

"Work smarter, not harder!"

01524 424678
This email address is being protected from spambots. You need JavaScript enabled to view it.



Training Venues


Wyboston Lakes, Great North Road, Wyboston, Bedfordshire.  MK44 3AL


Greenlands Farm Village, Tewitfield, Carnforth, Lancashire.  LA6 1JH

Clawthorpe Hall Business Centre, Burton-in-Kendal, Carnforth, Lancashire.  LA6 1NU


1 Lyric Square, King Street, Hammersmith, London.  W6 0NB


Morecambe Office

30 Lowlands Road
T: 01524 424678
E: This email address is being protected from spambots. You need JavaScript enabled to view it.
F: 01524 424678

Huntingdon Office

PO Box 617
PE29 9FT
T: 01480 718008

Follow Us

Copyright © 2012 CBH Training
All Rights Reserved
Created by Showing Off Ltd