Workbook - CLAiT 2006 - Level 1 (Item Codes WB3 & EWB3)
Unit 3: Database Manipulation
(Using Access 2003)
Key features
-
Supplied on CD-ROM for unlimited self-printing
-
Available in PDF format (£19.95) and editable Word format (£39.90)
-
All data files supplied
List of Contents
Section |
Covers |
Download sample |
|---|---|---|
1 |
Introduction |
|
2 |
What is a database? |
|
3 |
Opening, viewing and closing a database |
|
4 |
Printing and renaming a database table |
|
5 |
Adding records to a database table |
|
6 |
Amending data in a database table |
|
7 |
Deleting records in a database table |
|
8 |
Replacing data in a database table |
|
9 |
Sorting data using a query |
|
10 |
Selecting data using 1 matching criterion |
|
11 |
Selecting data using 1 comparative criterion |
|
12 |
Selecting data using multiple criteria |
|
13 |
Printing selected fields only |
|
14 |
Creating and printing reports |
|
15 |
Changing report headers, page numbers and dates |
This workbook has been carefully designed to cover all the skills required for the OCR New Clait Level 1 (Clait 2006) qualification (Unit 3).
It is designed for learners to work through at their own pace, and at the end of every section there are practice tasks to re-inforce learning. (Also available separately, product code PT3)
Although not designed as such, the workbook can also be used as the basis for lesson plans for tutor-led training.
The workbook is supplied on CD-ROM in PDF format for easy, unlimited printing, or in Word format (XP/2000/2003/2007 compatible) for centres who wish to customise it to suit.
You are allowed to print and photocopy the workbook as much as you like for use at the same OCR training centre, and you can place the workbook on an Intranet if required.
-->