1. Schedule of Assessed Exercises
  2. Introduction To Database Design (Course Aims & Objectives)
  3. Initial Data in the Table "Studrec"
  4. Understanding Database Terminology
  5. Exercise 1: Amending the Structure of a Table, Adding and Deleting data)
  6. Boolean Logic & Queries
  7. Exercise 2: Designing Queries
  8. Reports
  9. Exercise 3: Designing Reports
  10. Forms
  11. Exercise 4: Designing Forms
  12. Macros, More Forms & Tailoring a Database
  13. Exercise 5.1: Creating A Form with Command Buttons
  14. Exercise 5.2: Developing a User Front End
  15. Essential Relational Technique & Theory
  16. Exercise 6: Creating a Simple Relational Database
  17. Extending the Design of a Relational Database
  18. Exercise 7: Creating Class Lists (Registers)
  19. Extending the Scope of the Student Record System: A Brief Look at the Entity Relational Model
  20. Exercise 8: Using Entity Modelling
  21. Data Warehousing
  22. Exercise 9: Specifying a data warehouse
  23. Appendix A: Input Masks and Validation Rules