 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
ECDL Database with MS Access 2000
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 2000. 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 prior attendance on a "Using the Computer and Managing Files" course. |
Course Audience
New, recent or intending users of Microsoft Access 2000 who have little or no existing database knowledge. |
|
Table of Contents
|
What is a Database?
|
Designing an Access Database
|
|
|
|
Getting Started with Access 2000
|
Access 2000 Opening Screen
|
|
Getting Assistance with Access 2000
|
|
|
|
Adding and Editing Records
|
Saving Changes to Records
|
|
Moving Around the Datasheet
|
|
Changing the Width of Columns
|
|
Modifying and Deleting Records
|
|
|
|
Designing and Creating Tables
|
Table Design Hints and Tips
|
|
Format and Input Mask Properties
|
|
Allow Zero Length Property
|
|
Modifying Tables and Fields
|
|
|
Sorting and Filtering Data Forms
|
Using AutoForm to Create a Form
|
|
Using the Form Wizard to Design a Form
|
|
Entering Data Using a Form
|
|
|
|
|
Queries
|
|
|
Reports
|
Printing from Datasheet View
|
|
Designing a Report Using Report Wizards
|
|
Creating Reports from Tables or Queries?
|
|
|
|
Customizing Forms and Reports
|
Form/Report Design Worksurface
|
|
Sections and Controls in Reports
|
|
|
|
|
|
