MIS Cases: Solving Small Business Scenarios Using Application Software, 2nd Edition

8

Sun and Beach Clothing

Inventory and Supplier Analysis

ACCESS WORKING CASE: ADVANCED LEVEL

Submission Instructions Complete Case 8 in Access. Answer the questions at the end of this case and ask your instructor for submission instructions.

Preview You are the sales manager of Sun and Beach Clothing Store. This store offers a wide variety of popular beach clothing and accessories. The store is going through a transition period and needs to discontinue a few of the suppliers who have the lowest sales in the store. As the sales manager of the store you need to create various weekly reports on inventory to identify the most popular and least popular items that are sold in the store.

Skill Set

One-to-Many table relationship

Parameter query

Grouping query

Make-Table query

Delete-Table query

Background Sun and Beach Clothing Store, located in Newport, California, carries a wide variety of popular beach clothing and accessories. It carries one of the largest selections of brand-name clothing in the area. The store has a modest database application used to keep track of inventory and supplier information. As the sales manager you need to create various weekly inventory reports. You will review these reports to identify the relative popularity of items so you can decide which suppliers to cancel. You also want to monitor the sales and profits for each brand of clothing and ...