We're excited to announce that from 14th April we'll be running live online training courses too!
From 14th April we'll be running live online training courses too!
Microsoft Office training -  Access Developers

Access Training

Microsoft Access Developers Training Course

£795 + VAT for most venues (£895 + VAT for London)

3 days

The first (and most important) part of any Access database is getting the design right, which is where this 3-day course begins. You'll learn about primary keys and relationships, and find out how to create an Access database consisting of multiple linked tables.

The course then goes on to show how to create queries (to display data from one or more tables) and a front-end to your system, using forms, reports and the VBA coding language.

If you've been given the job of creating an Access database - and you're not sure where to start - this is the course for you!

We don't have any dates scheduled for this course, but we may well consider adding them - it's always worth asking - or you could consider an onsite Access training course.

Course Contents

The content of this course are as follows:

Designing a database

  • Training topicIdentifying the tables
  • Training topicWhat are relationships?
  • Training topicSetting a primary key
  • Training topicUsing multivalue fields

Creating tables

  • Training topicDefining fields
  • Training topicThe types of field
  • Training topicEntering data

Different field types

  • Training topicCreating attachments
  • Training topicRich text format fields
  • Training topicDate fields (using calendars)
  • Training topicCalculated fields

Importing data

  • Training topicImporting from Excel
  • Training topicMaking tables from Excel

Covered if time allows If time

Table rules

  • Training topicRecord-level validation
  • Training topicBasic triggers

Drawing relationships

  • Training topicCreating relationships
  • Training topicReferential integrity

Creating queries

  • Training topicThe query design grid
  • Training topicSorting
  • Training topicSetting criteria
  • Training topicCombining criteria

Advanced queries

  • Training topicGrouping and totalling
  • Training topicCreating expressions
  • Training topicParameter queries


  • Training topicCreating ad hoc joins
  • Training topicTypes of join

Covered if time allows If time

Crosstab queries

  • Training topicColumns, rows and values
  • Training topicOverriding column headings

Covered if time allows If time

Action queries

  • Training topicMaking tables
  • Training topicUpdating records
  • Training topicAppending records
  • Training topicDeleting records

Creating forms

  • Training topicLayout and design view
  • Training topicUsing the form wizard
  • Training topicSplit forms
  • Training topicCreating controls

Covered if time allows If time

Advanced controls

  • Training topicMultitabs
  • Training topicWebbrowser controls
  • Training topicNavigation bars

Creating reports

  • Training topicUsing the report wizard
  • Training topicThe group, sort and total pane
  • Training topicReport design

Creating subforms

  • Training topicMultiple item forms
  • Training topicCreating subforms
  • Training topicTidying up subforms

Basic VBA coding

  • Training topicCreating modules
  • Training topicUsing Project Explorer
  • Training topicWriting comments
  • Training topicIndenting code

Uses of VBA

  • Training topicForm validation
  • Training topicCriteria forms
  • Training topicA simple menu system

You do not need to have used Access before to attend this course, although you should be a confident computer user.

Why Choose Us?

View full list of benefits View full list of benefits

Sample customer feedback

"Honestly, I can't think of anything that could have been done to make ths course better. Much cheaper than others but delivers just as good content."

Jamie Everitt (Anglian Community Enterprise (NHS PCSE))

There are lots more where these came from (or just refresh this page to change the quotes shown).

Related Courses

Access Querying


1 day course



2 day course

Advanced VBA

Guru level

2 day course

Other Microsoft Access training resources

Access exercises

Access exercises

To give you a chance to see whether this 3-day Access course is for you, we've published all of our Microsoft Access exercises online.

View Access VBA or Access 2010 exercises

Access skills assessment

Access skills assessment

You may find it useful to do one of our Access skills assessment tests, to help you know what you don't know (to misquote Donald Rumsfeld …).

View Test your Access skills skills assessment tests

Access blogs

Access blogs

In addtion to other Access training resources, you may find some of our Access blogs useful.

View Access or VBA macros blogs

This page has 0 threads Add post