Resource

KS3

KS4

KS5

Click Here

Validation Task 1

This task assumes that students are familiar with Access and are able to set up a single table database.

They should also have some basic understanding of validation.

A good task to use for consolidating skills.

Task

Validation Task 2

This task assumes basic familiarity with Access.

Students are given a pre-prepared database and asked to set up different types of validation on the fields.

A set of answers is supplied.

Task

Answers

validation 2.mdb