ii) Design Specification [24 marks]
You will have to produce designs for:
- inputs
- user interface
- queries
- outputs
- processes
It is your responsibility to make sure that you complete all of the work below.
Click here to see this checklist in Microsoft Word.
- inputs
- user interface
- queries
- outputs
- processes
It is your responsibility to make sure that you complete all of the work below.
Click here to see this checklist in Microsoft Word.
Data Dictionary [4 marks]
1 mark for producing a table showing fieldname and data type for at least three tables
1 mark for the design of the format of the data in each table
1 mark for the design of the format of the data in each table
Normalisation [2 marks]
Diagram or tables showing normalised tables
1 mark for normalised form of tables
1 mark identifying primary key and foreign keys
1 mark for normalised form of tables
1 mark identifying primary key and foreign keys
Design of validation techniques [1 mark]
1 mark for a validation technique (eg length, range, input mask)
1 mark for a different validation technique
Validations should include clear and useful error messages with no spelling or grammatical mistakes
1 mark for a different validation technique
Validations should include clear and useful error messages with no spelling or grammatical mistakes
Design of security/password protection techniques [1 mark]
1 mark for the techniques used - a flowchart or pseudo code or list
Design of user interface [1 mark]
Design of user-friendly, menu driven, front end interface (hand drawn or DTP design)
Note: this is pre-implementation so no screenshots of forms can be counted as design
Note: this is pre-implementation so no screenshots of forms can be counted as design
Design of on screen data entry forms [3 marks]
These designs should be hand drawn or DTP design
1 mark design of at least two forms
1 mark design of a form with a subform
1 mark this mark is for quality and detail:
- The names of all fields and sample data should be shown
- Any special features on the form
- How it matches house style
Note: this is pre-implementation so no screenshots of forms can be counted as design
1 mark design of at least two forms
1 mark design of a form with a subform
1 mark this mark is for quality and detail:
- The names of all fields and sample data should be shown
- Any special features on the form
- How it matches house style
Note: this is pre-implementation so no screenshots of forms can be counted as design
Design of queries [6 marks]
- There must be six separate queries for six distinctive reasons
- You cannot double up by saying a single query using a parameter counts as two marks
2 marks for two single table queries - each must have realistic reasons for each query, not just describing what the
query does and not just to display certain fields
The field name logical operator and search criteria must be clearly shown in the design
1 mark for a multiple table query using relational links
Important: if you use these to create the calculated field, you must then produce a separate calculation
in the report or form
1 mark for a multiple table query using relational links with search criteria
A realistic reason for the search must be stated in the design
The fieldnames, logical operator and criteria must be clearly shown in the design
1 mark for a parameter query
You must design the statements they will ask as well as give the reason for the search and
the criteria needed for it
1 mark for an Append or Delete or Update query
You must identify what the client wants to search and why they want the data
- You cannot double up by saying a single query using a parameter counts as two marks
2 marks for two single table queries - each must have realistic reasons for each query, not just describing what the
query does and not just to display certain fields
The field name logical operator and search criteria must be clearly shown in the design
1 mark for a multiple table query using relational links
Important: if you use these to create the calculated field, you must then produce a separate calculation
in the report or form
1 mark for a multiple table query using relational links with search criteria
A realistic reason for the search must be stated in the design
The fieldnames, logical operator and criteria must be clearly shown in the design
1 mark for a parameter query
You must design the statements they will ask as well as give the reason for the search and
the criteria needed for it
1 mark for an Append or Delete or Update query
You must identify what the client wants to search and why they want the data
Design of outputs [2 marks]
1 mark Design of report
There must be a realistic reason why the organisation wants these reports. In addition, you must:
- clearly display fields and contain reasonable detail
- detail the data and the tables or queries needed
- allow for suitable original headers and footers
- have sorted and grouped data
1 mark Design of a calculation, totals or statistical field
There must be a realistic reason why the organisation wants these reports. In addition, you must:
- clearly display fields and contain reasonable detail
- detail the data and the tables or queries needed
- allow for suitable original headers and footers
- have sorted and grouped data
1 mark Design of a calculation, totals or statistical field
Design of processes [3 marks]
2 marks for the creation of at least two simple Visual Basic code procedures
Code, pseudo code or flowcharts are acceptable methods of design
Examples could be:
- code for own validation procedures
- toggle buttons to hide data
- username and password routine code
- own calculations routines written in Visual Basic and different from others in this section
These procedures must not be macros
They must not be too simple, eg using =Now() in a text box
1 mark Design at least one calculation in a query or a form
Code, pseudo code or flowcharts are acceptable methods of design
Examples could be:
- code for own validation procedures
- toggle buttons to hide data
- username and password routine code
- own calculations routines written in Visual Basic and different from others in this section
These procedures must not be macros
They must not be too simple, eg using =Now() in a text box
1 mark Design at least one calculation in a query or a form