Beginners MS Access training - 1 day - £195 + vat – dates
Beginners Microsoft Access training uk
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
Access Training Recommended Reading
Microsoft Access 2000 Step by Step- Catapult - buy
from amazon
Access 2002 Bible
-Cary Prague - buy
from amazon
Microsoft Access - Microsoft Access 2002 - buy
from amazon
home book this course resources 01273 622272 info@siliconbeachtraining.co.uk
Microsoft Office and Sage Accounts are skills needed in most modern businesses, we offer a full range of beginners courses, and for more advanced delegates we provide VBA for Access and VBA for Excel training courses.