Question

please help me with this assignment

Assignment: Create an entry level EHR system for a clinic Requirements: Software Microsoft Access 2010 Tables Minimum Required Tables: Patient Table Visit Table 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, Generic_Allowed, Pharmacy Patient Education Table: Diagnosis_ID, Disease_Name, Education_Notes Notes: Your field names do not necessarily have to match mine but should be similar. Please do not use spaces in field names. Make sure you select the appropriate data type for each field Forms Minimum Required Forms Patient Info Visit Info Prescription Info Minimum Required Functions Must be able to search for a patient record by social security number or by last name Must be able to add, delete, and modify patient data, visit data, and prescription data Notes: I encourage you to add appropriate additional functionality. You may need to do additional research to determine what additional functionality would be appropriate (for example,

Answer 1

Answer)

Open MS Access 2010 then create a blank database then goto "Create" then "Table" then right click on table name then type the name of the table then design view then follow the screenshot I create the table.

Patient Field Name Data Type AutoNumber Patient_ID First_Name Тext Last_Name Text |Social_Security_Number Text Address Text Date/Time Birthdate Insurance_Provider Insurance_Policy_Number Text Тext Field Properties General Lookup Field Size 255 Format Input Mask Caption Default Value Validation Rule Validation Text Required Allow Zero Length Indexed No Yes No Unicode Compression Yes IME Mode No Control IME Sentence Mode None Smart Tags

Patient_Education Field Name Data Type Diagnosis_ID AutoNumber Disease_name Тext Education_Notes Тext Field Pro General Lookup Field Size Long Integer New Values Increment Format Caption Indexed Yes (No Duplicates) Smart Tags Text Align General

Prescription Visit Field Name Data Type AutoNumber Prescription_ID Patient_ID Number Date/Time Prescription_Date Drug_Name Тext Refills Text Generic_Allowed Pharmacy Тext Text Field Properties General Lookup Field Size Long Integer New Values Increment Format Caption Indexed Yes (No Duplicates) Smart Tags Text Align General

Visit Field Name Data Type Visit_ID AutoNumber Number Patient_ID Date/Time Visit_Date Number Diagnosis_ID Visit_Notes Text Field Properties General Lookup 255 Field Size Format Input Mask Caption Default Value Validation Rule Validation Text No Required Allow Zero Length Yes Indavad No.

After creating all the tables, goto "Database Tools" then "Relationships" then add the tables then drag the primary key field to foreign key field. Follow the screen shot.

Patient Prescription 1 Patient ID First Name Last Name Social Security _Nu Prescription_ID Patient_ID Prescription_Date Drug Name Address Refills Birthdate Generic Allowed Insurance Provider Dharmao Insurance Policy_N Visit Visit ID Patient_ID Visit Date Diagnosis_ID Patient_Education 1 Diagnosis_ID Disease_name Visit Notes Education_Notes 8

After creating the relationship, "Create" then "More Forms" then "Form Wizard" then select the field then next then Ok.

See the output of the form

Patient (New) Patient_ID First_Name Last_Name Social_Security_Number Address Birthdate Insurance_Provider Insurance_Policy_Numbe search the records 1 of 1 No Filter Record: Search

By this way you can add other forms also. Any doubt please comment me.