Past Papers | GCSE Papers | AS Papers

05
Feb

Past Exam Papers

I have created three tables, as outlined in the requirements:

· Examiner (to store the examiner’s details)

· Centre (to store all centre details)

· Subject (to store details about the subjects).

For each of these, certain validation as required in order to minimize the possibility of input error.

For the examiner table, I have inserted 5 fields. These are shown in the screenshot to the right. I have assigned each of these fields a specific data type so only values corresponding to the data type set can be entered. This is aimed to reduce the number of errors on input. For example, one could type the examiner’s name in the “Examiner Number” field. However, if the data type is set only to number, then only numbers can be entered. These are all the fields that will be attributed to the examiner table.

I have also added various validation checks to these fields. This is trying to ensure that the data is complete and reasonable.

In the screenshot to the left, the field properties for the field “Subject Reference Code” are shown. One of the validations for this field is that it must be 5 digits and unique. In order to accomplish this, I wrote the expression (Like “?????”) which will ensure that the value entered contains 5 characters. Together with the data type “Number”, this also means that only numbers can be entered. In conclusion, the field must contain 5 unique digits as indicated in the specification.

For the “Examiner Number” field, I have used a similar validation, but this time I entered 6 “?” signifying that it must be 6 digits. The Examiner Number also had to be unique for each examiner. To accomplish this, I changed the indexing property of the field, so it doesn’t accept any duplicate values.

Leave a Reply

  •  
  • Welcome
    Welcome to the largest database of past papers for ocr past papers, edexcel and aqa past papers for gcse and A levels.

    If you have an A level or GCSE past papers you cannot find on our site, then please submit it to us!
  • Contact & Submit Past Papers
    If you have benefited from the past papers on this site and currently have other papers that are not featured, please submit these by attaching them to an email to: info@pastpapers.org so other people can benefit from them as well!

© 2017 Past Papers | GCSE Papers | AS Papers

Past Papers | Terms & Conditions | Privacy Policy

Powered By Wordpress