The following files contain the printable (.pdf) version of this course.

 

  1. Course Contents
  2. Schedule of Assessed Exercises
  3. Aims & Objectives
  4. Initial data (Studrec)
  5. Reading List
  6. Understanding Database Terminology
  7. Working with an Access Table
  8. Boolean Logic and queries
  9. Reports
  10. Forms
  11. Macros (optional section)
  12. Introduction to Relational Databases
  13. Normalisation
  14. Entity Relation Modelling
  15. Data Warehousing
  16. Structured Query Language (optional section)
  17. Appendix A (Validation Rules and Input Masks)
  18. Appendix B (Visual Basic Code used to embed SQL statements)