9
Just Breathe Yoga Center
Instructor and Class Schedule Database
ACCESS WORKING CASE: ADVANCED LEVEL
Submission Instructions Complete Case 9 in Access. Answer the questions at the end of this case and ask your instructor for submission instructions.
Preview You are the operations manager for Just Breathe Yoga Center. The yoga center has seven locations and more than 26 instructors around the western region of the United States. The existing database organizes the class schedules, instructor, and location information. From the database you need to run queries on which locations and classes are the most popular, and you need to monitor the revenue for each yoga center.
Skill Set
| One-to-many table relationship |
| Parameter query |
| Grouping query |
| Make-Table query |
| Delete-Table query |
Background Just Breathe Yoga Center started its first studio in Denver, Colorado, and has expanded to other Western states. You have access to the yoga center's database of all the studios, which includes class schedules, location, and employee information. As operations manager, you need to create a parameter query to search particular class schedules for the different locations. You also want to create two queries that identify the Revenue by location and Revenue by class description. The final queries will be a Make-Table Query and a Delete Query.
CASE ANALYSIS
Output Requirements
You are to ...
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.
