Course Hero Logo

HIT 194 Database Design Assignment.docx - HIT 194...

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 1 - 2 out of 12 pages.

HIT 194 Electronic Health Record and ApplicationsDatabase Design40 pointsDue in D2L Dropbox on November 14 at 11.59 pm.AHIMA Academic Curricular Competencies addressed by this case study:Domain III. Informatics, Analytics, and Data UseIII.1. Apply health informatics concepts to the management of health information. (Bloom’sLevel 3)III.2. Utilize technologies for health information management. (Bloom’s Level 3)III.6. DM Manage data within a database system. (Bloom’s Level 5)In this assignment you will create and enter data into tables, create forms, perform queries, anddesign reports using Microsoft Access.Assignment:1.Using a database program, create tables called “Patients,” “Clinical,” and “Doctors.” Usethe field definitions on the next pages.2.Create forms for each table.3.Change the name of the first patient from Evanston to your name.4.Your hospital marketing department is doing a mailing and wants a list of all patients inEvanston. Perform a query on the “Patient” table. Fields to include on your answer are:MedRecord#LastNameAddressCityStateZipCode5.Sort records by MedRecord# in ascending order.6.Create a report of your results of your query, using “Report Wizard.” Print the results inlandscape format. Print the results in landscape format.

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 12 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Fall
Professor
N/A
Tags
1966, 1968, 1962, 1989, 1988

Newly uploaded documents

Show More

Newly uploaded documents

Show More

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture