Make a relationship diagram showing tables

Assignment Help Computer Engineering

Reference no: EM133703864

Data Reporting
Please assist with the step by step process and how to properly illustrate the following and provide illustration for better visual understanding.

Part I Data Relationship Model

Use the Microsoft Access Database Tools to make a Relationship diagram showing tables VisitReason and Payer and the relationship between them.

Screen shot #1: Insert a screen shot of the Relationship diagram here for proper illustration

Part II Visit Reason Report

Use the Report Wizard to make a simple report showing these fields from the VisitReason table in this order: VisitPayerID, VisitReason, VisitDate,. The report should be grouped by VisitReason with a Layout type of Blocked.

Screen shot #2: Insert a screen shot of the Visit Reason report here for proper illustration

Part III Payer Mix Report

Payer mix refers to the payer entities that reimburse a facility for services. Examples of payers include Medicare, Medicaid, and Managed care, self-pay and Private Insurance (provided through employer-sponsored benefits plans like BCBS and Aetna). Each payer has a different set of payment characteristics. Facilities spend a lot of time managing the payer mix in order to increase reimbursement by reducing the time between billing and payment.

Make a Report with Fields in this order: PayerClass, PayerCharges, PercentTotCharges, PercentTotPayments, PercentAR and VisitReason.
Be sure to select View data by Payer in the Report Wizard.
To get full credit you may wish to use the design view and resize the labels so that all the text for the report headers is visible (e.g PercentTotCharges, etc.).

Reference no: EM133703864

Questions Cloud

Using wordart can be an effective addition to a document : Using WordArt can be an effective addition to a document. However, where does the balance lie between using and overusing WordArt?

Types of shock and management required : This is the first of two discussion boards that you will participate in that explore various types of shock and the management required.

Which includes the scope and design : which includes the scope and design. Both the code and documentations need to continue throughout the course and show progressive building of enhancements

Describe one in-classactive learning exercise : Describe one in-classactive learning exercise OR demonstration that you would give to the hypothetical class listening to your lecture.

Make a relationship diagram showing tables : Make a Relationship diagram showing tables VisitReason and Payer and the relationship between them

What issues did president obama face in his first term : What issues did President Obama face in his first term? What was the Republican strategy? What was the Grand Bargain, and why did it fail? Who was to blame?

Define prediabetes : Define prediabetes, its risk factors, and the importance of early intervention in primary care settings.

Which step should you attempt first to resolve the problem : If every user connected to your network is reporting very slow speeds and poor connectivity, which step should you attempt first to resolve the problem

What do they enter on the command line : What do they enter on the command line? 1 point chmod g+x projects chmod x+x projects chmod u-x projects chmod g-x projects

User Account

All Pages