MS Access: Database - Data/Types/Validation/Queries/SQL

Microsoft Access Database Lesson 02 to 04 - Data/Types/Validation/Queries/SQL

This lesson was originally used to teach Year 9 ICT - however, it can be adapted for other years in KS3, KS4 and even KS5 if necessary.

I have included, starter activities (within the lesson resource), a teacher lesson presentation with student activity booklet. The student activity can be edited e.g. location of files as you wish however, the content does correlate with the lesson presentation itself. The database that is require for the students is also included - this can be edited.

The lessons are as follow :
Lesson 02:

• Quick mini review of attributes
• Reviews what a flat file and DBMS
• Task to insert data
• Table Structure and Primary Key
• Changing Data Types
• Validating Input Data
• Types of Validation

Lesson 03:

• Review of what an entity is
• Review: relationships and primary key
• Primary Key and Foreign Key
• Entity Relationship Diagram (ERD)
• Operators
• Queries
• SQL (Structure Query Language)
• Logical Operators

Lesson 04

• Review database queries
• Review: comparison operators
• Queries with SQL
• Logical Operators
• Multiple SQL Queries