Question: Assignment: Create an entry level EHR system for a clinic. This is a group assignment. Requirements: Software: Microsoft Access 2010 Tables: Minimum Required Tables: o

 Assignment: Create an entry level EHR system for a clinic. This
is a group assignment. Requirements: Software: Microsoft Access 2010 Tables: Minimum Required

Assignment: Create an entry level EHR system for a clinic. This is a group assignment. Requirements: Software: Microsoft Access 2010 Tables: Minimum Required Tables: o Patient Table o Visit Table o Prescription Table Patient Education Table Make sure you create the appropriate relationships between these tables. Minimum Required Fields: Patient Table: Patient ID, First Name, Last Name, Social_Security_Number, Address, Birthdate, Insurance_Provider, Insurance_Policy_Number Visit Table: Visit ID, Patient ID, Visit_Date, Diagnosis_ ID, Visit Notes Prescription Table: Prescription_ID, Patient ID, Prescription_Date, Drug Name, Refills

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!