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 2Analyze 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.

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...

1 answer below »

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.

suacc6311w3cpgarnert-aptlnpxh.xlsx suacc6311w3cpgarnert-qsrv4izn.docx suacc6311w4cpgarnert-kre5rbqe.zip suacc6311w3cpgarnert-3xw1pvos.zip

Answered 4 days After Apr 17, 2023

Solution

Amar Kumar answered on Apr 22 2023

36 Votes

SOLUTION.PDF

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...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment