On-Campus Health is the infirmary located on the campus of the University of Denver. Recordkeep- ing at
Question:
On-Campus Health is the infirmary located on the campus of the University of Denver. Recordkeep- ing at the infirmary?s pharmacy, although meticulous and professional, is inefficient. Maintaining the recordkeeping using mostly manual systems is becoming more costly as additional people are hired to meet stricter industry regulations regarding the Health Insurance Portability and Account- ability Act (HIPAA) and because of state regulations that affect the sale, storage, and dispensing of prescription drugs. Although On-Campus Health succeeded in automating some of the data management for the pharmacy in an Excel spreadsheet, a more substantial change is needed to properly maintain and store data.
Students who use the infirmary can request prescriptions, either by presenting a written order from a doctor or by asking for a refill of an existing prescription. The pharmacist adds this request to the system by getting the required information to fill it, including information about the drug, the student?s name, the student?s health plan, and the prescribing doctor. Use the data that On-Campus Health has provided you in the file T6_CampusHealth_Data.xls to complete the following:
Create a Microsoft Access database.
Create the tables, fields, data types, primary key(s), and the like for the database.
Create the relationship(s) needed between the tables.
Populate the database with the data provided in the T6_CampusHealth_Data.xls file.
Expert Answer:
ANSWER Steps to Create the Access database Click the File tab Choose New Access displays a variety o... View the full answer
