2
Dr. Garrett's Chiropractic Office
Services and Patient Database
ACCESS WORKING CASE: BEGINNING LEVEL
Submission Instructions Complete Case 2 in Access. Answer the questions at the end of this case and ask your instructor for submission instructions.
Preview You are the office manager for Dr. Garrett. She would like you to create a simple database application with two tables and two data-entry forms. This is a chiropractic office that wants to keep track of the different services and products it offers as well as patient insurance information. At the end of this case you will create two tables with various field properties and create an easy-to-use data-entry form for each table.
Skill Set
| Table Design | Form Design |
| Field properties | Command buttons |
| Lookup Wizard | Calculated fields |
| Validation rule | Page formatting |
| Validation text | |
| Input mask |
Background Dr. Garrett owns a small chiropractic office in Tucson, Arizona. Her office provides a variety of services including different types of adjustments, massages, and herbal products. She wants to keep track of all the services and products in the office and her patients' information. She would like you to design a database application to keep her information organized.
CASE ANALYSIS
Output Requirements
Dr. Garrett's chiropractic ...
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.
