skip to Main Content

FILL OUT ORDER NOW FORM

MAKE A PAYMENT

WRITER BEGINS WORKING ON ORDER

QUALITY CONTROL CHECK

DOWNLOAD COMPLETED ORDER

Students will be comparing deficiencies among multiple hospitals and analyzing t

Place your order now for a similar assignment and have exceptional work written by our team of experts, At affordable rates

For This or a Similar Paper Click To Order Now

Students will be comparing deficiencies among multiple hospitals and analyzing the data via a database program. Data will be presented in MS Access for manipulation into an Access Report which will then require final screenshot submission via a Word Document. Students will then create a Data Dictionary for all columns as identified for the report created in Activity #1. The data dictionary must be submitted via an Excel Spreadsheet. Identity 2 Hospitals to compare with 6 or more deficiencies
Instructions
MS Access Steps:
Open database in MS Access
Create new query using Query Design tool.
Add Providers and Provider Deficiencies tables to the query.
Add fields to query:
From Providers table: Federal Provider Number, Provider Name, Provider State
From Provider Deficiencies table: Provider Deficiency ID
Click Totals to change to an aggregate query
Under Provider Deficiencies ID
Change the Total setting to Count
Change Sort to Ascending
For Criteria, enter >= 6
Run the query.
Save the query as Provider Deficiency Counts.
Capture a screen shot of the first few rows of the query results and paste into a Word document.
Select 2 hospitals from this list that you want to compare. Capture a screenshot including their Federal Provider IDs, Provider Names, Provider States and deficiency counts and then insert screenshot into a WORD document.
(Be sure your screenshot shows a minimum of 6 deficiencies per hospital) Develop a data dictionary for all columns from your report in Activity 1 in EXCEL. Your Data Dictionary must include the following data elements:
Data field
Name
Definition
Data Type
Format
Field Size
Data Values
Data Source
WILL INCLUDE SPREDSHEET FOR PART 1

For This or a Similar Paper Click To Order Now

WHAT'S INCLUDED IN OUR ESSAY WRITING SERVICES

300 WORDS PER PAGE

To give you the best value for your money, we use a standard 300 words per page – up to 50 more words per page than other essay writing companies!

PLAGIARISM-FREE

All of our assignments are originally produced, unique, and free of plagiarism. All assignments go through plagiarism-detection software tools via a secure website before they’re sent to you.

FREE REVISIONS POLICY

If you want any changes made, it’s not a problem! Our comprehensive free revisions policy allows you to request a revision within (5) days at no extra charge.

24/7 SUPPORT

We have a team of friendly, helpful customer support staff who work around the clock, and are available to answer your questions or concerns 24/7, day or night.

Customer Testimonials