Choose the correct answer for each question.
In a database of hospital patients, you need a field to record the ward.
Which validation routine would you create to make sure that they could only be admitted to wards: Trent, Avon, Severn and Wye?
In a database of model parts, all the codes start with the letters prt plus 4 numbers. Which validation routine would allow this?
What validation rule would be needed to only allow such part codes?
In a database of boats, you need a field to record the price of the boat.
The lowest price you will sell a boat for is £500 and the highest price is £5000. Which validation routine would allow this?
Which two possible validation rules would you create to make sure that the price entered was between these limits?
A part name must be 5 characters long in total, containing letters or numbers, but it must end with: -RR. Which validation routine would allow this?
What validation rule would be used?
The length of a boat does not have to be entered, but it must be greater than or equal to 3 meters. Which validation routine would allow this?
In a database of houses, you need a field to record the number of doors.
Which validation rule would you create to make sure that at least 2 doors were entered?
In a library database you do not want to allow the librarian to enter 'lost' as the location of a book.
Which two possible validation rules would allow any other entry except the word "lost"?
Which two possible validation rules would not allow you to enter "Sold" into a text field OR leave the field blank?