An Introduction to Microsoft Access
Choice 8 evenings over 4 wks (mon & thu)
2 Weekdays : 		6.00pm - 9.00pm
10.00am - 5.00pm 		£120
Objectives
 To give trainees an understanding of Microsoft Access
Suitable for:
 All those who would like to use Microsoft Access
Pre-Requisite
 PC appreciation and basic keyboard skills would be advantageous
Books on
Microsoft
Access
Course Outline
Introduction to Databases
 What are Databases?
An overview of Manual Databases
What is a Relational Database?
Designing Tables; Primary Keys & Foreign Keys
Main Task of an Access Database
Storage of Data
Viewing, Entering & Editing Data
Printing Reports
The Course Database
Using Microsoft Access
Starting & Leaving Microsoft Access
The Microsoft Access Screen
Access Help, Wizards & Cue Cards
Creating a Database
The Database Windows; Creating Table Objects
Table Definition Components
Field Properties; Setting the Primary Key
Saving a Table
Modifying Table Structures
Importing & Linking Data
Relating Tables
Using Look-up fields
Relationships & Referential Integrity
Data Entry
Using the Datasheet View; Keyboard Commands
Adding a New Record; When Data is Saved
Undoing Changes made in Error
Copy, Moving & Deleting data
Deleting a Record
Changing the "Look" of Data
Searching Tables
The Find Command; Find & Replace
Using Filters - Limitations of Find
Designing Data Entry Forms
Advantages of Forms in Access
Types of Form; The Form Wizard
Using AutoForm; Working in a Form
Create a Single-Column Form using the Form Wizard
Creating a Form Using Multiple Tables
The Form Design Work Surface
The Object Property Sheet;
The Field List; The ToolBar
Working in Forms Designer
Select Queries
What is a Select Query or a Dynaset?
Criteria; Summarising Data
Table Joins in Queries
The Different Join Types
Calculated Fields in Queries
Expression Builder
Action Queries
What are Action Queries?
Update & Make Table Queries
Delete & Append Queries
Reporting in Access
Printing Tables & Forms; AutoReport
Report Wizard; Single Column Reports
tabular & Groups/Totals Reports
Mailing Labels; The Screen Preview
Printing Tables & Dynasets
Using AutoReport & Report Wizards
Changing the Design of Existing Reports
The Report Bands; Mailing Labels
Course will be based on The Courseware Company's superb training Material
To book onto this Course or for further information please contact
BHI Net Centre
701 High Road
Seven Kings, Ilford
Essex IG3 8RH, UK

Phone : +44 (0)20 8590 2500
Fax: +44 (0)20 8590 2589
E-Mail BHIemail: training@bhi-netcentre.co.uk
If this is the only frame you can see Click Here to see our full Training Portfolio