Browse all IT training courses

Microsoft Access Introduction

Click here for a PDF version

Introduction

Microsoft Access is the world's most popular desktop database program and takes full advantage of the Windows environment. 

Objectives

To be able to plan and build an Access database. This involves creating tables and understanding the data types required, designing forms for entering data, sorting and filtering specific information and producing reports. 

Designed for

New users of Access. Participants should have attended our "Introduction to Windows 95/98/NT" course or attained a similar level of proficiency. 

Duration

Two days 

Topics

  • Introduction
  • Database overview
  • Terminology explained
  • Access overview
  • Database Design
  • Database design issues
  • One-to-many relationships
  • Tables
  • Creating a table
  • Table structure – data types
  • Primary keys
  • Validation rules
  • Input masks
  • Indexing
  • Data Entry
  • Data sheet
  • Forms
  • Editing and deleting data
  • Find and replace
  • Sorting records
  • Filtering records
  • Importing data

Follow-up

Microsoft Access Intermediate 1 day course 

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