Level – National 5+
Required Fields
Required fields cannot be be left empty (null).
- Right-click on the Table name
- Select “Modify table”
- Tick the NN (Not Null) option for each required field:
Length, Range and Restricted Choice Checks
- Right-click on the Table name
- Select “Modify table”
- Double-click the “Check” for each field that has a validation check.
- Type in the rule for field.
- Field names that include spaces must be inside quotation marks
- Add the checks one at a time, saving after each one. This will make it easier to any mistakes.
length check:
length(surname) <= 15 length(postcode) between 7 and 8 length("Delegate Ref") = 4 Note: Don't use single apostrophes: length('name') is always 4 characters
range check:
"Presentations Attending" <= 3 presentationsAttending between 1 and 3
restricted choice:
eyesight in ("Natural","Contact Lenses","Glasses") maxClassSize in (20,30)
Example: