BTEC Nationals Extended Diploma
in Information Technology
Unit 2 - Creating Systems to
Manage Information
Revision Booklet and How to Guides
Name………………………………………………
1
, Contents
Topic Pages
Assessment Checklist and timings 3-4
Part A - 3 hours
Entity Relationship Diagrams - Activity 1 5
Importing data 6
Creating Tables 7-8
Relationships 9-10
Tables Documentation - Activity 2 11
Validation and Input Masks 12-16
Interface documentation - Activity 3 17
Main Menus 18
Queries 19-20
Reports 21
Structure Testing 22
Structure Evaluation 23
Part B - 2 hours
Forms 27-28
Append Queries (putting data into the table) 29-30
Testing 31
Evaluation 32
Mark Schemes 33+
For the digital version, click on the topic to get to the relevant page.
2
, Assessment Checklist and Timings
Part A - 3 hours
Importing Data - 25 minutes
● Have you inported your data into the database?
● Did you use a make table query to add your data into tables?
● Do your tables have correct names using naming conventions? E.g. TblName
● Have you identified the primary keys and relationships between tables?
Entity Relationship Diagram - 20 minutes
● Have you checked your fields (entities) against the data set to make sure you have used them all
but no others?
● Do you have relationships between the tables?
● Do your relationships go from the primary to the foreign key?
● Are your one to many relationships correct?
● Have you created a print screen of the ERD in a word document?
● Is the word document saved as a PDF?
Table structure and Validation - 45 minutes
● Have you got a proper naming convention for all of your tables?
● Do you have at least one presence check, length check, value lookup, table lookup and format
check?
● Have you completed the validation tasks that they have asked?
● Does your validation have an error message in the validation text?
● Have you taken a print screen of your table structures?
● Have you taken a print screen of your validation rules?
● Have you saved the word document as a PDF?
Queries and a Report - 40 minutes
● Have you created the queries that it asks you to create?
● Have you got the correct criteria in the queries?
● Have you taken a print screen of the queries in both design and datasheet view?
● Are your queries named correctly using the naming conventions? e.g. QryName
● Have you created a query for the report?
● Have you created the report to fit onto one page?
● Have you put your print screen into the activity3 template?
● Are they named correctly using the naming conventions? E.g. RptName
● Have you saved activity 3 as a PDF?
Testing - 20 minutes
● Have you completed the 6 tests that they require?
● For each test have you completed a normal erroneous and extreme test?
● Have you filled in the testing table in activity 4?
● Does your actual result include a print screen?
● Have you saved your test log in a PDF format?
Evaluation - 20 minutes
● Have you explained how there is no data duplication?
● Have you explained how it meets the requirements?
3
, ● Have you explained whether your database structure (tables, queries, reports)allows for the
different requirements?
● Have you saved your evaluation activity as a PDF?
Part B - 2 hours
Remember that you cannot change any of the structure of your database in this section.
Forms - 1 hour 10 minutes
Have you created a menu form to navigate around the database and called it FrmMenu?
Have you created the input forms?
● Are your forms named correctly using the correct naming convention e.g. FrmName
● Do the text boxes on your forms have a name? E.g. txtCustomerName
● Have you created an append query to put the data in your tables in the database?
● Have you made the forms a consistent style?
● Have you added a title and explanation of the form?
● Have you marked the mandatory boxes with a *?
● Have you added the interface print screen of your forms into activity6 in both design and form
view?
● Have you added a printscreen of any queries you have used?
● Have you saved the document as a PDF?
Testing - 20 minutes
● For each test have you completed a normal, erroneous and extreme test?
● Have you filled in the testing table up to expected result?
● Does your actual result include a print screen?
● Have you completed the testing log?
● Have you saved the testing log as a PDF?
Evaluation - 20 minutes
● Have you explained how the interface and forms allow you to meet each of the criteria?
● Have you explained how did you did something and whether you would change it?
● Have you saved the evaluation sheet as a PDF?
4
in Information Technology
Unit 2 - Creating Systems to
Manage Information
Revision Booklet and How to Guides
Name………………………………………………
1
, Contents
Topic Pages
Assessment Checklist and timings 3-4
Part A - 3 hours
Entity Relationship Diagrams - Activity 1 5
Importing data 6
Creating Tables 7-8
Relationships 9-10
Tables Documentation - Activity 2 11
Validation and Input Masks 12-16
Interface documentation - Activity 3 17
Main Menus 18
Queries 19-20
Reports 21
Structure Testing 22
Structure Evaluation 23
Part B - 2 hours
Forms 27-28
Append Queries (putting data into the table) 29-30
Testing 31
Evaluation 32
Mark Schemes 33+
For the digital version, click on the topic to get to the relevant page.
2
, Assessment Checklist and Timings
Part A - 3 hours
Importing Data - 25 minutes
● Have you inported your data into the database?
● Did you use a make table query to add your data into tables?
● Do your tables have correct names using naming conventions? E.g. TblName
● Have you identified the primary keys and relationships between tables?
Entity Relationship Diagram - 20 minutes
● Have you checked your fields (entities) against the data set to make sure you have used them all
but no others?
● Do you have relationships between the tables?
● Do your relationships go from the primary to the foreign key?
● Are your one to many relationships correct?
● Have you created a print screen of the ERD in a word document?
● Is the word document saved as a PDF?
Table structure and Validation - 45 minutes
● Have you got a proper naming convention for all of your tables?
● Do you have at least one presence check, length check, value lookup, table lookup and format
check?
● Have you completed the validation tasks that they have asked?
● Does your validation have an error message in the validation text?
● Have you taken a print screen of your table structures?
● Have you taken a print screen of your validation rules?
● Have you saved the word document as a PDF?
Queries and a Report - 40 minutes
● Have you created the queries that it asks you to create?
● Have you got the correct criteria in the queries?
● Have you taken a print screen of the queries in both design and datasheet view?
● Are your queries named correctly using the naming conventions? e.g. QryName
● Have you created a query for the report?
● Have you created the report to fit onto one page?
● Have you put your print screen into the activity3 template?
● Are they named correctly using the naming conventions? E.g. RptName
● Have you saved activity 3 as a PDF?
Testing - 20 minutes
● Have you completed the 6 tests that they require?
● For each test have you completed a normal erroneous and extreme test?
● Have you filled in the testing table in activity 4?
● Does your actual result include a print screen?
● Have you saved your test log in a PDF format?
Evaluation - 20 minutes
● Have you explained how there is no data duplication?
● Have you explained how it meets the requirements?
3
, ● Have you explained whether your database structure (tables, queries, reports)allows for the
different requirements?
● Have you saved your evaluation activity as a PDF?
Part B - 2 hours
Remember that you cannot change any of the structure of your database in this section.
Forms - 1 hour 10 minutes
Have you created a menu form to navigate around the database and called it FrmMenu?
Have you created the input forms?
● Are your forms named correctly using the correct naming convention e.g. FrmName
● Do the text boxes on your forms have a name? E.g. txtCustomerName
● Have you created an append query to put the data in your tables in the database?
● Have you made the forms a consistent style?
● Have you added a title and explanation of the form?
● Have you marked the mandatory boxes with a *?
● Have you added the interface print screen of your forms into activity6 in both design and form
view?
● Have you added a printscreen of any queries you have used?
● Have you saved the document as a PDF?
Testing - 20 minutes
● For each test have you completed a normal, erroneous and extreme test?
● Have you filled in the testing table up to expected result?
● Does your actual result include a print screen?
● Have you completed the testing log?
● Have you saved the testing log as a PDF?
Evaluation - 20 minutes
● Have you explained how the interface and forms allow you to meet each of the criteria?
● Have you explained how did you did something and whether you would change it?
● Have you saved the evaluation sheet as a PDF?
4
