Home » Training Courses » Microsoft Office and Desktop Applications Training » Beginners Microsoft Access Training

Beginners Microsoft Access Training

 SUMMER OFFER: 1 day - £215: £161 + vat

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. Beginners access training will give attendees the skills needed to go on our advanced microsoft access training course.

Beginners Microsoft Access Training 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 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 Forms

What are Access forms

• Designing a Form using the Wizard
• Formatting forms
• Adding controls
• Working with combo boxes

Access Report Design

• Creating a report using the Wizard
• Formatting Reports

Microsoft Access Course Prerequisites:

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

Book this Microsoft Access training course one to one for £450 + vat

Microsoft Access Training Course Recommended Reading

Microsoft Access 2007 Step By Step by Microsoft Press - buy from amazon
 

Download course outline as pdf.