select courses

we have a wide range of courses proven to be effective

We have a wide range of diverse courses proven to be effective

create your own

Partnering with you to develop your solutions

public sector

We have a wide range of courses to suit you. Explore our full range here


Free Download

Please complete this form to instantly receive your FREE PDF by email

Microsoft Access - Introduction

1 Day


Designed for anyone wishing to use Access for the first time or those who have never received formal training

Participants should have attended the Introductory sessions for Microsoft Word and Excel before completing this course

Time efficient manipulation and creation of data to support simple business decisions

Programme Objectives

Participants will be able to build a simple database, including Tables, Forms Querying and Reports.  Delegates will also be able to interrogate a simple database and be able to produce labels.

Programme Content

  • Introduction to Database Concepts and Terminology
  • Starting Access
  • Access Databases
  • Creating  New Databases
  • Creating an Object
  • Creating a Table
  • Changing Tables
  • Entering Data in Datasheet View
  • Copy, Move, Delete
  • Changing the Datasheet’s Layout
  • Designing Forms
  • Types of Form
  • Changing Forms using the Forms Design Work Surface
  • Editing the Tab order
  • Calculations within Forms
  • Creating Forms from Scratch
  • Multiple Screen Forms
  • Filter/Sort Records
  • Queries & Dynasets
  • Sorting Data
  • Calculations in Queries
  • Grouping and Summarising Data
  • Producing Cross Tabulated Results
  • Customising Queries with Parameters
  • Using Filters
  • Queries to Link Data from Different Tables
  • Queries with Calculated Fields
  • Queries to Summarise Data
  • Queries with Parameters
  • Action Queries
  • Action (Update) Query
  • Action (Make table) Query
  • Action (Delete) Queries
  • Action (Append) Query
  • Printed reports
  • Using the Report Wizard
  • Report Design Mode
  • Calculated and Statistical Fields
  • Including Graphs in Reports
  • Organizing Reports
  • Label Generation