IIHE Education, Microsoft Access
IIHE  |  Education  |  Class Curriculum |  Microsoft Access

During this session, you will learn how to use Microsoft Access to explore data culled from the Henry Ford Corporate Data Store:

Objectives of session:

1. Residents will continue to learn how to construct their own queries using Microsoft Access.
2. Residents will explore the resident database to characterize their patient populations and illness characteristics.

Outline

1. Review of Microsoft Access functions
2. Characterizing patient panels
3. Exploring health care utilization
4. Exercises

Computer lab exercise - using Access to analyze patient populations, clinic visits and hospital admissions

1. Using one of the "patient panel" files, describe the characteristics of that patient panel (age, sex distribution, type of insurance, etc.). Use several crosstab queries to do this.
    
2. Given the characteristics of the population described above, what are three health care priorities?
    
3. Select a practice site (visit table). How many visits were there for that site in 2001?
    
4. What were the top five diagnoses seen at that practice site?
    
5. Using the panel encounters table, select a practice site and a subset up the population (such as all pediatrics, geriatrics, males only, etc.). How many outpatient visits did this subset of patients have in 2001? Visually scanning the results, what were some of the common diagnoses?
    
6. Repeat the same exercise in 5 using emergency room encounters. What are your findings?
    
7. Select a diagnosis code of interest to you. Using the panel encounter table, identify all MRN's for people paneled to one of the sites with an encounter with that diagnosis and build a new table of these patients. (You will need to bring back distinct rows of data with MRN and some demographic characteristics in the results table (create a "Make table" query). How many patients do you have with this condition?
    
8. Using the table created in # 7, describe some of the characteristics of these patients. Link their MRN's to an admission table to determine if any experienced hospitalizations. Describe the nature of these admissions.
    
9. Using one of the admission files, what proportion of patients expired? Does the proportion differ for males and females? How about length of stay for patients who expired vs. those discharged alive? What else can you say about patients who expired?

Return to Curriculum Page