 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
ECDL Database with MS Access 97
Course Aims
This course is designed to prepare readers for the ECDL module 5 examination. The course will allow readers to create, update and manage basic databases using Microsoft Access 97. The course closely follows ECDL syllabus version 3.0, but can also be used in conjunction with the earlier syllabus, version 1.5. |
Assumed Knowledge
A working knowledge of PCs and Windows is assumed, gained from the workplace or by reading a "Using the Computer and Managing Files" course. |
Course Audience
New, recent or intending users of Microsoft Access 97 who have little or no existing database knowledge. |
|
Table of Contents
|
|
Getting Started with Access97
|
|
|
Introduction to Databases
|
Overview of Manual Databases
|
|
Comparison with Computerised Databases
|
|
What is a Relational Database?
|
|
Primary Keys and Foreign Keys
|
|
|
|
Creating a Database
|
Table Definition Components
|
|
Design and Datasheet Views
|
|
|
|
|
Modifying Table Structures
|
|
|
Relating Tables
|
Relationships and Referential Integrity
|
|
|
|
Data Entry
|
Undoing Changes Made in Error
|
|
Copying, Moving and Deleting Data
|
|
|
Changing the Look of Data
|
Freezing and Unfreezing Columns
|
|
Changing the Font of Data in a Datasheet
|
|
|
|
|
Searching Tables
|
|
|
Designing Data Entry Forms
|
Creating a Form Using Multiple Tables
|
|
|
|
The Form Design Worksurface
|
The Object Property Sheet
|
|
Bound and Unbound Controls
|
|
Adding Controls to a Form
|
|
|
|
|
Select Queries
|
|
|
Reporting in Access
|
Printing Tables, Dynasets and Forms
|
|
Changing the Design of Existing Reports
|
|
|
|
Year 2000 Best Practices
|
Access Database Pivot Years
|
|
|
|
|
|
