For training call 07702 166301

Your basket is empty View Cart shopping cart

Great trainer, patient & open to all questions. I never felt out of my depth.

Samantha Davis - IHS Global Limited

MAKE AN ENQUIRY Download Course Outline

Most businesses have a lot of data, from customer details and employee records to product specifications data and invoicing and scheduling systems.

Beginners Microsoft Access Training

By learning the basics of Microsoft Access from Microsoft Office, you can get to grips with how to store that data effectively in ways that make it easy to update, query and report on it for a range of outputs.

This is an intensive Access training course, introducing delegates to the concepts of creating relational databases using MS Access.

Microsoft Access is a very powerful database application designed to save you time and make creating relational databases easier.

This Beginners Access Training Course will give attendees the skills needed to go on our advanced Microsoft access training course.

We also provide in-company Microsoft Access courses. Call +44 (0)1273 622272 to discuss your requirements.


Course Objectives

By the end of the Beginners Microsoft Access training course, delegates will be able to:

  • Create a simple relational databases using Access
  • Design & use Access queries, forms and reports
  • Understand how relational databases work and how queries, forms and reports improve productivity

Course Feedback

Clear and graduated learning with easy steps by progression

Dot Bowen - In the Pipeline Ltd

Great course - this morning I didn't know where to start - now I have the confidence to get going.

Laurn Nagle - C Brewers & Sons

I felt that the course was very well structured & delivered. A very open, relaxed environment.

Kim McInally - Grovelands

Excellent course giving me the fundamental knowledge of the database needed for my role.

Michael Vymetal - IHS Global Limited

Beginners Access Training Course Content

Introduction to Microsoft Access

  • What is a relational Database
  • What are Access Objects
  • Database design concepts
  • Relationships between tables

Working with an Access Table

  • What are fields and records
  • How to navigate through records
  • How to enter, edit and delete records
  • How to format tables
  • Filtering data in tables

Designing Access Tables

  • Using design view
  • Adding and naming fields
  • Assigning Field types
  • Assigning Field Properties
  • Creating Key Fields
  • Creating relationships

Designing Access Queries

  • Using And and Or statements
  • Parameter Queries
  • Autolookup Queries

Designing Access forms

  • What are forms
  • Designing a Form using the Wizard
  • Formatting forms
  • Working with Combo Boxes

Access Report Design

  • Creating a report using the Wizard
  • Formatting Reports

Booking

* Required

For in-company or private training please request a quote

 
 

Course Details

  1. Course Title

    Beginners Access Training

  2. Duration

    1 Day

  3. Price Starting From

    £795.00 + VAT

Upcoming Dates

Aberdeen, UK

  1. 09 Jan 2018
  2. MORE DATES

Belfast, UK

  1. 09 Jan 2018
  2. MORE DATES

Birmingham, UK

  1. 09 Jan 2018
  2. MORE DATES

Bournemouth, UK

  1. 09 Jan 2018
  2. MORE DATES

Brighton, UK

  1. 09 Jan 2018
  2. MORE DATES

Bristol, UK

  1. 09 Jan 2018
  2. MORE DATES

Cambridge, UK

  1. 09 Jan 2018
  2. MORE DATES

Cardiff, UK

  1. 09 Jan 2018
  2. MORE DATES

Dublin, UK

  1. 09 Jan 2018
  2. MORE DATES

Edinburgh, UK

  1. 09 Jan 2018
  2. MORE DATES

Glasgow, UK

  1. 09 Jan 2018
  2. MORE DATES

Leeds, UK

  1. 09 Jan 2018
  2. MORE DATES

Liverpool, UK

  1. 09 Jan 2018
  2. MORE DATES

London, UK

  1. 09 Jan 2018
  2. MORE DATES

Manchester, UK

  1. 09 Jan 2018
  2. MORE DATES

Milton Keynes, UK

  1. 09 Jan 2018
  2. MORE DATES

Newcastle, UK

  1. 09 Jan 2018
  2. MORE DATES

Norwich, UK

  1. 09 Jan 2018
  2. MORE DATES

Nottingham, UK

  1. 09 Jan 2018
  2. MORE DATES

Reading, UK

  1. 09 Jan 2018
  2. MORE DATES

Sheffield, UK

  1. 09 Jan 2018
  2. MORE DATES

Southampton, UK

  1. 09 Jan 2018
  2. MORE DATES

Onsite Training

This course can be run in-company anywhere in the world & we can tailor the content to focus on your requirements.

We regularly provide training in London, Manchester, Bristol and all over the United Kingdom.

Who is this course for?

This course is for anybody who needs to use Access databases on a daily basis but has no previous experience.