. Achieving Operational Excellence, Building a Relational Database for Inventory Management Software skills: Database design, querying and reporting Business skills: Inventory management 6-10 This exercise requires that students know how to create queries and reports using information from multiple tables. The solutions provided were created using the query wizard and report wizard capabilities of Access. Students can, of course, create more sophisticated reports if they wish. Prepare a report that identifies the five most expensive bicycles. The report should list the bicycles in descending order from most expensive to lease expensive, the quantity on hand for each, and the markup percentage for each. Prepare a report that lists each supplier, its products, their quantities on hand, and associated reorder levels. The report should be sorted alphabetically by suppller. Within each supplier category, the products should be sorted alphabetically Prepare a report listing only the bicycles that are low in stock and need to be reordered. The report should provide supplier information for the items identified. Write a brief description of how the database could be enhanced to further improve management of the business. What tables or fields should be added? What additional reports would be useful