Explains the importance of data warehouse architecture and how it is used for analysis and reporting.

Data Management

Overview 1 page access + 1 page APA word

As a data steward, you have been asked to create a Microsoft Access database to store patient demographics. After completing the database, you will need to create a procedure document or presentation to train other employees on how data should be collected, stored, and shared.

Instructions

1-Part One – Create Database

Create a Microsoft Access database that includes the following demographic elements:

Patient First Name

Patient Last Name

Patient Middle Initial

Street Address

State

Zip Code

Phone number

Social Security Number

Birthdate

Gender

Emergency Contact Name

Emergency Contact Number

Primary Physician

Once you have created the database with the patient demographic elements, provide fictitious information for three patients for each database element.

2-Part Two – Data Management Procedures

Develop a one page document for data management procedures that:

Explains the importance of data warehouse architecture and how it is used for analysis and reporting.

Illustrates data mining processes to extract meaningful data.

Describes two recommendations with an example for implementing the recommendation for collecting, storing, and/or sharing data.