Students will be comparing deficiencies among multiple hospitals and analyzing t

by | Nov 26, 2021 | Other | 0 comments

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
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
Data Type
Field Size
Data Values
Data Source


Timely Delivery

All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. In case you cannot provide us with more time, a 100% refund is guaranteed.

Affordable Prices

Top Quality Papers

We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university, or professional, and we will assign a writer who has a respective degree.

24/7 Support

Our support agents are available 24/7 and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.

100% Plagiarism Free

Plagiarism is the biggest crime in the academic world. We have strict measures to ensure that all the essay papers are written from scratch to maintain originality and avoid plagiarism.

Professional Writers

We have hired a team of professional writers who provide expert essay help. Most of them are native speakers and PhD holders who are able to take care of any assignment you need help with.

We Protect Your Privacy

Anonymous Communication

We offer nameless communication between clients and writers. We value privacy on both sides.

Secure Payments

We do not collect or store any payment information. The order form is protected using SSL 256-bit encryption.

Personal Data Protection

Your personal information remains private and secure under our comprehensive privacy policy. We strictly follow the rules.

Why Us?

Exceptional quality, professional writers, secure and private, always on time. This is how our clients described their experience working with us. We value our clients above all and strive to uphold the high standards that we have set.

Quality is everything. We make sure that each completed paper that we send is an absolute masterpiece. It is well-written, thoroughly thought out, follows guidelines, has impeccable format and completely original. You can be confident that your paper is one-of-a-kind because we double-check it for plagiarism. Your instructor will be impressed when you turn in your paper.


Our Team has special quality assurance team guarantees that all the papers are plagiarism-free and meet the standards or specific requirements of certain academic institutions (these may vary, you know, and they may vary even between different teachers). Upon placing an order, you can communicate with your writer during the entire process and even after it is completed. This ensures a customized service, meeting the exact needs and expectations of any, even the most demanding customers.

Contact Us

Get Started