Author: afsheen

Adding a Validation Rule

Your task is to add a validation rule to the gender field so only M or F are shown. To do this follow these simple steps:
Open up the contestant database in design view
Scroll down to the gender field and locate validation rule and text

In the validation rule section type: “M” OR “F”
In the validation text section type: Please enter either M or F
Once all added click on the datasheet icon to test this rule

Message 1 will appear asking to save...please save

Message 2 will appear telling you some data may change to these new rules...please select yes. Now you are ready to test your rule.