Download HHAdatabaseaccb open in Microsoft Access 2010 This

Download HHA_database.accb, open in Microsoft Access 2010. This file is a database derived from an Excel spreadsheet available at http://www.healthdata.gov. The database contains responses to the CMS survey of U.S. Home Health Agencies (both nationally and abroad) regarding their services. All U.S. HHAs are listed in the HHA_Providers and HHA_Services tables, while agencies represented in the HHA_surveys table are the only ones to offer complete response to the following questions:

HHA_Survey_Questions

ID

Field1

1

How often the home health team began their patients care in a timely manner

2

How often the home health team taught patients (or their family caregivers) about their drugs

3

How often the home health team checked patients risk of falling

4

How often the home health team checked patients for depression

5

How often the home health team determined whether patients received a flu shot for the current flu season

6

How often the home health team determined whether their patients received a pneumococcal vaccine (pneumonia shot)

7

How often the home health team checked patients for pain

8

How often the home health team treated their patients pain

9

How often the home health team took doctor-ordered action to prevent pressure sores (bed sores)

10

How often the home health team included treatments to prevent pressure sores (bed sores) in the plan of care

11

How often the home health team checked patients for the risk of developing pressure sores (bed sores)

12

How often patients got better at walking or moving around

13

How often patients got better at getting in and out of bed

14

How often patients got better at bathing

15

How often patients had less pain when moving around

16

How often patients breathing improved

17

How often patients got better at taking their drugs correctly by mouth

18

How often patients receiving home health care needed urgent, unplanned care in the ER without being admitted

19

How often home health patients had to be admitted to the hospital

Please note that questions 1-17 are interpreted as “positive” indicators, while questions 18 and 19 could be construed as negative “indicators”. Using only SQL statement(s), respond to the following questions, copy and paste the appropriate SQL code into this document to replace , and “copy/paste” the appropriate portions of your Query results (either entire results or subsection) from Access to replace (Note that several of these questions for this part could be addressed in Microsoft Excel readily; however this is an exercise to hone your SQL skills and begin to ask questions that can aid in healthcare operations. You do not need to write an individual complex SQL statement that addresses the question in a single attempt; rather, you may use sequential SQL statements, where appropriate to produce the necessary values, and then do the math yourself.):

Which zip code(s) have more than 100 HHAs?

Among the positive indicators, which question do HHAs reflect the best performance? the worst?

How many HHAs are there per state?

What state has the highest number of ‘State/County’ HHAs?

What is the average length of certification among HHAs in each state?(Hint: do not ignore # signs in DateDiff function and use 1/1/2013 as endpoint for certification)

HHA_Survey_Questions
ID	Field1
1	How often the home health team began their patients care in a timely manner
2	How often the home health team taught patients (or their family caregivers) about their drugs
3	How often the home health team checked patients risk of falling
4	How often the home health team checked patients for depression
5	How often the home health team determined whether patients received a flu shot for the current flu season
6	How often the home health team determined whether their patients received a pneumococcal vaccine (pneumonia shot)
7	How often the home health team checked patients for pain
8	How often the home health team treated their patients pain
9	How often the home health team took doctor-ordered action to prevent pressure sores (bed sores)
10	How often the home health team included treatments to prevent pressure sores (bed sores) in the plan of care
11	How often the home health team checked patients for the risk of developing pressure sores (bed sores)
12	How often patients got better at walking or moving around
13	How often patients got better at getting in and out of bed
14	How often patients got better at bathing
15	How often patients had less pain when moving around
16	How often patients breathing improved
17	How often patients got better at taking their drugs correctly by mouth
18	How often patients receiving home health care needed urgent, unplanned care in the ER without being admitted
19	How often home health patients had to be admitted to the hospital

Solution

s1) The best question is
How often patients got better at walking or moving around.
Because as they started walking and moving means the treatement and drugs are good.Which reflects
HHA the best performance.

The worst quest is HOw often patients got better at bathing.

------------------------------------------------------------------------------------------------------------

2) SELECT p.count(HHA),s.count(HHA) from HHA_service //gives total number of HHA in HHA_service table and HHA_PRoviders table
JOIN HHA_Providers
GROUPBY state;

----------------------------------------------------------------------------------------------------------------------------------

3)SELECT state FROM HHA_service
JOIN HHA_Providers
HAVING max(HHA)
GROUPBY state;

------------------------------------------------------------------------------------------------------------