Two page word document and one Access data base.
ACME Health Center is a day-surgery center used by a group practice in a small community. The center performs minor surgeries and needs to order supplies from medical equipment companies and drug companies.
Sometime prior to scheduled surgeries, new patients complete an information form with their name, address, phone number, e-mail address, and insurance company’s name. Office staff then feeds the patient’s information to the computer system and schedules the surgery. On the day of surgery, the patient arrives and checks in at the front desk.
The surgery is then performed, and when the patient checks out, an invoice is prepared for him or her. The patient can either pay at that time or be billed and pay later. Your job is to create an AIS to handle this entire process.
Tasks:
This unit, you will do the following:
Analyze documentation of the business and information processes within the ACME Health Center with either a Flowchart or Data Flow Diagram. This can be a high-level flow of information through the company and between outside entities with which the company will interact, such as the drug vendors and the patients. Describe your diagrams or charts with a narrative and indicate what processes and systems would most likely use a relational database to store data.
Justify all database tables (data stores) you think would be required for the operation of this AIS (patient information table, invoice table, etc.)
Integrate a sample patient table in a Microsoft Excel workbook, with information about twenty patients. Use the fields specified above in the scenario. Name it PatientList.xls.
Using Microsoft Access, complete the following tasks:
Create a Microsoft Access Database.
Import the patient workbook you created in step 3 into a table in your Access database you name PatientList. Download ProcedureList.xls and MedicalDevices.xls and import them into tables in your Access database you name ProcedureList and MedicalDevices, respectively. To import the workbooks into the database, select the Access External Data tab and click Import.
When importing the workbook, let Access add primary keys to your tables. Again, the names of your the three Access tables should be PatientList, ProcedureList, and MedicalDevices. Also, when you are importing the workbooks, be sure to specify that their first row contains the field names. Name the primary key of the ProcedureList table procedure number.
Save your Access database file and zip (compress) it,
Submission Guidelines:
Create a 2- to 3-page report in a Microsoft Word document by combining the content for steps 1 and 2.
Using the APA format, cite any sources on a separate page.
Submit your zipped Access database and Word document to the Submissions Area by the due date assigned .
