For training call +44 1273 622272

Your basket is empty View Cart shopping cart

Beginners Access Training

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.


What are the objectives of the Beginners Access training course?

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

Who’s the Beginners Access Course intended for?

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

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

 
 

Total price (excluding any discounts and offers)