Summary What Evidence is Required for the Database Exam

What do you have to do for Activity 1?

Answer: Copy and paste a screenshot of your database relationships from Access into a Word document and save as a pdf. (Make sure that ALL the fields in all the tables are clearly visible. Any cropped field names or tables with scroll bars will mean losing marks.)

What do you have to do for Activity 2?

Answer: Add screenshots of each of your tables in design view showing the table names, field names and data types only. You will need screenshots of all your tables here: 1) Do not crop the table name tab. 2) Do not crop the primary key. 3) Make sure you are using consistent names for ALL your fields in ALL your tables e.g. CamelCase or spaces. 4) Make sure you use the correct naming convention for your tables i.e. tbl. 5) Make sure you have used the correct data types for all your fields e.g. data/time, currency, short text, number, yes/no. 6) Make sure the screenshot is large enough for the examiner to see.

What do you have to do for Activity 3?

Answer: Add a design view screenshot of both queries: 1) Make sure the tables used in the queries show the relationships between them. 2) Give expressions meaningful names not Expr1. 3) Make sure all the information in the columns are visible. 4) You may have to split the screenshot up so that everything is clear.

What do you have to do for Presence Check?

Answer: Add a screenshot of one presence check: 1) Check the Activity 2 requirements to find out what fields need to be completed e.g. a record will not save without the surname and telephone number of the volunteer information being present. 2) Use one of these as your evidence. 3) Validation rule should be Is Not Null. 4) Validation text must have a user friendly message. 5) Make sure that the table name and the field the validation relates to is shown in the screenshot.

What do you have to do for Length Check?

Answer: Add a screenshot of one length check: 1) You can use the same screenshot as you did for the Presence Check. 2) Make sure that the Field Size is appropriate i.e. NOT 255.

What do you have to do for Value Lookup or Range Check?

Answer: Add a screenshot of one value OR one range check you have applied: 1) You may have a value lookup, a range check or both – you only need to screenshot one. 2) Value lookups are a dropdown list of different options e.g. male, female. 3) Range checks use validation rules to set the range e.g. Is Not Null and Between 1 and 5. 4) Limit to List is not essential for the Value Lookup.

What do you have to do for Table Lookup?

Answer: Add a screenshot of ONE table lookup you have applied (foreign key only): 1) Check the Activity 2 requirements to find out which foreign key relationship is needed e.g. a record will not save if a beach is assigned to an invalid district. 2) Make sure the table name tab is clear. 3) Make sure you do not truncate the select statement. 4) Make sure Limit to List is set to \"YES\".

What do you have to do for Format Check?

Answer: Add a screenshot of ONE format check you have applied: 1) Check the Activity 2 requirements to find out where the correct format is needed e.g. a record will not save if the volunteer mobile number is not in the correct format. 2) Use the input mask to create the correct format for telephone numbers and post codes. 3) For emails you will need the validation rule Like *?@?*.?*. 4) DO NOT USE DATE FORMAT AS YOUR EVIDENCE.