Due: June 20, 2000

Now that your tables are created and populated, you will use the tables with their data to complete this assignment.

1. We are trying to find out where our current parts are stored.. Write a report, grouped by warehouse, showing the part number, part description, unit price and quantity on hand.   Include a title, date of report, subtotals showing total number of parts, value of parts and the grand total of all parts and their value.
   
2. Design an order form. It should have the customer's name, address, order number and date of the order on top. The bottom part should contain the part numbers, part description, number ordered, quoted price, and cost for the number of items ordered. Total the cost of the order. This should look like a standard Bill of Sales. Print out all the orders.
   
3. Redo the same report as for number 1 but ask which order number you want the report for and only print out the information for that order.