Lab 5 Instructions - Bus188 Lab 5 Spring 2007 Access Skills...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Bus188 Lab 5 Spring 2007 Access Skills Assessment Situation Your boss notified you that errors have been identified in customer orders processed in 2006. Sales tax was charged for orders received from outside the United States where customers paid with either cash or check. To help determine the proper corrective action, you must understand how widespread the problem is and present your findings back to your boss. To complete this assignment you must: 1) Supplement a list of customers and order provided 2) Identify all orders placed in 2006 by customers outside the US that paid with either cash or check 3) Calculate the total refund amount for each customer 4) Prepare a report summarizing your findings Resources Required to Complete (click to access) 1) Customer Information.mdb (stored as Customer Information.zip) 2) Customers.xls 3) S07_Sample_Report.ppt 4) Lab5 Coversheet.doc Exercise Steps 1) Create a new database table in an existing database personalized with some of your information a. Open the attached database (Customer Information.mdb) b. Create a table called Customers with all the same fields found in the attached spreadsheet (Customers.xls) c. Add yourself and two friends to the table using Customer Numbers 101,
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 09/08/2010 for the course BUS 188 at San Jose State University .

Page1 / 4

Lab 5 Instructions - Bus188 Lab 5 Spring 2007 Access Skills...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online