Browse all IT training courses

Microsoft Access Basics & Data Entry

Click here for a PDF version

Introduction

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

Objectives

A basic introduction the main Access features and working with existing databases. The knowledge gained will enable students to become immediately effective on their return to the office. 

Designed for

New users of Access who will use Access databases regularly but not create new ones. Participants should have attended our "Introduction to Windows” course or attained a similar level of proficiency. 

Duration

One day 

Topics

  • Introduction and Terminology
  • Database overview
  • What is a table?
  • Relationships between tables
  • Table Wizard
  • Creating new tables
  • Relating Tables
  • Data Entry
  • Adding new data
  • Editing and deleting data
  • Finding a record
  • Sorting records
  • Filtering records
  • Form Wizard
  • Creating forms
  • Viewing data
  • Using command buttons
  • Query Wizard
  • Creating select and summary queries
  • Running action queries
  • Running parameter queries
  • Report Wizard
  • Grouped reports
  • Summary reports
  • Mail-merge and labels

Follow-up

Microsoft Access Intermediate – 1 day 

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