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 Intermediate


To provide delegates with a knowledge of how to manipulate data within a database with particular emphasis on data entry, extraction and the use of reports.  It will also examine the structure of a relational Database to provide efficient functionality and ease of accessing the data via reports and Queries.

It will also review more complex Queries and cover the Formatting of Reports including the incorporation of calculations.

Upon completion of this course, you will be equipped with knowledge enabling you to:
  • Import data into Access
  • Create relationships between tables
  • Use action queries to change database data
  • Create sub forms
  • Create reports which group and subtotal data

Session 1: Importing Data

  • Choosing data source
  • Using the Import wizard
  • Importing from Excel

Session 2: Table Relationships

  • Understanding purpose of table relationships
  • Creating table relationships
  • Applying “Referential Integrity”

Session 3: Working with Forms

  • Editing forms
  • Creating forms with sub-forms
  • Adding calculation fields

Session 4: Advanced Queries

  • Using parameter queries
  • Creating Make-Table queries
  • Creating Append, Delete and Update queries

Session 5: Report Creation

  • Editing reports
  • Sorting & grouping data
  • Adding calculation fields

Session 6: Course review

  • Table relationships
  • Action queries
  • Forms and sub forms

This course is intended for existing users of Access who wish to gain a better understanding of database design.

We recommend that attendees have attended the Introduction course or have a good working knowledge of Access.

  • This course will enhance your knowledge of Access allowing you to understand database construction.
  • You will understand how to write complex Queries and understand use and construction of Database reports
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 Intermediate

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