Question
Create a database in ms access that includes the following: What should my database do? Search patient record Add new patient record Update patient record
Create a database in ms access that includes the following:
What should my database do?
Search patient record
Add new patient record
Update patient record
Delete patient record
Save patient record
Print patient record
Get Dr info
Get prescription info
Get drug info
Patient visit list
Visit details
Form1: Patient
Search patient record
Add new patient record
Update patient record
Delete patient record
Save patient record
Print patient record
Form2: Visit Info
Attending Doctor
Patient no.
Patient name
Patient history
Diagnosis
What date
Form3: Prescription
Attending Doctor
Patient no.
Drug name
Prescription
Drug price
Prescription date
Form4: Dr Info
Name
Faculty id
Specialty
Degree
Contact
Address
Tables
Doctor details
Patient details
Prescription
Drug
Visit
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started