... Primary Key SubjectReferenceCode Presence Check Required = Yes Input Mask Options from drop-down box (20094, 28181, 64773) by using the following Row Source code in Lookup: Select Subject.SubjectReferenceCode From Subject; ExaminerNumber Presence Check Required = Yes Input Mask 000000 (must have 6 digits) Range Check Between 100000 and 999999 NuberOfCandidatesEntered Presence Check Required = Yes Examiner Table: Validation Rules: Field Validation Check Validation Rule ExaminerNumber (Primary Key) Range Check Between 100000 and 999999 Uniqueness Check It is the Primary Key Input Mask 000000 ( must have 6 digits) Presence Check Required = Yes Forename Presence Check Required = Yes Surname Presence Check Required = Yes Address Presence Check Required = Yes Postcode Input Mask>LL00\ 0LL;O;_ (Must be in this form) Presence Check Required = Yes SubjectReferenceCode Presence Check Required = Yes Input Mask Options from drop-down box (20094, 28181, 64773) by using the following Row Source code in Lookup: Select Subject.SubjectReferenceCode From Subject; Subject Table: Validation Rules: Field Validation Check Validation Rule SubjectReferenceCode (Primary Key) Uniqueness Check It is the Primary Key Presence Check Required = Yes SubjectName Presence Check Required = Yes Payment (to 2.d.p) Presence Check Required = Yes Validation Of Data Entered In Visual Basic: For entering data to the Add Centre Form, I used the following validation: Private Sub CmdAddCen_Click() ...

See this essay or coursework document in full right now