Part of task 5

Task 6

Task 5

P4

P2+P3

The validation checks that are present within the print screen above are the Range Check, the Input Mask, the Required field and the 'Allow Zero Length' Field. The range check is what stops people out of the age boundries from putting their information within the database. By entering the date you want the lowest age to be and the highest age you want to enter (which would have to be updated annually) - this is the range. It is shown as 'Between #01/01/1945# and #01/01/1996#. The input mask makes it so that the only characters that can be typed in are numbers for date format otherwise letters and punctuation would also be allowed and there would be no set format of setting the date of birth. The Required field is what would be the middle man between allowing the user to continue on without filling in the form and needing to be filled in before they can continue. The Allow Zero length field stops users from leaving a field blank so that they must enter information. There have also been format checks for the fields shown above. All the fields allow for text because they are all applicable for numbers and letters. DOB is not numbers because usually when you use numbers, you are going to calculate something so text also applies.

M2