Assignment: Database
Assignment: Database
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.
Permalink:
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.
Assignment: Database
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.
You must proofread your paper. But do not strictly rely on your computer’s spell-checker and grammar-checker; failure to do so indicates a lack of effort on your part and you can expect your grade to suffer accordingly. Papers with numerous misspelled words and grammatical mistakes will be penalized. Read over your paper – in silence and then aloud – before handing it in and make corrections as necessary. Often it is advantageous to have a friend proofread your paper for obvious errors. Handwritten corrections are preferable to uncorrected mistakes.
Use a standard 10 to 12 point (10 to 12 characters per inch) typeface. Smaller or compressed type and papers with small margins or single-spacing are hard to read. It is better to let your essay run over the recommended number of pages than to try to compress it into fewer pages.
Likewise, large type, large margins, large indentations, triple-spacing, increased leading (space between lines), increased kerning (space between letters), and any other such attempts at “padding” to increase the length of a paper are unacceptable, wasteful of trees, and will not fool your professor.
The paper must be neatly formatted, double-spaced with a one-inch margin on the top, bottom, and sides of each page. When submitting hard copy, be sure to use white paper and print out using dark ink. If it is hard to read your essay, it will also be hard to follow your argument.