Database

SharonM20

As a data steward, you have been asked to create a Microsoft Access database to store patient demographics. Once you have created the database, you must write policies to govern how the data should be collected, stored, and shared. Use search tools to help you write your policies.

Part-1: Create Your Access Database

Be sure to include the following demographic elements in your database:

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 3 patients for each element.

Part-2: Create Your Policy and Procedure Document

In a Microsoft Word document, create a Policy and Procedure document to govern the collection, storage, and sharing of data. For your convenience, a blank policy and procedure template is provided below.

Download: Policy and Procedure Template attached
Be sure proper APA formatting is followed and that your assignment is free of spelling and grammar errors.