Task 5: Use a business database
Assessment Objective 6 is assessed in this task.
The owner of Phones Your Way has created an electronic database to record customer details. You can download the database below (remember to save it into an appropriate folder and with an appropriate name):
customerdatabase.mdb
The database will be used to efficiently store and maintain customer details and to target advertising to specific customer groups.
The data shown below is contained within the database below.
Custdetails |
Initial |
Surname |
Address1 |
Address2 |
Address3 |
Postcode |
Age |
A |
Clarkson |
67 Canal Street |
Newton Hall |
Durham |
DH1 2BB |
23 |
C |
Beaumont |
42 Cathedral View |
Belmont |
Durham |
DH1 2FR |
44 |
T |
Manson |
43 Hylton Road |
Belmont |
Durham |
DH1 2PT |
43 |
K |
Harris |
Dene View |
|
Durham |
DH1 3PZ |
25 |
A |
Tindale |
3 Elvet Bridge |
Newton Hall |
Durham |
DH1 3PZ |
35 |
T |
Jones |
14 Market Place |
Newton Hall |
Durham |
DH1 4NQ |
37 |
J |
Bloggs |
1 Finchale Avenue |
|
Durham |
DH1 5NT |
15 |
B |
Hall |
4 Richmond Close |
|
Durham |
DH2 1QQ |
17 |
P |
Jolly |
13 Howling Lane |
Chester le Street |
Durham |
DH2 3PB |
45 |
H |
Marley |
21 Garforth Road |
|
Durham |
DH5 8QN |
17 |
M |
Bond |
1 The Croft |
|
Durham |
DH5 9NN |
17 |
C |
Smithwon |
4 Mill Lane |
|
Durham |
DH9 5QT |
16 |
A |
Chisholm |
121a Richmond Court |
|
Leeds |
LS1 2QQ |
23 |
A |
Smith |
45 The Parks |
|
Leeds |
LS1 3BQ |
15 |
K |
Bates |
21 York Road |
|
Leeds |
LS1 8NB |
39 |
K |
Edmonson |
44 The Links |
|
Leeds |
LS2 4BN |
20 |
B |
Singh |
66 The Bronx |
Garforth |
Leeds |
LS2 4BN |
16 |
T |
Park |
43 Haydon Bridge Road |
Garforth |
Leeds |
LS41 8RQ |
30 |
J |
Booth |
99 Mill Way |
Belmont |
York |
YO3 2QT |
26 |
C |
Hogg |
31 Haystings Close |
|
York |
YO4 2TT |
14 |
A Open the database and carry out the tasks below. Produce annotated screen shots to show how you have done each:
• A new order has been received, enter the following customer details into the database
Initial |
Surname |
Address1 |
Address2 |
Address3 |
Postcode |
Age |
M |
Khan |
31 Haystings Close |
|
York |
YO4 2TT |
14 |
• 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.
 (Evidence could be annotated printouts from your database and/or annotated screenshots)
To achieve the higher grades you will also need to:
B create a new query showing all the customers that live in Durham and who are within theage rangeof 16 to 25. Sort this query on the Age field (ascending or descending order)
C create a report using the query for the customers living in Durham and who are aged between 16 and 25
D create a new report using the query for customers living in Leeds. This report must be in the form of address labels
  (Evidence could be annotated printouts from your database and/or annotated screenshots)
|
