UNIT 18 P7

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

AGE CHECK

                                                               FORMAT CHECK

                                                                                INPUT MASK

                                                                          LIST CHECK

                                                                       MACRO

                                                                 

PRESENCE CHECK

                                                                       QUERY

                                                               UNFILLED FORM

                                                              USERNAME GENERATION