Exam Task Validation Meanings
1. Presence checks – validation rules ‘Is Not Null’ with a
suitable validation text message
2. Length checks – changing all the text field lengths from
255 to a more reasonable size e.g. Gender of M/F would
only need a field size of 1
3. Value lookups – lookups you have created where you
have typed in the values e.g. M/F; 1,2,3… etc.
4. Table lookups – lookups you have created for the table
relationships for the foreign keys – DO NOT FORGET TO
‘LIMIT TO LIST’
5. Range checks – Lookups which have a range e.g. 1,2,3….
Etc.
6. Format checks (if appropriate) – this may not always
be required but if you have an email address as a field you
must include the format *?@?*.?*
1. Presence checks – validation rules ‘Is Not Null’ with a
suitable validation text message
2. Length checks – changing all the text field lengths from
255 to a more reasonable size e.g. Gender of M/F would
only need a field size of 1
3. Value lookups – lookups you have created where you
have typed in the values e.g. M/F; 1,2,3… etc.
4. Table lookups – lookups you have created for the table
relationships for the foreign keys – DO NOT FORGET TO
‘LIMIT TO LIST’
5. Range checks – Lookups which have a range e.g. 1,2,3….
Etc.
6. Format checks (if appropriate) – this may not always
be required but if you have an email address as a field you
must include the format *?@?*.?*
