Beginners Access Training

Overview

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

By learning the basics of Microsoft Access, 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 your time and make creating relational databases easier.

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

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

Onsite Training

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

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.

Related Courses

• Beginners Access Training
• Advanced Access Training
• Advanced Excel Training

Outline Details

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