Part 1Using the InvoiceQuery you created in theACME Health Centerdatabase last week, create a report calledCustomerInvoicethat can be used as an invoice and handed to a customer.One important...

Part 1

• Using the InvoiceQuery you created in theACME Health Centerdatabase last week, create a report calledCustomerInvoicethat can be used as an invoice and handed to a customer.




• One important capability that we need to add to theACME Health Centerinformation system is the recording of payments received, both from the customer and insurance companies. Create a new table in your database calledPaymentsReceivedwith the following fields:patient number,procedure number,amount received, andpayer name. You will use this table to record payments received.




• Update the relationships between thePaymentsReceivedtable and other tables in theACME Health Centerdatabase.




• Create aPaymentsReceivedform for thePaymentsReceivedtable.




• Enter procedure order numbers for ten or more customers in thePaymentsReceivedtable. Record payments for at least eight of these customers.




• Create a report calledTotalPaymentsReceivedthat summarizes the total payments received for all patients.




• Create another report calledPaymentsPendingthat lists the patients who still have outstanding account balances.

Part 2

Analyze the risks and security needs for ACME Health Center. The following threats to the security of protected health information have been identified:



T1: A cleaning crew that arrives during the night might gain access to records left on desks.



T2: A cleaning crew that arrives during the night might gain access to records stored on computers.



T3: Claims are transmitted unencrypted across the Internet from the main office to a clearinghouse.



T4: There are no data backup systems or required data backup procedures.

Task:



Estimate the risk severity of the four threats, including possible remedial actions to mitigate the threats.

Part 3

Tasks:

• Summarize the capabilities of the ACME Health Center information system you have created during this course.




• Also explain what capabilities would need to be added to make this a complete system capable of generating financial statements (income and balance sheets).

Submission Guidelines:






Part 1:

• Save and zip your new Microsoft Access database file

Parts 2 and 3:

• Write your report in a 2 – 4 page Microsoft Word document using APA style.