3
Access—Advanced Queries and Reports
7
Up the Hill Bakery
Customer Order Database
ACCESS TEACHING CASE: ADVANCED LEVEL
Submission Instructions Complete Case 7 in Access. Answer the questions at the end of this case and ask your instructor for submission instructions.
Preview You are the manager of the Up the Hill Bakery and you need to keep track of the daily delivery orders by customers. At the end of the day you need to run a report on how many bakery items the chefs need to bake for the next morning delivery. You also need to create a daily report of the billing amount for each of the delivery orders.
Skill Set
| One-to-many table relationship |
| Parameter query |
| Grouping query |
| Make-Table query |
| Delete-Table query |
Background As the manager of the small bakery, you want to keep track of product and customer information in two database tables. The bakery provides a delivery service for fresh bread and pastries to local residents, offices, and small restaurants. The chefs need a daily report of how many bakery items they need to bake for delivery and you need a daily report of the billing amount for each of the delivery orders. In addition, you want to make a few changes to the customer table, and create a new database table for restaurants only, which involves deleting the ...
Get MIS Cases: Solving Small Business Scenarios Using Application Software, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
