Browse all IT training courses

Microsoft Access Advanced

Click here for a PDF version

Introduction

Microsoft Access is one of the world’s leading desktop database programs which takes full advantage of the Windows environment. 

Objectives

To build on existing knowledge of Access XP, giving users further understanding to a level of competence sufficient to produce sophisticated database applications for others to use. 

Designed for

Database developers who want to improve the reliability databases and the user interface for use by teams of people. 

Duration

One day 

Topics

  • Review of Basic Skills
  • Database design objectives
  • Creating a relation model
  • Creating tables
  • Forms
  • Creating a linked form
  • Calculated fields in forms
  • Expression builder
  • List boxes and combo boxes
  • Option fields & groups
  • Buttons
  • Check boxes
  • Querying the Database
  • Using different table join-types
  • Action queries
  • Find duplicate
  • Find unmatched
  • Reports
  • Multiple table reports
  • Controlling Grouped reports
  • Calculated fields
  • Summary fields
  • Macros
  • Using command button wizard
  • Using a macro to open a form

Follow-up

Individual consultancy and tuition as required 

Get in Touch

Pricing Guide:

  • 1

    £495 per head

  • 4

    £130 per head

  • 8

    £70 per head

Ask us about training for roll-outs and bespoke systems.

…and every course includes

  • Custom-building the course for you
  • Free post-course support helpline
  • All course materials
  • Trainer expenses