OCR Nationals ICT

1
OCR Nationals ICT

• Unit 1 Task 5
• Booklet
• Grade A

2
Booklet Introduction

• This booklet contains everything you will need to
  complete this task, divided up into 3 sections.
• OUTLINE SECTIONS explaining the task to be
  completed divided into individual parts.
• SUPPORT SECTIONS providing all you will need to
  help you to complete the tasks individual parts.
• EVIDENCE SECTIONS that shows you what proof you
  need to provide and the space to display it.
• Each section is colour coded
• RED/AMBER/GREEN
• In the format shown above.

3
Task 5 Overview

• The owner of Downloadable Tunes has created an
  electronic database to record customer details.
  The database will be used to efficiently store
  and maintain customer details and to target
• advertising to specific customer groups.
•  
• You have been provided with an electronic version
  of the database below. You will need to use it to
  complete this task.
• Link to database

4
Task 5 Part A

• You must first open the database and take a
  screen print of the unchanged database and put in
  the relevant Evidence Section then carry out the
  following tasks
•  
• A new order has been received, enter the
  following customer details into the database
•  
•  
• A Smith has asked to be removed from the
  database. Delete this record.
• T Park has recently married and is now T Forrest.
  Amend this record, to reflect this change.
• Create one query showing all of the customers
  that live in Leeds.

Task 5 Part A

• This Link is a guide to completing Part A.

5
Task 5 Part A
The unchanged Database
Screen-print showing the unchanged Database
6
Task 5 Part A
Explanation of how you added the new record
Screen-print showing new record
7
Task 5 Part A
Explanation of how you deleted the record
Screen-print showing the record deleted
8
Task 5 Part A
Explanation of how you changed the record
Screen-print showing the changed record
9
Task 5 Part A
Explanation of how you created the query
Screen-print showing the design of the query
10
Task 5 Part A
Explanation of how you viewed the query result
Screen-print showing the results of the query
11
Task 5 Part B

• Now you have edited the database and created the
  simple query, you do the following
• Create another query but this time showing all of
  the people that live in Durham
• Make the query show only the people that are aged
  16-25
• Sort the results of the query on the Age Field
  (either ascending or descending)

Task 5 Part B
This Link is a guide to completing Part B.
12
Task 5 Part B
Explanation of what you did
Screen-print showing the design of the query
13
Task 5 Part B
Explanation of what you did
Screen-print showing the results of the query
14
Task 5 Part C

• You must now create a report for the Durham Query
  you created in Part B.

Task 5 Part C
This Link is a guide to completing Part C.
15
Task 5 Part C
Explanation of how you created the report
Screen-print showing the design of the Report
16
Task 5 Part C
Screen-print showing the completed Report
17
Task 5 Part D

• You must now create a report in the format of
  Address Labels based on the Leeds Report you
  created in Part A

Task 5 Part D
This Link is a guide printing Part D.
18
Task 5 Part D
Explanation of what you did
Screen-print showing the design of the Labels
19
Task 5 Part D
Explanation of what you did
Screen-print showing the final Labels