Microsoft Access Introduction Training Course

Our Microsoft Access 2003 Introduction course will equip you with the skills to create your own databases to manage your information more effectively. This is a two-day course suitable for new or inexperienced Microsoft Access users who need to build a relational Access database.

INTRODUCTION
Overview of Relational Databases
What is a database?
What is a relational database?

ACCESS OBJECTS
Tables, Forms, Queries, Reports, Macros and Modules

TABLES
Creating a table in design view
Table structure: Field names and sizes
Data types
Field properties
Inserting fields
Look-up Lists
Indexes
Setting a Primary Key

EDITING DATA
Selecting fields and records
Adding and deleting records
Useful shortcut keys
Finding data
Find and replace

RELATING TABLES
Overview: Why relate tables?
Types or relationship
One-to-one
One-to-many
Linking fields
The relationship window
Referential Integrity

FILTERS
Filtering in tables, Filter by selection
Exporting filtered data

QUERIES
Creating select queries
The query grid
Query criteria: Wild cards, comparison and logical operators
Summarising data in queries
Aggregate functions
Calculations in queries
Querying multiple tables
Join properties

FORMS
Using an existing form
The form screen
Record navigation
Adding records
Creating a form using AutoForm
The form wizard
Mainform and subform
Designing a form: labels and control sources
Selecting and moving
Resizing controls
Formatting controls
Using the toolbox

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

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

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

How to find us

Premier's most popular courses:

Excel VBA Training
Microsoft Project Training
Prince2 Practitioner
Excel Advanced Training
Sharepoint Designer
Visio Flowcharting