Problem
Label the Sheet Tabs as Demographics, Clinical, Billing for 10 fictitious patients with the following information:
• Demographics: First Name, Last Name, Gender, Age, City, Zip Code, Phone
• Clinical: First Name, Last Name, Diagnosis, Medications, Visit Dates, Physician
• Billing: First Name, Last Name, Insurance Name, Insurance Type
• Label the 4th Tab as Answers.
After constructing the database by entering the required information in the respective sheets, answer the following questions:
A. What type of database is Excel (flat file, relational, network, hierarchical) and why you call it so?
B. Is MS Excel a single user or multiuser database?
C. How much data can be stored in MS Excel (Hint: # of workbooks x # of worksheets x # of cells in each sheet)
D. What Excel features would you use to locate the desired patient information?
E. How would you find information in the entire workbook (all sheets)?
F. Find information about 3 different patients using first or last name.
G. What information was available and in which sheet (demographics, clinical, billing)?
H. For what purposes can you use MS Excel in a healthcare facility?
I. What are benefits of using MS Excel as a database in a healthcare facility and what are its limitations?
J. Can you perform calculations in MS Excel and what types?