| Week | Topic | Practical |
| 1 |
Introduction to Database Design Introduction To U18 Databases Introduction To Databases Database Features Summary Database Glossary |
Create Database & Reports Databae Simple Queries |
| ------------------------------------------------------------------------- | ||
| 2 |
Database Design Design (Relationships) Database Queries |
Database Relationship exercise |
| ------------------------------------------------------------------------- | ||
| 3 |
Data Mod 1- Enitities Data Mod 2- Relationships Data Mod 3- Normalisation |
Data Entry Data Entry Forms |
| ------------------------------------------------------------------------- | ||
| 4 |
Normalisation Review Database Design-Conference Centre |
|
| ------------------------------------------------------------------------- | ||
| 5 |
Referential Integrity Referential Integrity |
|
| ------------------------------------------------------------------------- | ||
| 6 |
Importing/Exporting Data Importing Data |
Use a Query to Create Mailmerge |
| ------------------------------------------------------------------------- | ||
| 7 |
Errors in the Database Errors in Database Design |
|
| ------------------------------------------------------------------------- | ||
| 8 |
Testing the Database Testing A Relational Database |
|
| ------------------------------------------------------------------------- | ||
| 9 |
Recap & Review. Database Exercise |
|
| ------------------------------------------------------------------------- | ||
| 10 | ||
| ================================================ |