Question: Seconds Later a clothing consignment shop is fast becoming a

Seconds Later, a clothing consignment shop, is fast becoming a favorite place to shop. The owner has asked you to create an Access database to help manage inventory. Download and import the information provided in the spreadsheet Ch01Ex02 to create a database with two tables (Consignors and Items).The owner wants you to add a calculated field to the items table that shows the net selling price after he has paid the commission to the consignors. Start with two reports: an Inventory Report and a Consignor Report. The Inventory Report summarizes the inventory by item type. This report will include the number of items and the total selling price for each item type, plus the total sales value of each inventory type. It will also include the total potential commission to be earned if all items are sold. The Consignor Report will list the total number of items and the total selling price and commission to be paid for each consignor. What other reports could you make with this data that would be useful to the owner?

Sale on SolutionInn
  • CreatedJanuary 03, 2015
  • Files Included
Post your question