Training advisors available Mon–Fri, 9am to 5pm train@keystraining.com Public course dates
Speak to an advisor0345 450 0051 Build a quote
Microsoft 365 & Copilot · Beginner

Access Introduction

Microsoft Access Introduction Training

Closed tailored courses are available at your site for £645.00 plus vat (up to 8 attendees).

Length1 day
LevelBeginner
FormatsIn-house · Live online · Public
Group sizeUp to 8 per group
Get a quote for your team See 18 public dates
Level 1IntroductionLevel 2Intermediate
Overview

About the Access Introduction course

Scheduled public courses are held at Preston, Liverpool, Manchester & London.

*Book 2 or more delegates and receive significant discounts. Click here for information

This one-day instructor led course is designed to give an introduction to the different aspects of Access including basic design principles and effective use of an existing database. By the end of the course delegates will be able to enter and edit data, extract data, and to design a new Access database table.

  • Understand database terminology
  • Enter, edit and format data
  • Create a new database table
  • Design a new query to extract specified data
  • Create and edit a database form for data entry and manipulation
Course outline

What the day covers

5 modules · tailored to your team on in-house courses
Access Basics7 topics
  • Exploring the Access window
  • Understanding database terminology
  • Viewing an existing database
  • Understanding Access objects: Tables / Queries / Forms / Reports
  • Looking at relationships within a database
  • Understanding the function of the Primary Key
  • Keyboard Shortcuts and Menu Items
Database Tables9 topics
  • Understanding the difference between
  • fields and records
  • Entering and editing data
  • Moving and copying data
  • Sorting and filtering data
  • Finding and replacing data
  • Looking at data types
  • Designing a new table
  • Printing data from a table
Query use and design3 topics
  • Understanding the role of the query
  • Modifying a query
  • Creating a new query
Form Creation3 topics
  • Creating a new form
  • Editing data within a form
  • Modifying the design of a form
Report Design2 topics
  • Creating a new report
  • Modifying the design of a report
Outcomes

By the end of the course, delegates will be able to

  • Understand database terminology
  • Enter, edit and format data
  • Create a new database table
  • Design a new query to extract specified data
  • Create and edit a database form for data entry and manipulation
  • Create and edit simple reports to print out data
Courses & fees

Ways to book this course

In-house

Tailored Group Course

£645+ VAT
One day · up to 8 people · At your premises or live online
  • Tailored to your team
  • Trainer travel included
  • Reference materials & certificates
Request a quote
Public course

Classroom Place

£195+ VAT
One day · per delegate
  • Ideal for one or two people
  • Reference materials & certificate
  • Discounts for 2+ delegates
View dates
Is it right for you?

Who the course is for

Before you attend

We recommend that all those who attend are able to:

  • Use the mouse to select and open menus and icons
  • Identify and use the Shift, Ctrl, TAB and Home keys on the keyboard
Public course dates

Join a scheduled course

One-day courses, 9:30am to 4:30pm, with refreshments, lunch, reference materials and a certificate. Book 2 or more places for a discount.

DateVenuePriceBook
Tuesday 3 November9:30am to 4:30pm London £225 + VAT per delegate Request a place
Tuesday 3 November9:30am to 4:30pm Manchester £225 + VAT per delegate Request a place
Tuesday 10 November9:30am to 4:30pm Preston £225 + VAT per delegate Request a place
Tuesday 10 November9:30am to 4:30pm Remote (Teams) £225 + VAT per delegate Request a place
Tuesday 17 November9:30am to 4:30pm Liverpool £225 + VAT per delegate Request a place
Tuesday 24 November9:30am to 4:30pm Leeds £225 + VAT per delegate Request a place
Thursday 7 January9:30am to 4:30pm Liverpool £225 + VAT per delegate Request a place
Wednesday 13 January9:30am to 4:30pm Leeds £225 + VAT per delegate Request a place
Wednesday 20 January9:30am to 4:30pm London £225 + VAT per delegate Request a place
Thursday 21 January9:30am to 4:30pm Manchester £225 + VAT per delegate Request a place

All 18 dates for this course

Every course includes

More than just a training day

Dedicated account managerOne named contact who knows your organisation and your history with us.
Pre-course evaluationFree skills check forms so every delegate lands on the right level.
Course tailoringWe plan and customise closed courses around your roles, systems and files.
CertificatesA Keys Training certificate for every attendee, for training records and ESR.
Management feedbackPost-course feedback reviews so you can see what landed.
Free aftercareTelephone and email support for every delegate after the course.
Keep going

Courses that pair well with this one

All microsoft 365 courses

Get your team trained properly.

Tell us the course, rough numbers and where you are. A training advisor will reply within one working day with options and a fixed fee.

Build your quote or call a training advisor0345 450 0051
From£645 + VAT per group of up to 8Get a quote
View quote