0. Each student should submit three files onto Moodle:

   1. A Microsoft Access file containing all deliverables that are specified near the end of the case study. [There is, however, no need to create any memo or navigation pane.]

   2. A written report in MS Word file that provides a background description of the case study, how you approach the problem, a description of the solution, and a critical evaluation of the solution.

   3. A PowerPoint file that you use in the presentation of the case study.

   4. A video file showing the presenter as he or she goes through the PowerPoint presentation. If the video file is too

      large, upload it onto Google Drive or OneDrive, share it with your teacher and submit the share link in a Word file onto Moodle.

   5. Assume that the audience does not have access to the book "Problem-Solving Cases in Microsoft Access and Excel" and pretend that you are actually trying to solve a real life problem. In the written report, describe the problem and you are facing, explain how you approach the problem with MS Access and present the solution. You will only need to report the key steps involved in the development of your solution. If unsure, please consult the marking scheme on page 2 of this document or your teacher. The report should end with a conclusion that critically evaluates the limitations of the solution. There is no page limit. A sample report has been prepared for you to help you with your report writing.

      Suggested structure of the report:

   6. Introduction / problem definition

   7. Table design and relationships

   8. Forms and subforms

   9. Queries

   10. Reports

   11. Conclusion, ethical issues that may arise (if any), limitations and suggested improvement (if any)

       There is no need to create any memo or navigation pane. Your submitted Access file will be evaluated together with the written report.

   12. 

