Working with MS Access

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-1 to create a database table named Items.

The owner wants you to:

1. Add a calculated field to this table that shows the commission amount paid to the consignors.
2. Create an Inventory Report. The Inventory Report summarizes the inventory by item type. This report will include 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.
3. Create one other report that you think would be useful to the owner.