Design and Develop a Database on Microsoft Access
Course Title: Computer science
Level: Undergraduate (bachelor’s degree)
Module Title: Principles of Databases
Assignment Title:
Task 1: Design and Develop a Database on Microsoft Access
Task 2: Commentary and Evaluation
Number of words: 1200 words
Maximum allowed number of words: 1200 + 10% (120) =1320 words. References and the bibliography do not count toward the maximum word limit.
Referencing style: Harvard
Two important issue:
- All contents must follow British style (spelling, units of measurement, dates, times, currencies, contact details such as addresses, phone numbers, social media, email addresses, etc.).
- Please do not reuse anything from previous projects, as when we submit our task on Blackboard, Turnitin performs a similarity check against all projects ever submitted by students worldwide, as well as all internet resources.
I highlight these points because I have encountered problems with them before and would appreciate your special attention.
Assessment Brief
SCENARIO – ‘WorksOfArt’ Arts & Crafts Store
WorksOfArt is a retail organisation, based in Yorkshire, specialising in the retail of art and crafts supplies. They currently have three stores: Leeds, Sheffield and York. They currently carry products for over 250 activities e.g. Art materials, craft kits and components, paper craft, jewellery components etc.
The current system tracks all sales and purchases to track the stock levels of the supplies sold at the stores.
Alongside the retail element of the stores, the organisation offers taster sessions to introduce customers to the various arts and crafts, and provide short courses to develop the various hobbies/skills. The courses run at various times, venues, duration and have different difficulty levels. A course may run multiple times throughout the year. Staff employed by WorksOfArt, trained in the relevant art or craft, lead the sessions. A member of staff employed by the organisation may be trained in more than one art or craft to enable greater flexibility within the organisation to deliver the courses. For an individual course to go ahead, there will be between 5 and 16 participants. A course will be cancelled if less than five participants have signed up for the course. The participants signed up to a course that is cancelled will need to be contacted to inform them of this.
Taster sessions are free of charge. Participants on longer courses are charged a fee to cover materials used. WorksOfArt would like a system that will track the data relating to these courses and taster sessions and allow interrogation of the relevant information as required by their business needs.
Example documents used by the organisation can be found below:
|
Store: Course: |
York Pottery |
Venue: Level : |
York Art Hub Staff: O Evans Advanced |
|
Date: |
01/02/2020 |
Time : |
11 :00 |
|
Fee: |
£50:00 |
Duration: |
7 hrs |
|
|
Participant Name |
Address |
Age |
Paid |
Contact Name |
Telephone |
|
Attended |
|
1 |
Mr Gavin Sharp |
27 Ash Court, York |
27 |
Yes |
Mr Gavin Sharp |
07777 673780 |
No |
|
|
2 |
Mrs Lola Sharp |
27 Ash Court, York |
24 |
No |
Mr Gavin Sharp |
07777 673780 |
|
No |
|
3 |
Mrs Amelia Edwards |
150 Hawkswood Mill, York |
30 |
Yes |
Mrs Amelia Edwards |
07466 343355 |
Yes |
|
|
4 |
Miss Rose Cooper |
592 Murton Way, York |
19 |
Yes |
Miss Rose Cooper |
07466 343221 |
|
Yes |
|
5 |
Mr Austin Watson |
258 Keith Avenue, York |
18 |
Yes |
Mr Austin Watson |
07466 346880 |
|
|
|
6 |
Mrs Heidi Parker |
194 Garth Road,Leeds |
29 |
Yes |
Mrs Heidi Parker |
07414 255389 |
Yes |
|
|
7 |
Mr Toby Parker |
194 Garth Road, Leeds |
36 |
No |
Mrs Heidi Parker |
07414 255389 |
|
Yes |
|
8 |
Mr Blake Bennett |
595 Avon Circus, York |
47 |
Yes |
Mr Blake Bennett |
07815 799765 |
No |
|
|
9 |
Mr Brandon Cook |
428 Garden Vale, Leeds |
60 |
Yes |
Mr Brandon Cook |
07341 817935 |
Yes |
|
|
10 |
Mr Graham Richrdson |
693 Usher Lane, Bradford |
18 |
No |
Mr Graham Richardson |
07724 634514 |
Yes |
|
|
11 |
Mrs Julia Marshall |
57 Acacia Grove, Leeds |
47 |
Yes |
Mrs Julia Marshall |
07520 658905 |
No |
|
|
12 |
Miss Bella Marshall |
57 Acacia Grove, Leeds |
23 |
Yes |
Mrs Julia Marshall |
07520 658905 |
No |
|
|
13 |
|
|
|
|
|
|
|
|
|
14 |
|
|
|
|
|
|
|
|
|
15 |
|
|
|
|
|
|
|
|
|
16 |
|
|
|
|
|
|
|
|
Cancelled – No
|
Store: Course: |
York Pottery |
Venue: Level : |
York Art Hub Staff: O Evans Advanced |
|
Date: |
04/08/2020 |
Time : |
09:00 |
|
Fee: |
£50:00 |
Duration: |
7 hrs |
|
|
Participant Name |
Address |
Age |
Paid |
Contact Name |
Telephone |
|
Attended |
|
1 |
Mr Gavin Sharp |
27 Ash Court, York |
27 |
Yes |
Mr Gavin Sharp |
07777 673780 |
Yes |
|
|
2 |
Mrs Hazel Turner |
475 Derwent Mews, Huddersfield |
49 |
Yes |
Mrs Hazel Turner |
07466 343800 |
|
Yes |
|
3 |
|
|
|
|
|
|
|
|
|
4 |
|
|
|
|
|
|
|
|
|
5 |
|
|
|
|
|
|
|
|
|
6 |
|
|
|
|
|
|
|
|
|
7 |
|
|
|
|
|
|
|
|
|
8 |
|
|
|
|
|
|
|
|
|
9 |
|
|
|
|
|
|
|
|
|
10 |
|
|
|
|
|
|
|
|
|
11 |
|
|
|
|
|
|
|
|
|
12 |
|
|
|
|
|
|
|
|
|
13 |
|
|
|
|
|
|
|
|
|
14 |
|
|
|
|
|
|
|
|
|
15 |
|
|
|
|
|
|
|
|
|
16 |
|
|
|
|
|
|
|
|
Cancelled – Yes
|
Store: Course: |
Sheffield Oil Painting |
Venue: Level : |
Sheffield Staff: M Webb Advanced |
|
Date: |
07/03/2019 |
Time : |
09 :00 |
|
Fee: |
£70:00 |
Duration: |
8 hrs |
|
|
Participant Name |
Address |
Age |
Paid |
Contact Name |
Telephone |
|
Attended |
|
1 |
Miss Catherine Ashton |
83 Maple Street, Sheffield |
30 |
No |
Miss Catherine Ashton |
07714 746316 |
|
No |
|
2 |
Mr William Kendal |
45 Cedar Close, Rotherham |
53 |
Yes |
Mr William Kendal |
07769 237527 |
|
No |
|
3 |
Mr Gordon Campbell |
48 Canvas Close, Sheffield |
25 |
Yes |
Mr Gordon Campbell |
07552 433743 |
Yes |
|
|
4 |
Miss Grace Hughes |
68 Outwood Place, Rotherham |
45 |
No |
Miss Grace Hughes |
07397 903384 |
Yes |
|
|
5 |
Mr George Hall |
373 Riverside View, Sheffield |
54 |
Yes |
Mr George Hall |
07466 343784 |
|
Yes |
|
6 |
Mrs Emma Jackson |
45 Peel Croft, Rotherham |
57 |
Yes |
Mrs Emma Jackson |
07466 342049 |
Yes |
|
|
7 |
Mr Jasper Jackson |
45 Peel Croft, Rotherham |
59 |
Yes |
Mrs Emma Jackson |
07466 342049 |
|
No |
|
8 |
Mr Aaron Ward |
179 Brecks Lane, Huddersfield |
37 |
Yes |
Mr Aaron Ward |
07466 343738 |
|
Yes |
|
9 |
Mrs Orla Ward |
179 Brecks Lane, Huddersfield |
32 |
Yes |
Mr Aaron Ward |
07466 343738 |
Yes |
|
|
10 |
Mrs Eleanor Scott |
582 Haxby Road, Rotherham |
35 |
Yes |
Mrs Eleanor Scott |
07446 218577 |
Yes |
|
|
11 |
Mr Peter Scott |
582 Haxby Road, Rotherham |
39 |
Yes |
Mrs Eleanor Scott |
07446 218577 |
Yes |
|
|
12 |
Miss Imogen Price |
238 Broome Close, Bradford |
30 |
Yes |
Miss Imogen Price |
07301 329064 |
Yes |
|
|
13 |
Mrs Nicole Owen |
672 Earswick Chase, Rotherham |
42 |
Yes |
Mrs Nicole Owen |
07891 271769 |
Yes |
|
|
14 |
|
|
|
|
|
|
|
|
|
15 |
|
|
|
|
|
|
|
|
|
16 |
|
|
|
|
|
|
|
|
Cancelled – No
|
Store: Course: |
York Paper Craft – Taster |
Venue: Level : |
York Creative Studio Staff: B Powell Beginner |
|
Date: |
26/07/2021 |
Time : |
14 :00 |
|
Fee: |
£0:00 |
Duration: |
2 hrs |
|
|
Participant Name |
Address |
Age |
Paid |
Contact Name |
Telephone |
|
Attended |
|
1 |
Mr John Paul |
50 Birch Road, York |
38 |
Yes |
Mr John Paul |
07517 776394 |
|
|
|
2 |
Miss Victoria Kelly |
95 Mosaic Lane, York |
42 |
Yes |
Miss Victoria Kelly |
07747 785082 |
|
|
|
3 |
Mrs Anne Moore |
5 Beadwork Avenue, York |
34 |
Yes |
Mrs Anne Moore |
07876 741035 |
|
|
|
4 |
Mr Jackson Moore |
5 Beadwork Avenue, York |
40 |
Yes |
Mrs Anne Moore |
07876 741035 |
|
|
|
5 |
Mrs Olivia Swift |
23 Pastel Row, York |
46 |
Yes |
Mrs Olivia Swift |
07988 698155 |
|
|
|
6 |
Mr Jordan Edwards |
150 Hawkswood Mill, York |
32 |
Yes |
Mrs Amelia Edwards |
07466 343355 |
|
|
|
7 |
Miss Jane Green |
124 Manor Gate, York |
29 |
Yes |
Miss Jane Green |
07466 343105 |
|
|
|
8 |
Mr Nicholas Turner |
475 Derwent Mews, Huddersfield |
52 |
Yes |
Mrs Hazel Turner |
07466 343800 |
|
|
|
9 |
Mrs Emily Clark |
435 Doriam Drive, York |
30 |
Yes |
Mrs Emily Clark |
07580 750878 |
|
|
|
10 |
Mr Austin Watson |
258 Keith Avenue, York |
18 |
Yes |
Mr Austin Watson |
07466 346880 |
|
|
|
11 |
Mr Graham Richardson |
693 Usher Lane, Bradford |
18 |
Yes |
Mr Graham Richrdson |
07724 634514 |
|
|
|
12 |
Miss Rachel Murphy |
728 Forest Close, Leeds |
29 |
Yes |
Miss Rachel Murphy |
07482 164390 |
|
|
|
13 |
|
|
|
|
|
|
|
|
|
14 |
|
|
|
|
|
|
|
|
|
15 |
|
|
|
|
|
|
|
|
|
16 |
|
|
|
|
|
|
|
|
Cancelled – No
|
Store: Course: |
York Silk Painting |
Venue: Level : |
York Creative Studio Staff: M Webb Intermediate |
|
Date: |
15/09/2021 |
Time : |
13 :00 |
|
Fee: |
£30:00 |
Duration: |
6 hrs |
|
|
Participant Name |
Address |
Age |
Paid |
Contact Name |
Telephone |
|
Attended |
|
1 |
Mr John Paul |
50 Birch Road, York |
38 |
Yes |
Mr John Paul |
07517 776394 |
|
|
|
2 |
Miss Victoria Kelly |
95 Mosaic Lane, York |
42 |
Yes |
Miss Victoria Kelly |
07747 785082 |
|
|
|
3 |
Mrs Anne Moore |
5 Beadwork Avenue, York |
34 |
Yes |
Mrs Anne Moore |
07876 741035 |
|
|
|
4 |
Mr Jackson Moore |
5 Beadwork Avenue, York |
40 |
Yes |
Mrs Anne Moore |
07876 741035 |
|
|
|
5 |
Mr Hugo Swift |
23 Pastel Row, York |
49 |
Yes |
Mrs Olivia Swift |
07988 698155 |
|
|
|
6 |
Mr Jordan Edwards |
150 Hawkswood Mill, York |
32 |
No |
Mrs Amelia Edwards |
07466 343355 |
|
|
|
7 |
Miss Violet Turner |
475 Derwent Mews, Huddersfield |
17 |
Yes |
Mrs Hazel Turner |
07466 343800 |
|
|
|
8 |
Mr Samuel Clark |
435 Doriam Drive, York |
32 |
Yes |
Mrs Emily Clark |
07580 750878 |
|
|
|
9 |
Mr Austin Watson |
258 Keith Avenue, York |
18 |
Yes |
Mr Austin Watson |
07466 346880 |
|
|
|
10 |
Mrs Nancy Young |
95 Tent Vale, Leeds |
23 |
Yes |
Mrs Nancy Young |
07520 658893 |
|
|
|
11 |
Miss Rachel Murphy |
728 Forest Close, Leeds |
29 |
Yes |
Miss Rachel Murphy |
07482 164390 |
|
|
|
12 |
Mrs Julia Marshall |
57 Acacia Grove, Leeds |
47 |
Yes |
Mrs Julia Marshall |
07520 658905 |
|
|
|
13 |
|
|
|
|
|
|
|
|
|
14 |
|
|
|
|
|
|
|
|
|
15 |
|
|
|
|
|
|
|
|
|
16 |
|
|
|
|
|
|
|
|
Cancelled – No
|
Store: Course: |
Leeds Textile Design |
Venue: Level : |
Leeds Workshop 1 Staff: M Webb Advanced |
|
Date: |
23/11/2021 |
Time : |
09 :00 |
|
Fee: |
£80:00 |
Duration: |
8 hrs |
|
|
Participant Name |
Address |
Age |
Paid |
Contact Name |
Telephone |
|
Attended |
|
1 |
Miss Naomi Morgan |
72 Chestnut Street, Leeds |
40 |
Yes |
Miss Naomi Morgan |
0113 5119589 |
Yes |
|
|
2 |
Miss Sonia Carson |
36 Oak Avenue, Huddersfield |
19 |
Yes |
Mr Gary Carson |
07341 820638 |
|
Yes |
|
3 |
Mrs Hillary Carson |
36 Oak Avenue, Huddersfield |
50 |
No |
Mr Gary Carson |
07341 820638 |
|
Yes |
|
4 |
Mr Andrew Timpson |
63 Willow Way, Leeds |
49 |
Yes |
Mr Andrew Timpson |
0113 5112745 |
Yes |
|
|
5 |
Miss Suzana Wilson |
34 Willow Crescent, Leeds |
34 |
Yes |
Miss Suzana Wilson |
0113 5340241 |
Yes |
|
|
6 |
Mrs Katie Fisher |
9 Artisan Way, Bradford |
52 |
Yes |
Mrs Katie Fisher |
07542 916726 |
Yes |
|
|
7 |
Mrs Alice Brown |
49 Loom Terrace, Bradford |
24 |
Yes |
Mrs Alice Brown |
07880 199490 |
Yes |
|
|
8 |
Miss Charlotte Johnson |
93 Claypot Square, Leeds |
60 |
Yes |
Miss Charlotte Johnson |
0113 3589829 |
|
No |
|
9 |
Mr Henry Roberts |
53 Glen Road, Huddersfield |
67 |
Yes |
Mr Henry Roberts |
07860 041419 |
|
Yes |
|
10 |
Miss Beatrice Walker |
15 Abbey Road, Leeds |
27 |
Yes |
Miss Beatrice Walker |
0113 4800145 |
Yes |
|
|
11 |
Mrs Sophia White |
31 Kingston Drive, Leeds |
56 |
No |
Mrs Sophia White |
0113 0183695 |
|
No |
|
12 |
Miss Lucy Lewis |
257 Burley Lane, Leeds |
34 |
Yes |
Miss Lucy Lewis |
0113 1169750 |
|
Yes |
|
13 |
Mr Edward Jenkins |
523 Parkwood Street, Bradford |
29 |
Yes |
Mr Edward Jenkins |
07868719940 |
Yes |
|
|
14 |
Miss Harriet Wood |
9 University Road, Leeds |
23 |
Yes |
Miss Harriet Wood |
07466 343757 |
Yes |
|
|
15 |
Mr Thomas Hill |
19 Willow Glade, Leeds |
42 |
Yes |
Mr Thomas Hill |
07166 442336 |
Yes |
|
|
16 |
Miss Caroline Stevens |
395 New Lane, Bradford |
23 |
Yes |
Miss Caroline Stevens |
07466 346168 |
|
Yes |
Cancelled - No
|
Store: Course: |
Sheffield Drawing - Taster |
Venue: Level : |
Sheffield Staff: B Powell Beginner |
|
Date: |
25/09/2019 |
Time : |
15 :00 |
|
Fee: |
£0:00 |
Duration: |
3 hrs |
|
|
Participant Name |
Address |
Age |
Paid |
Contact Name |
Telephone |
|
Attended |
|
1 |
Miss Catherine Ashton |
83 Maple Street, Sheffield |
30 |
Yes |
Miss Catherine Ashton |
07714 746316 |
|
Yes |
|
2 |
Mr William Kendal |
45 Cedar Close, Rotherham |
53 |
Yes |
Mr William Kendal |
07769 237527 |
|
No |
|
3 |
Mr Tom Miller |
40 Pine Lane, Sheffield |
47 |
Yes |
Mr Tom Miller |
07463 804966 |
|
Yes |
|
4 |
Mr Gordon Campbell |
48 Canvas Close, Sheffield |
25 |
Yes |
Mr Gordon Campbell |
07552 433743 |
Yes |
|
|
5 |
Miss Grace Hughes |
68 Outwood Place, Rotherham |
45 |
Yes |
Miss Grace Hughes |
07397 903384 |
No |
|
|
6 |
Miss Ivy Jackson |
45 Peel Croft, Rotherham |
30 |
Yes |
Mrs Emma Jackson |
07466 342049 |
Yes |
|
|
7 |
Mr Jude Jackson |
45 Peel Croft, Rotherham |
19 |
Yes |
Mrs Emma Jackson |
07466 342049 |
Yes |
|
|
8 |
Mrs Abigail Morris |
269 Woodland Way, Sheffield |
49 |
Yes |
Mrs Abigail Morris |
07466 345662 |
|
No |
|
9 |
Mr Mike Morris |
269 Woodland Way, Sheffield |
24 |
Yes |
Mrs Abigail Morris |
07466 345662 |
Yes |
|
|
10 |
Mr Adam Phillips |
187 Lea Fold, Sheffield |
22 |
Yes |
Mr Adam Phillips |
07723 563950 |
Yes |
|
|
11 |
Mrs Jasmine Phillips |
187 Lea Fold, Sheffield |
43 |
Yes |
Mr Adam Phillips |
07723 563950 |
Yes |
|
|
12 |
Mr Simon Owen |
672 Earswick Chase, Rotherham |
49 |
Yes |
Mrs Nicole Owen |
07891 271769 |
Yes |
|
|
13 |
|
|
|
|
|
|
|
|
|
14 |
|
|
|
|
|
|
|
|
|
15 |
|
|
|
|
|
|
|
|
|
16 |
|
|
|
|
|
|
|
|
Cancelled – No
|
Store: Course: |
Leeds Wood Carving |
Venue: Level : |
Leeds Workshop 2 Staff: O Evans Intermediate |
|
Date: |
09/05/2019 |
Time : |
13 :00 |
|
Fee: |
£40:00 |
Duration: |
5 hrs |
|
|
Participant Name |
Address |
Age |
Paid |
Contact Name |
Telephone |
|
Attended |
|
1 |
Miss Naomi Morgan |
72 Chestnut Street, Leeds |
40 |
No |
Miss Naomi Morgan |
0113 5119589 |
No |
|
|
2 |
Mr Gary Carson |
36 Oak Avenue, Huddersfield |
55 |
No |
Mr Gary Carson |
07341 820638 |
Yes |
|
|
3 |
Miss Sonia Carson |
36 Oak Avenue, Huddersfield |
19 |
Yes |
Mr Gary Carson |
07341 820638 |
|
No |
|
4 |
Mr David Carson |
36 Oak Avenue, Huddersfield |
21 |
Yes |
Mr Gary Carson |
07341 820638 |
No |
|
|
5 |
Mrs Maria Davies |
56 Cherry Grove, Leeds |
49 |
Yes |
Mrs Maria Davies |
0113 3507518 |
Yes |
|
|
6 |
Mr Jason Davies |
56 Cherry Grove, Leeds |
59 |
Yes |
Mrs Maria Davies |
0113 3507518 |
|
Yes |
|
7 |
Mr Isaac Fisher |
9 Artisan Way, Bradford |
18 |
Yes |
Mrs Katie Fisher |
07542 916726 |
|
Yes |
|
8 |
Mr Jacob Smith |
57 Palette Walk, Huddersfield |
61 |
Yes |
Mr Jacob Smith |
07437 052331 |
Yes |
|
|
9 |
Mr Jack Brown |
49 Loom Terrace, Bradford |
31 |
No |
Mrs Alice Brown |
07880 199490 |
No |
|
|
10 |
Mr Oliver Harrison |
88 Tinshill Lane, Leeds |
41 |
Yes |
Mr Oliver Harrison |
0113 5190559 |
No |
|
|
11 |
Mr Sam White |
31 Kingston Drive, Leeds |
19 |
Yes |
Mrs Sophia White |
0113 0183695 |
|
No |
|
12 |
Miss Lillian White |
31 Kingston Drive, Leeds |
27 |
Yes |
Mrs Sophia White |
0113 0183695 |
m |
Yes |
|
13 |
Miss Marry Harris |
297 Green Road, Leeds |
45 |
Yes |
Miss Mary Harris |
0113 4579765 |
|
Yes |
|
14 |
Mr Luke Martin |
382 Moat Village, Leeds |
21 |
No |
Mr Luke Martin |
07210 601103 |
No |
|
|
15 |
Mrs Ruby Hill |
19 Willow Glade, Leeds |
40 |
Yes |
Mr Thomas Hill |
07166 442336 |
Yes |
|
|
16 |
Miss Gemma Allen |
327 Royal Avenue, Leeds |
21 |
Yes |
Miss Gemma Allen |
07785 147950 |
Yes |
Cancelled - No
|
Store: |
York |
Venue: |
York Art Hub |
Staff: J Ross |
|
Course: |
Acrylic Painting |
Level : |
Advanced |
|
|
|
Participant Name |
Address |
Age |
Paid |
Contact Name |
Telephone |
|
Attended |
|
1 |
Mr Gavin Sharp |
27 Ash Court, York |
27 |
Yes |
Mr Gavin Sharp |
07777 673780 |
|
|
|
2 |
Mrs Alison Baker |
16 Poplar Crescent, York |
60 |
Yes |
Mrs Alison Baker |
07810 554363 |
|
|
|
3 |
Mr Hunter Baker |
16 Poplar Crescent, York |
63 |
Yes |
Mrs Alison Baker |
07810 554363 |
|
|
|
4 |
Miss Lily Swift |
23 Pastel Row, York |
20 |
Yes |
Mrs Olivia Swift |
07988 698155 |
|
|
|
5 |
Mr James Clarke |
450 Bletchley Fold, York |
24 |
Yes |
Mr James Clarke |
07769 201356 |
|
|
|
6 |
Miss Riley Turner |
475 Derwent Mews, Huddersfield |
19 |
Yes |
Mrs Hazel Turner |
07466 343800 |
|
|
|
7 |
Mrs Heidi Parker |
194 Garth Road, Leeds |
29 |
Yes |
Mrs Heidi Parker |
07414 255389 |
|
|
|
8 |
Mr Toby Parker |
194 Garth Road, Leeds |
36 |
Yes |
Mrs Heidi Parker |
07414 255389 |
|
|
|
9 |
Mr Nathan Young |
95 Tent Vale, Leeds |
38 |
Yes |
Mrs Nancy Young |
07520 658893 |
|
|
|
10 |
Mrs Daisy Cook |
428 Garden Vale, Leeds |
52 |
Yes |
Mr Brandon Cook |
07341 817935 |
|
|
|
11 |
Mr Victor Marshall |
57 Acacia Grove, Leeds |
20 |
Yes |
Mrs Julia Marshall |
07520 658905 |
|
|
|
12 |
|
|
|
|
|
|
|
|
|
13 |
|
|
|
|
|
|
|
|
|
14 |
|
|
|
|
|
|
|
|
|
15 |
|
|
|
|
|
|
|
|
|
16 |
|
|
|
|
|
|
|
|
|
Date: |
14/05/2020 |
Time : |
11 :00 |
|
Fee: |
£50:00 |
Duration: |
8 hrs |
Cancelled - No
|
Store: |
York |
Venue: |
York Art Hub |
Staff: J Ross |
|
Course: |
Acrylic Painting |
Level : |
Advanced |
|
|
|
Participant Name |
Address |
Age |
Paid |
Contact Name |
Telephone |
|
Attended |
|
1 |
Mrs Lola Sharp |
27 Ash Court, York |
24 |
Yes |
Mr Gavin Sharp |
07777 673780 |
|
|
|
2 |
Mrs Alison Baker |
16 Poplar Crescent, York |
60 |
No |
Mrs Alison Baker |
07810 554363 |
|
|
|
3 |
Mr Hunter Baker |
16 Poplar Crescent, York |
63 |
No |
Mrs Alison Baker |
07810 554363 |
|
|
|
4 |
Mr Donald Taylor |
76 Elm Drive, York |
20 |
Yes |
Mr Donald Taylor |
07446 225480 |
|
|
|
5 |
Miss Lily Swift |
23 Pastel Row, York |
20 |
Yes |
Mrs Olivia Swift |
07988 698155 |
|
|
|
6 |
Mr James Clarke |
450 Bletchley Fold, York |
24 |
Yes |
Mr James Clarke |
07769 201356 |
|
|
|
7 |
Mr Mason Turner |
475 Derwent Mews, Huddersfield |
23 |
Yes |
Mrs Hazel Turner |
07466 343800 |
|
|
|
8 |
Miss Molly Mitchell |
754 Northland Terrace, York |
38 |
Yes |
Miss Molly Mitchell |
07828 636311 |
|
|
|
9 |
Miss Clara Cook |
428 Garden Vale, Leeds |
31 |
Yes |
Mr Brandon Cook |
07341 817935 |
|
|
|
10 |
Mr Victor Marshall |
57Acacia Grove, Leeds |
20 |
Yes |
Mrs Julia Marshall |
07520 658905 |
|
|
|
11 |
|
|
|
|
|
|
|
|
|
12 |
|
|
|
|
|
|
|
|
|
13 |
|
|
|
|
|
|
|
|
|
14 |
|
|
|
|
|
|
|
|
|
15 |
|
|
|
|
|
|
|
|
|
16 |
|
|
|
|
|
|
|
|
|
Date: |
21/11/2020 |
Time : |
10 :00 |
|
Fee: |
£50:00 |
Duration: |
8 hrs |
Cancelled - No
Task 1A – Design Database
You are required to submit:
- A context diagram (DFD level 0) representing the proposed WorksOfArt system
- An Entity-Relationship Diagram/Model
- Data Dictionary
- Normalisation of the booking form to the third normal form
For each of the above, give a brief explanation of what is shown. Design and Develop a Database on Microsoft Access. E.g What is a context diagram and what does it show? (If you use external references please write your references in Harvard Style)
Please state clearly any assumptions you have made in producing your data models and associated diagrams/documentation.
Task 1B – Design Database
You are required to develop a database system on Microsoft Access Database to meet the requirements of WorksOfArt. The organisation has requested that the database does the following tasks:
a) Create tables and relationships
b) Create Forms and Subforms, and develop them to an advanced standard.
c) Produce a query/report that shows all customers booked on to a particular course.
d) Produce a query/report showing participation at taster sessions.
e) Produce a query/report that shows all courses attended by a particular customer.
f) Produce a query/report that lists the courses led by a particular member of staff.
g) Produce a query/report that lists courses by popularity.
h) Produce a query/report that lists popularity of courses by store.
i) Produce a query/report the shows the income generated by each course sorted in descending order.
j) Produce a query/report that shows income generated by each store.
k) Produce a query/report that shows courses for the current month, with the number of participants shown for each.
l) Produce a query/report that identifies courses with less than five participants.
m) Produce a query/report that shows participants without email address.
n) Produce a query/report that shows total number of participants per venue.
o) Produce a query/report that identifies staff members who trained for more than 1 course.
p) Produce a query/report that shows participants who have attended more than one course.
q) Produce a query/report that shows participant list for cancelled sessions.
r) Produce a query/report that shows list of paid participants.
Submission instruction:
Task 1A
- Submit your work in a single Microsoft Word document. Include:
- Photos of your Context Diagram, ERD, Data Dictionary, and Normalisation
- Brief explanations and any assumptions
- Submit your Context Diagram as a separate Microsoft Visio file (or similar).
- Submit your ERD as a separate Microsoft Visio file (or similar).
- Submit your Data Dictionary as a separate Microsoft Excel file.
- Submit your Normalisation work as a separate Microsoft Excel file.
Task 1B
- Submit your database—including tables, forms, subforms, queries, reports, and relationships—as a Microsoft Access database file.
- Submit your Evaluation as a Microsoft Word document.
Task 2
To make your database more advanced, consider adding below features—some are even required.
Advanced Form Features
1. Multiple Views
- Single Form View for one record at a time
- Continuous Forms (tabular, stacked, or justified layouts) for scrolling through multiple records
- Split Form that shows both a single-record form and a datasheet simultaneously
- Tab Controls to group related fields on separate tabs
- Page Breaks to segment long forms into logical sections
- Navigation Forms (a special template) that let you build a menu-driven interface
- Record Source can be a table, query, or SQL statement—updated on the fly via VBA or macros
- Combo/Lookup Controls that pull values from related tables (foreign-key selectors)
- Calculated Controls (e.g. =[Qty]*[UnitPrice]) to show real-time computations
- Embedded Macros (AutoExec, OnCurrent, BeforeUpdate, etc.) to validate data, enforce business rules, or open other forms
- VBA Event Handling for custom behaviours (e.g. dynamic filtering, conditional formatting, complex validation)
- Data Macros (in Access 2010+) to trigger logic at the table level (e.g. cascade updates/deletes)
- Highlight controls or entire records based on their values
- Custom input masks and validation rules to ensure data integrity
- Command Buttons to run macros/VBA (e.g. “New Record,” “Print,” “Export to Excel”)
- Custom Tabs/Ribbon Groups in the Access UI to expose form-specific commands
- Use Themes to ensure consistent fonts/colours
- Anchoring and Auto-Resize to make forms responsive when users resize windows
2. Navigation Controls
3. Rich Data Binding
4. Automation & Logic
5. Conditional Formatting & Validation
6. Custom Command Buttons & Ribbons
7. Theming & Layout
Adavanced Subform Features
Subforms let you display and edit a “many” side of a one-to-many relationship right inside the “one” side’s form:
1. Master/Child Linking
- Link Master Fields and Link Child Fields properties automatically synchronise which related records show up
- Parent form’s current primary key value filters the subform’s record source
- Subform Default View can be set independently (Datasheet, Continuous Form, Single Form, or Split)
- You can nest multiple subforms (e.g. three levels deep) for complex relationships
- Add/Edit/Delete related records directly in the subform
- Allow Deletions, Allow Edits, Allow Additions toggles for fine-grained control
- Source Object can be a form object name or a SQL string—swappable at runtime via VBA
- Filter and Order By can be applied dynamically from the parent
- Height/Width properties let you embed datasheet-style grids neatly
- Conditional Formatting in the subform can highlight related-record statuses
- Subform events (e.g. OnCurrent, AfterUpdate) can call parent-form procedures to keep both in syn
2. View Flexibility
3. Record Operations
4. Synchronised Properties
5. UI Cohesion
6. Event Propagation
Advanced Query Features:
1. Query Types & Templates
- Select Queries with complex criteria, joins, grouping and sorting
- Crosstab (Pivot) Queries to summarise data in a matrix of row/column headings
- Parameter Queries that prompt the user for one or more values at run-time
- Append (add records to another table)
- Update (modify existing records)
- Delete (remove records)
- Make-Table (create a new table from query results)
- Union Queries (via SQL View) to stack results from multiple SELECT statements
- Pass-Through Queries that send SQL directly to an ODBC-linked server for faster processing
- Data Definition Queries (CREATE, ALTER, DROP) to modify database schema
2. SQL-Level Power
- Subqueries in the SELECT, FROM or WHERE clauses
- Aggregate Functions beyond the basics: SUM(), AVG(), COUNT(), MIN(), MAX() plus FIRST(), LAST()
- GROUP BY with HAVING to filter on aggregates
- DISTINCTROW vs. DISTINCT to control duplicate-elimination semantics
- TOP N (and PERCENT) to return only the highest/lowest values
- Custom Expressions: nest IIf, Nz, DatePart, Format, domain aggregates (DLookup, DCount, etc.)
- JOIN Types: inner joins, left/right outer joins, self-joins and multi-table chaining
3. Parameterisation & User Prompts
- Prompted Criteria: use square-bracketed prompts (e.g. [Enter start date:]) to drive filtering
- Parameter Declaration (in Query Properties) to enforce data types for each prompt
- Dynamic SQL in VBA: build and execute SQL strings on the fly for truly flexible queries
4. Design-Grid Enhancements
- Calculated Fields directly in the design grid (e.g. TotalCost: [Qty]*[UnitPrice])
- OR/AND Rows for compound criteria across multiple fields
- Sort and Show/Hide toggles per column
- Lookup Columns with combo-box display of related values
- Query Properties Pane: toggle Unique Values, Unique Records, Omit Duplicates, Subdatasheet Name
5. Performance & Optimisation
- Indexes & Primary Keys drive join performance—Access will auto-use them in SQL
- Pass-Through & Linked-Table Queries push processing onto a server
- Query Plan Hints: manually rewriting joins or union logic to leverage indexes
- Stored Parameter Queries (QueryDefs) improve reusability and performance in VBA
6. Integration & Automation
- VBA Event Hooks: call DoCmd.OpenQuery, loop recordsets, or execute CurrentDb.Execute on Action queries
- Macros: attach data-macro logic to run before/after query events
- Output Options: directly export to Excel/CSV, email via Outlook, or bind to forms/reports
Advanced report features:
1. Data Grouping & Summarisation
· Multi-Level Grouping
- Define up to 10 grouping levels (e.g. Year → Quarter → Month)
- Specify keep together or page break at each group level
- Use the RunningSum property for cumulative subtotals
- Group Footer summaries (Sum(), Avg(), Count(), Min(), Max())
- Pivot your data into a matrix of rows × columns with summaries
· Running Totals & Aggregates
· Cross-Tab Reports
2. Layout & Design Flexibility
· Section Control
- Customize Headers/Footers at Report, Group and Page levels
- Show/hide sections dynamically via VBA or macros
- Prevent single records or groups from splitting across pages
- Embed charts (column, bar, pie) directly on the report
- Use subreports to nest related data (e.g. line-items under an order)
- Add images, shapes, lines, and ActiveX/OLE objects
- Live drag-and-drop resizing, alignment guides, and snap-to-grid
- Themes and consistent use of fonts/colours
· Repeat/Keep Together
· Rich Controls
· Layout View Enhancements
3. Conditional Formatting & Dynamic Content
· Conditional Formatting Rules
- Highlight rows or fields (e.g. overdue orders in red)
- Vary font styles, sizes or icons based on data values
- Expressions
- Domain aggregates (DLookup, DCount) to pull in related-table values
- Prompt users for criteria at runtime ([Enter start date:])
- Use VBA to inject parameters into the report’s RecordSource
· Calculated & Unbound Controls
· Parameter-Driven Reports
4. Interactivity & Automation
· Drill-Down & Hyperlinks
- Clickable fields that open other forms, reports or external URLs
- Allow end-users to sort by clicking column headers (Access 2010+)
- OnOpen, OnFormat, OnPrint events to dynamically adjust content
- Macros to set filters, toggle controls, or export on report events
· Interactive Sorting
· Event-Driven VBA & Macros
5. Export & Distribution Options
· Built-In Wizards & VBA Output
- DoCmd.OutputTo for PDF, XPS, Excel, Text or Snapshot format
- Mail reports directly via Outlook automation (SendObject)
- Preserves exact layout for sharing
- Loop through parameter values to generate and send individualised reports
· Snapshot & PDF Format
· Data-Driven Emailing
6. Performance & Optimization
· Query-Based RecordSource
- Leverage optimised SELECT statements or pass-through queries
- Ensure grouped or sorted fields are indexed to speed rendering
- Apply filters in VBA or macros before opening to limit record counts
· Indexed Fields for Sorting/Grouping
· Pre-Filtering
|
Criteria |
Distinction / First |
Merit / 2:1 |
Pass / 2:2 |
Pass / 3rd |
Fail |
|
Gather, record and Interpret data to develop a structured database. 30% of total mark |
70 - 100% The WorksOfArt database development demonstrates an exemplary approach to gathering, recording, and interpreting data to create a structured database. A sophisticated data gathering strategy is employed, considering various sources and ensuring data accuracy. The recording process is meticulous, capturing relevant details with precision. The interpretation of data is insightful, leading to a well-organised and |
60 - 69% The approach to gathering, recording, and interpreting data for the WorksOfArt database development is solid. Data gathering considers multiple sources, and recording is done with accuracy. The interpretation of data leads to a structured database, although there may be minor gaps or assumptions not explicitly stated. The resulting database is well-organised, reflecting a proficient understanding of |
50 - 59% Gathering, recording, and interpreting data for the WorksOfArt database development are satisfactory. The data gathering strategy considers relevant sources, and recording is done adequately. The interpretation of data leads to a structured database, but there may be some areas where clarity is lacking. Assumptions made during the process are mentioned, although their completeness may vary. The resulting database meets basic |
40 - 49% The approach to gathering, recording, and interpreting data for the WorksOfArt database development is basic. Data gathering considers fundamental sources, and recording is done at a basic level. The interpretation of data leads to a structured database, but there may be areas lacking clarity or depth. Assumptions made during the process are present, but their completeness may be limited. The resulting database meets |
0 - 39% The approach to gathering, recording, and interpreting data for the WorksOfArt database development is significantly flawed or incomplete. Data gathering may be insufficient or lack relevance, and recording may be inaccurate or incomplete. The interpretation of data may not lead to a well- structured database, and assumptions made during the process may be unrealistic or not adequately explained. The resulting database |
|
|
highly structured database. Assumptions made during the process are clearly stated, showcasing transparency and a comprehensive understanding of structured database development. |
structured database development. |
organisational standards, indicating a competent understanding of structured database development. |
minimum organisational standards, indicating a basic understanding of structured database development. |
may not meet essential organisational standards, indicating a lack of understanding of structured database development. |
|
Define the tools and methods that resolve given database scenarios. 50% of total mark |
70 - 100% The WorksOfArt database development illustrates an exceptional understanding of the tools and methods required to resolve complex database scenarios. A wide array of advanced tools, such as comprehensive database management systems and sophisticated modelling tools, is adeptly employed. Methods, including normalisation, data flow diagrams, and entity-relationship modelling, are applied with precision to resolve intricate scenarios. The documentation demonstrates clarity in |
60 - 69% The understanding of tools and methods to resolve database scenarios in the WorksOfArt database development is solid. A range of suitable tools, including effective database management systems and modelling tools, is used. Methods such as normalisation and entity-relationship modelling are applied proficiently. The documentation provides clear insights into the choice and application of tools and methods for resolving database scenarios. |
50 - 59% The WorksOfArt database development exhibits a satisfactory understanding of tools and methods to resolve database scenarios. Appropriate tools, including basic database management systems and modelling tools, are used effectively. Methods like normalisation and entity- relationship modelling are applied adequately. The documentation provides a basic understanding of how chosen tools and methods contribute to resolving specific database challenges. |
40 - 49% The understanding of tools and methods to resolve database scenarios in the WorksOfArt database development is basic. Tools used, including rudimentary database management systems and modelling tools, meet minimum requirements. Methods such as normalisation and entity-relationship modelling are applied at a basic level. The documentation offers a fundamental understanding of the role of tools and methods in addressing database challenges. |
0 - 39% The understanding of tools and methods to resolve database scenarios in the WorksOfArt database development is significantly flawed or missing. The choice and application of tools and methods may not be appropriate or not adequately explained. The documentation lacks clarity in defining how tools and methods contribute to resolving specific database challenges, indicating a lack of understanding of the essential aspects of tools and methods in database development. |
|
|
defining how each tool and method contributes to resolving specific database challenges. |
|
|
|
|
|
Use appropriate tools and methodologies, to develop a database solution. 20% of total mark |
70 - 100% The development of the WorksOfArt database solution exemplifies an outstanding utilisation of advanced tools and methodologies. Sophisticated database management systems and modelling tools are adeptly employed, showcasing a comprehensive understanding of their features and functionalities. The chosen methodologies, such as agile or iterative approaches, are applied with precision, contributing to an exceptionally well- |
60 - 69% The WorksOfArt database solution demonstrates a solid utilisation of appropriate tools and methodologies. Effective database management systems and modelling tools are employed, showcasing a good understanding of their features. Methodologies, such as agile or iterative approaches, are applied proficiently, contributing to a well-structured database solution. The documentation provides clarity in explaining the strategic use of tools and methodologies, |
50 - 59% The development of the WorksOfArt database solution showcases a satisfactory utilisation of appropriate tools and methodologies. Basic database management systems and modelling tools are used effectively, meeting the project`s requirements. Common methodologies, such as agile or iterative approaches, are applied adequately, contributing to a functional database solution. The documentation offers a basic understanding of the strategic use of tools |
40 - 49% The utilisation of appropriate tools and methodologies in the WorksOfArt database solution is basic. Basic database management systems and modelling tools are used to meet minimum requirements. Common methodologies, such as agile or iterative approaches, are applied at a basic level, contributing to a functional but rudimentary database solution. The documentation provides a fundamental understanding of the |
0 - 39% The utilisation of tools and methodologies in the WorksOfArt database solution is significantly flawed or missing. The choice and application of tools and methodologies may not be appropriate or not adequately explained. The documentation lacks clarity in defining how tools and methodologies contribute to the development process, indicating a lack of understanding of the essential aspects of using appropriate tools and methodologies in |
|
|
crafted and efficient database solution. The documentation provides clear insights into the strategic use of tools and methodologies, aligning with best practices in database development. |
contributing to a sound database development process. |
and methodologies in the database development process. |
strategic use of tools and methodologies. |
database development. |
Task 2 30% Report Evaluation
Commentary and Evaluation: 1200 words
You have applied MS Access tools and database design methods to create a solution and extraction of data to meet The WorksOfArt scenario. Reflect on the tools used to design and develop the database e.g. ERM, Normalisation, Data dictionary, Context Diagram, MS Access. Reflect and comment on your proposed database solution, on how it meets the needs of the business.
Also reflect on any drawbacks and problems you have encountered, how did you identify them, and how did you find solutions? It is not expected that your solution will be perfect the first time and therefore you must reflect on how you would change the design given more time and the benefit of hindsight.
You should also discuss any ethical considerations of gathering and recording data, when designing and developing a database.
|
Criteria |
Distinction / First |
Merit / 2:1 |
Pass / 2:2 |
Pass / 3rd |
Fail |
|
Reflective Analysis - Learning Outcome: Select and use research methods to describe key elements of database design. 50% of total mark |
70 - 100% The reflective analysis demonstrates a profound understanding of research methods in database design. Clear and insightful reflections on the application of MS Access tools, including ERM, Normalisation, Data Dictionary, and Context Diagram, showcase an advanced comprehension of research-driven design. The discussion on how the proposed database solution meets business needs is comprehensive and well-justified. Thorough identification and resolution of drawbacks and problems with a reflective discussion on how these were recognized and solved. Ethical considerations regarding data gathering and recording are deeply explored and integrated into the overall reflection. |
60 - 69% The reflective analysis demonstrates a solid understanding of research methods in database design. Design and Develop a Database on Microsoft Access Adequate reflections on the application of MS Access tools, with clarity on ERM, Normalisation, Data Dictionary, and Context Diagram, show a good grasp of research-driven design. The discussion on how the proposed database solution meets business needs is substantial and well-justified. Identification and resolution of drawbacks and problems are proficient, with a reflective discussion on how these were recognized and solved. Ethical considerations regarding data gathering and recording are adequately explored and considered. |
50 - 59% The reflective analysis demonstrates a satisfactory understanding of research methods in database design. Basic reflections on the application of MS Access tools, including ERM, Normalisation, Data Dictionary, and Context Diagram, show a competent grasp of research-driven design. The discussion on how the proposed database solution meets business needs is satisfactory and reasonably justified. Identification and resolution of drawbacks and problems are basic, with an attempt at a reflective discussion on how these were recognized and solved. Ethical considerations regarding data gathering and recording are mentioned but may lack depth in exploration. |
40 - 49% The reflective analysis demonstrates a basic understanding of research methods in database design. Limited reflections on the application of MS Access tools, including ERM, Normalisation, Data Dictionary, and Context Diagram, indicate a basic grasp of research-driven design. The discussion on how the proposed database solution meets business needs is minimal and lacks depth in justification. Identification and resolution of drawbacks and problems are basic, with limited reflection on how these were recognized and solved. Ethical considerations regarding data gathering and recording are mentioned but lack depth and integration into the overall reflection. |
0 - 39% The reflective analysis demonstrates an inadequate understanding of research methods in database design. Minimal or no reflections on the application of MS Access tools, including ERM, Normalisation, Data Dictionary, and Context Diagram, indicate a lack of grasp of research-driven design. The discussion on how the proposed database solution meets business needs is either missing or significantly flawed. Identification and resolution of drawbacks and problems are not adequately addressed, with no reflective discussion on how these were recognized and solved. Ethical considerations regarding data gathering and recording are either not present or are significantly flawed. |
|
|
|
|
|
|
|
|
Operate ethically in the gathering, recording and interpretation of data.
50% of total mark |
70 - 100% The reflective analysis demonstrates an exemplary commitment to ethical principles throughout the data lifecycle. Ethical considerations related to data gathering, recording, and interpretation are thoroughly explored and seamlessly integrated into the development process. The discussion includes nuanced insights into potential ethical dilemmas, providing well-justified resolutions. Clear acknowledgment of the importance of ethical practices in database development is evident, aligning with professional and legal standards. |
60 - 69% The reflective analysis exhibits a solid commitment to ethical principles in data operations. Ethical considerations related to data gathering, recording, and interpretation are well- addressed and incorporated into the development process. The discussion acknowledges potential ethical challenges and provides reasonable resolutions. The importance of ethical practices in database development is recognized and discussed with clarity. |
50 - 59% The reflective analysis demonstrates a satisfactory commitment to ethical principles in data operations. Ethical considerations related to data gathering, recording, and interpretation are adequately addressed, and attempts are made to integrate them into the development process. Some acknowledgment of potential ethical challenges and basic resolutions are presented. The importance of ethical practices in database development is mentioned but may lack depth. |
40 - 49% The reflective analysis provides a basic commitment to ethical principles in data operations. Ethical considerations related to data gathering, recording, and interpretation are mentioned, but the integration into the development process is minimal. Limited acknowledgment of potential ethical challenges and basic resolutions are presented. The importance of ethical practices in database development is mentioned but may lack clarity or depth. |
0 - 39% The reflective analysis lacks a clear commitment to ethical principles in data operations. Ethical considerations related to data gathering, recording, and interpretation may be missing or significantly flawed. Limited or no acknowledgment of potential ethical challenges or resolutions is presented. The importance of ethical practices in database development is either not addressed or significantly flawed. |
