Activity 2: Table structures and validation (45 minutes)

Walkthrough

To complete activity 2, you need to apply validation techniques to your fields.

You MUST also evidence all the validation in the document. Your database will not be marked – only the documents get marked.

Validation Point 1 – Presence Check
Validation Point 2 – Format Check
Validation Point 3 – Table Lookup
Validation Point 4 – Table Lookup Or Value Lookup
Validation Point 5 And 6 – Range Check

Don’t forget to EVIDENCE your work. Use the guides below:

Activity 2 Evidencing Tables
Activity 2 Evidencing A Presence Check
Activity 2 Evidencing A Length Check
Activity 2 Evidencing Last 3 Validation Types