side bar: IT Training, computer training in Scotland, Edinburgh iTrain Scotland Logo: Phone us on 07711 341 320. Superior computer training for microsoft word, excel, access, office 97, office 2000, office xp, macromedia dreamweaver, fireworks, web design side bar: IT Training, computer training in Scotland, Edinburgh
home | courses | why us? | venue | trainers
contact | site map
Go Back to courses
   
Access 2000: Intermediate

Overview & Prerequisite

This course is designed for existing users of Access or those who have attended a foundation course. This course is aimed at those people who will be designing the database.

Course content
Query
Action Query
Parameter Query
Crosstab Query
Ad hoc Joins
Setting Counter
Calculated Fields

Introduction to Relational Database
Concepts
Basic Relationships
Referential Integrity
One-to-One
One-to-Many
Cascade Delete
Cascade Update

Advanced Form
Main/Sub
Lookup
Command Buttons
Combo Boxes
Calculated Fields

Reports
Design
Mailing Labels
Group/Sort
Word Mail Merge
Analysis with Excel
Create Chart

| home | why choose us | courses | contact us | site map |
2000-2003 iTrain Scotland - Site Last Updated: 9 December, 2003 2:06 PM - Website problems e-mail: Support