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
The post Database Project appeared first on learnedprofessors.
