Lady Lumley's School - Year 10 Database Introduction
You MUST attempt all parts 1 to 6.
Number 7 is an extension for a 3 table database which students aiming for B, A or A* grades will need.
2 Relational database design Overview
3 Practical Exercise - Relational Database Design
4 Example 1 - JFD Art
| 1 Introduction | 2 Setting up tables | 3 Inputting Data |
| 4 Creating Relationships | 5 Queries - single fields | 6 Sorts |
| 7 Queries - Multiple Fields | 8 Queries - calculations | 9 Forms (Optional) |
| 10 Reports | 11 Graphs |
5 Progress Check
Exercise - sentence matching task to check that you have learned the key points from Task 5 JFD Art
6 Extension - HITEK Computer Services
| Introduction | Setting up tables | Inputting Data |
| Creating Relationships | Queries, Sorts & Calculations | Reports |
| Graphs |