Validation rules and text

13. Validation can be used to try to stop mistakes being made when entering data.

For example, a costume can be either for a man or a woman. In the gender field the only values we want people to enter are Male or Female.

Write a validation rule and text which will only allow 'male' or 'female' to be entered.

The validation text is the message that will be displayed if someone tries to enter a value other than male or female.

14. Set up a validation rule and text that will only allow costumes which are size 8 or larger to be entered.

If you only put >8 this would mean that only costumes above size 8 could be entered e.g. 9, 10, 11, 12. Because we want to also include size 8, it is necessary to write >=8 - Greater or Equal to 8

15. No costumes can be sold for more than £100. You need to write a validation rule and text for this.

16. No costumes were purchased before the 1/1/02. Set up a validation rule and text to ensure that no dates prior to this can be entered.

17. Save the table again.