Implementation [25 marks]

Click here to see this checklist in Microsoft Word.

3 marks    for showing annotated printouts of all three tables (if you use more than three tables, show them
                   all here)

1 mark      for showing annotated evidence of an entity relationship diagram, explaining all links

2 marks    for showing evidence of two data validation techniques (which must match those shown in the Design
                   section)

                   You must show the construction of each technique used

                   They must be your own design, ie not using wizards

                   They must not be drop down lists

1 mark      for showing a screenshot of a user friendly interface

2 marks    for creating two macros, eg navigation controls from user interface and forms

                   Note: only one navigation macro is permitted - the second macro must have a 
                    different purpose

                  Screenshot evidence is required of the construction of each macro

2 marks    for showing evidence of two forms

                   They must look clear and easy to read, with no cut-off field names or data

1 mark       for the creation of a form with a subform

Screenshot evidence of the construction of each of the following types of queries:

2 marks    two single table queries

1 mark      multiple table query using relational links

1 mark      multiple table using relational links with search criteria

1 mark      parameter query

1 mark      Append or Delete or Update query

Screenshot evidence of the construction of a report, including:

1 mark      report fields must show all relevant data

1 mark      a calculation

1 mark      sorted grouping

1 mark      report header and footer

2 marks    evidence such as a screenshot or printout of the code for at least two 
                   implemented routine

1 mark       for showing evidence of the construction of a calculated field in a query or form