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

5

Earth Foods Grocery Store

Special Services Database

ACCESS WORKING CASE: INTERMEDIATE LEVEL

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

Preview You are the regional manager for special services at Earth Foods grocery stores located in New Mexico. You manage the additional services section that is provided in the grocery store. These special services include banking, floral service, coffee shop, and others. As regional manager you need to create various queries and reports to supervise the different services within the grocery store.

Skill Set

Queries	Reports
Insert criteria	Format reports
Sorting	Sorting
Show option	Grouping
Queries based on more than one table	Header and footer Labels

Background Earth Foods is a major chain of 12 grocery stores throughout the state of New Mexico. In addition to selling groceries, many of the stores provide unique services to meet their customers' needs; these services include in-store dry-cleaning, banking, floral service, coffee shop, post office, and others. Not all the grocery stores have these extra services. Earth Foods has created a prototype set of database tables but has not developed a way of retrieving and reporting which stores have the different type of services and who manages them. You are to create the queries ...