P7
|
PREDICTION
|
-Correctly fill out form
(Presence check)
|
Form correctly filled out and all information was correct. The form is then accepted into the data base and therefor added to the members table.
|
-Incorrectly filled form
(Age wrong)
|
Form will not be accepted and an error message shall appear with the underage message or the overage
|
-unfilled form
|
Form will not be accepted as there are too many null fields
|
-query
|
The Query will take all reviews and separated into a different report in they were created in certain months
|
- Macro’s
|
The Macro will create an error message when fields are left empty or if any of the critical data is left blank
|
-Age check
|
The DOB calculator will generate the persons age if the information is put correctly into the form
|
-username generator
|
The equalization used will take the first 3 letters of their Forename and the first 3 of the surname and the corresponding number after the last generated username.
|
-list check
|
A check on films that includes the film months and their respective genres
|
-input mask
|
Amount paid will be set to a default of 00.00 for easer use.
|
-format check
|
DOB is placed in short date format
|