Rules, forms and projects
Answers are for parents and teachers.
1
A club database has an age field with the rule 10 to 14. Which of 9, 10, 14, 15 are accepted?
10 and 14 are accepted. 9 and 15 are rejected.
2
Which check would you use on (a) a name field that must never be empty; (b) a 4-character locker number; (c) a mark from 0 to 10?
(a) presence check; (b) length check; (c) range check.
3
Name three checks you can make when you judge a data collection form.
For example: the instructions make sense; related questions sit together; the form shows how to write a date. (Also: the boxes are big enough; every choice is listed.)
4
A form for a swap shop asks “What item?” with a one-word space. Describe two improvements.
Add an instruction, such as “write the name of the item”, and give enough space or tick options such as book, game or toy plus other.
5
Plan a small database for a class book loan. Give four fields and one validation rule for each of two of them.
Answers vary. For example fields: loan ID (automatic), book title, borrower first name, date lent. Rules: title presence check; date format DD/MM/YYYY.