Microsoft Office training -  Access Developers

Access Training

Access Developers (3 days)

£725 + VAT for most venues (£875 + VAT for London)

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 consider an onsite Access training course).

Course Contents

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

Why Choose Us?

View full list of benefits View full list of benefits

Sample customer feedback

"Fantastic course and very well delivered. Much learnt and enjoyed - thank you. I will be back for other courses in the near future."

Craig Johnson (Greater Manchester Comprehensive Local Research Network)

"A very informative course with lots of information presented during the course without me ever feeling rushed. I learnt a huge amount!!"

Ryan Thatcher (Store Twenty One)

"Very good. Well set out and well delivered. I picked everything up very quickly."

Jordan Smith (RAS Ltd)

"Well structured and executed, with an extensive course manual and exercises. The trainer was more than happy to help on a 1-1 basis."

Jamie Everitt (Anglian Community Enterprise)

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

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

Related Courses

Access Querying


1 day course



2 day course

Advanced VBA

Guru level

2 day course

Other Microsoft Access database 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 Access or Access VBA 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