Access 2007: Validation

The ticks indicate the suitability of resources for each Key Stage.

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.

 

tick
tick
tick

download filedownload file

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.

 

tick
tick
tick

download filedownload file

Task

download file

Answers

click here

validation 2.mdb

 

 

 

 

 

 

 

Copyright © www.teach-ict.com