A B D E G H J K L M N o Customer ID 101 101 UT 102 UT nm mm UT UT UT 103 104 104 104 105 105 106 107 Last Name Dickerson Dickerson Faber Hearn Lavelle Lavelle Lavelle Nelson Nelson Schwartz Sunzar Turner Trapp Wills Wills Wills First Name Allen Allen Dale Arthur Shirley Shirley Shirley Janice Janice Byron Sam Cynthia John Billy Billy Billy Address 138 Woodlawn Ave 138 Woodlawn Ave 121 Chaucer Lane 26 Julie Court 4001 Birch Street 4001 Birch Street 4001 Birch Street 23 Geneva Blvd 23 Geneva Blvd 2 Waverly Rd 103 Chadd Rd 1502 Valley Stream Lane 220 E Main Street 25 Brown Lane 25 Brown Lane 25 Brown Lane City Salt Lake City Salt Lake City Salt Lake City Salt Lake City Salt Lake City Salt Lake City Salt Lake City Salt Lake City Salt Lake City Salt Lake City Salt Lake City Salt Lake City Salt Lake City Salt Lake City Salt Lake City Salt Lake City w555 555555 5555555 Zip 84105 84105 84109 84109 84105 84105 84105 84105 84105 84109 84105 84109 84106 84109 84109 84109 Phone (801)256-0097 (801)256-0097 (801)549-3324 (801)543-7611 (801)736-5512 (801)736-5512 (801)736-5512 (801)469-3541 (801)469-3541 (801)536-0954 (801)762-1298 (801)675-9812 (801)757-8876 (801)435-9123 (801)435-9123 (801)435-9123 Email Address AED @zoom.net AED @zoom.net Oldie@comcast.net Ahearn@aol.com Shirl121@gmail.com Shirl121@gmail.com Shirl121@gmail.com Nels@gmail.com NelsJ@gmail.com BS599@aol.com 55SS@zoom.net CT@gmail.com Trapp334@gmail.com Billyw@aol.com Billyw@aol.com Billyw@aol.com Number of Acres Pool? 2. TRUE 2 TRUE 1 FALSE 1 FALSE 3 TRUE TRUE TRUE 5 FALSE 5 FALSE 9 FALSE 15 TRUE 2 TRUE 6 TRUE 8 FALSE 8 FALSE 8 FALSE Garage Size Job ID 3 5001 3 5002 2 5003 2 5004 2 5005 2 5006 2 5015 4 5007 4 5016 4 5008 6 5009 3 5010 1 5011 2 5012 2 5013 2 5014 Square Footage Work Address 250 138 Woodlawn Ave 500 138 Woodlawn Ave 1250 121 Chaucer Lane 500 26 Julie Court 100 55 Peachtree Court 125 55 Peachtree Court 150 55 Peachtree Court 300 23 Geneva Blvd 300 23 Geneva Blvd 125 2 Waverly Rd 2500 103 Chadd Rd 125 1502 Valley Stream Lane 250 220 E Main Street 100 2910 Lakefront Dr 100 2910 Lakefront Dr 10 2910 Lakefront Dr UT UT 108 109 110 110 110 UT P Q R S T U V Comments Start Date End Date inlaid golden star chemical stain accents sawcut design chemical stain accents sawcut design Concrete Type Basic Basic Superior Upgraded Basic Superior Upgraded Upgraded Upgraded Upgraded Basic Superior Superior Basic Basic Basic Description Basic stamped one color Basic stamped one color Upgraded with hand-applied designs Stamped with 2-3 colors and border Basic stamped one color Upgraded with hand-applied designs Stamped with 2-3 colors and border Stamped with 2-3 colors and border Stamped with 2-3 colors and border Stamped with 2-3 colors and border Basic stamped one color Upgraded with hand-applied designs Upgraded with hand-applied designs Basic stamped one color Basic stamped one color Basic stamped one color Price Per Square Foot Owner Name 10.00 Candy 10.00 Candy 20.00 Candy 16.00 Candy 10.00 Candy 20.00 Carl 16.00 Carl 16.00 Carl 16.00 Candy 16.00 Carl 10.00 Carl 20.00 Carl 20.00 Carl 10.00 Candy 10.00 Candy 10.00 Carl 15/4/2013 17/4/2013 20/4/2013 22/4/2013 27/4/2013 1/4/2013 7/5/2013 6/4/2013 10/5/2013 8/4/2013 10/4/2013 20/4/2013 25/4/2013 2/5/2013 4/5/2013 1/5/2013 16/4/2013 18/4/2013 21/4/2013 25/4/2013 30/4/2013 5/4/2013 8/5/2013 7/4/2013 12/5/2013 9/4/2013 12/4/2013 22/4/2013 27/4/2013 3/5/2013 5/5/2013 5/5/2013 A B D E G H J K L M N o Customer ID 101 101 UT 102 UT nm mm UT UT UT 103 104 104 104 105 105 106 107 Last Name Dickerson Dickerson Faber Hearn Lavelle Lavelle Lavelle Nelson Nelson Schwartz Sunzar Turner Trapp Wills Wills Wills First Name Allen Allen Dale Arthur Shirley Shirley Shirley Janice Janice Byron Sam Cynthia John Billy Billy Billy Address 138 Woodlawn Ave 138 Woodlawn Ave 121 Chaucer Lane 26 Julie Court 4001 Birch Street 4001 Birch Street 4001 Birch Street 23 Geneva Blvd 23 Geneva Blvd 2 Waverly Rd 103 Chadd Rd 1502 Valley Stream Lane 220 E Main Street 25 Brown Lane 25 Brown Lane 25 Brown Lane City Salt Lake City Salt Lake City Salt Lake City Salt Lake City Salt Lake City Salt Lake City Salt Lake City Salt Lake City Salt Lake City Salt Lake City Salt Lake City Salt Lake City Salt Lake City Salt Lake City Salt Lake City Salt Lake City w555 555555 5555555 Zip 84105 84105 84109 84109 84105 84105 84105 84105 84105 84109 84105 84109 84106 84109 84109 84109 Phone (801)256-0097 (801)256-0097 (801)549-3324 (801)543-7611 (801)736-5512 (801)736-5512 (801)736-5512 (801)469-3541 (801)469-3541 (801)536-0954 (801)762-1298 (801)675-9812 (801)757-8876 (801)435-9123 (801)435-9123 (801)435-9123 Email Address AED @zoom.net AED @zoom.net Oldie@comcast.net Ahearn@aol.com Shirl121@gmail.com Shirl121@gmail.com Shirl121@gmail.com Nels@gmail.com NelsJ@gmail.com BS599@aol.com 55SS@zoom.net CT@gmail.com Trapp334@gmail.com Billyw@aol.com Billyw@aol.com Billyw@aol.com Number of Acres Pool? 2. TRUE 2 TRUE 1 FALSE 1 FALSE 3 TRUE TRUE TRUE 5 FALSE 5 FALSE 9 FALSE 15 TRUE 2 TRUE 6 TRUE 8 FALSE 8 FALSE 8 FALSE Garage Size Job ID 3 5001 3 5002 2 5003 2 5004 2 5005 2 5006 2 5015 4 5007 4 5016 4 5008 6 5009 3 5010 1 5011 2 5012 2 5013 2 5014 Square Footage Work Address 250 138 Woodlawn Ave 500 138 Woodlawn Ave 1250 121 Chaucer Lane 500 26 Julie Court 100 55 Peachtree Court 125 55 Peachtree Court 150 55 Peachtree Court 300 23 Geneva Blvd 300 23 Geneva Blvd 125 2 Waverly Rd 2500 103 Chadd Rd 125 1502 Valley Stream Lane 250 220 E Main Street 100 2910 Lakefront Dr 100 2910 Lakefront Dr 10 2910 Lakefront Dr UT UT 108 109 110 110 110 UT P Q R S T U V Comments Start Date End Date inlaid golden star chemical stain accents sawcut design chemical stain accents sawcut design Concrete Type Basic Basic Superior Upgraded Basic Superior Upgraded Upgraded Upgraded Upgraded Basic Superior Superior Basic Basic Basic Description Basic stamped one color Basic stamped one color Upgraded with hand-applied designs Stamped with 2-3 colors and border Basic stamped one color Upgraded with hand-applied designs Stamped with 2-3 colors and border Stamped with 2-3 colors and border Stamped with 2-3 colors and border Stamped with 2-3 colors and border Basic stamped one color Upgraded with hand-applied designs Upgraded with hand-applied designs Basic stamped one color Basic stamped one color Basic stamped one color Price Per Square Foot Owner Name 10.00 Candy 10.00 Candy 20.00 Candy 16.00 Candy 10.00 Candy 20.00 Carl 16.00 Carl 16.00 Carl 16.00 Candy 16.00 Carl 10.00 Carl 20.00 Carl 20.00 Carl 10.00 Candy 10.00 Candy 10.00 Carl 15/4/2013 17/4/2013 20/4/2013 22/4/2013 27/4/2013 1/4/2013 7/5/2013 6/4/2013 10/5/2013 8/4/2013 10/4/2013 20/4/2013 25/4/2013 2/5/2013 4/5/2013 1/5/2013 16/4/2013 18/4/2013 21/4/2013 25/4/2013 30/4/2013 5/4/2013 8/5/2013 7/4/2013 12/5/2013 9/4/2013 12/4/2013 22/4/2013 27/4/2013 3/5/2013 5/5/2013 5/5/2013