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

2

Access—Queries and Reports

4

Up the Hill Bakery

Inventory Control

ACCESS TEACHING CASE: INTERMEDIATE LEVEL

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

Preview You are the store manager of the bakery. You want to run several queries from the database every week to keep track of the daily and weekly business and to create reports based on these findings. From these queries you will create weekly reports and be able to build inferences based on the findings and patterns found in them. At the end of this case you will be able to create queries with a variety of selection criteria and reports based on the queries with a variety of value-added features.

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 As the store manager of the bakery you need to create several weekly reports showing a variety of weekly sales statistics. You need reports showing the relative popularity of the bakery items and the revenue breakdown per bakery item. As store manager you need a third weekly report providing information about the items received from outside suppliers and ...