Beginners Microsoft Access Training

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 you 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.

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

Microsoft Access Course Objectives:

By the end of the Beginners Microsoft Access training course, delegates will be able to create a simple relational databases using Access

Microsoft Access Training Course Prerequisites:

• Delegates attending this access course should have reasonable general PC skills.
• No prior knowledge of Access is required.

Read More About Access on our Blog:

• New Features in Access 2010
• Microsoft Office Shortcuts

Microsoft Access 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

Microsoft Access Training Course Recommended Reading

Microsoft Office Access 2007 Step by Step Book/CD Package (Step by Step (Microsoft)