Microsoft Access Introduction Training Course

Our one day Microsoft Access 2003 Introduction course will equip you with the skills to create your own databases to manage your information more effectively.

Microsoft Access Introduction Training Course Content - Duration 1 days

Next Scheduled Course Date

Module 1 – Overview of Relational Databases
What is a database?
What is a relational database?

Module 2 – Access Objects
Tables, Forms, Queries, Reports, Macros and
Modules

Module 3 – Relating Tables
Overview: Why relate tables?
Types or relationship
One-to-one
One-to-many
Linking fields
The relationship window
Referential Integrity

Module 4 - Queries
Creating select queries
The query grid
Query criteria: Wild cards, comparison and logical operators
Grouping data in queries
Aggregate functions
Calculations in queries
Querying multiple tables
Join properties

Module 5 - Reports
Creating a report using the report wizard
Report bands
Designing reports
Creating and formatting controls
Grouping in reports
Calculating totals
Viewing a report in print preview
Printing reports

Microsoft Certified Partner CA Channel Partner

4 Ravey Street
London EC2A 4QP
t: +44(0)20 7729 1811
f:+44(0)20 7729 9412
enquiries@premiercs.co.uk

Sharepoint Training

Premier's London Training Centre
42 New Broad Street, EC2

How to find us

Premier's most popular courses:

SharePoint 2007 Power User
Microsoft Project Training
Prince2 Practitioner
Excel VBA Training
Sharepoint Designer
Visio Flowcharting