Clients:

Medical Database System

Website:

https://lndcreative.com

Skills:

Database

Project description

This is the database development of a MS Access database system for managing the appointment and prescription system of Medical System. The database provides the entity-relationship model, the data dictionary and  report layouts. Part of the requirements is building the tables, queries and forms.

ms-access-database-system

The produced database strictly follows the entity-relationship model and data dictionary given with no alterations, and contains 5 tables, 4 queries, 6 forms and 4 reports.

 

Tables:

  • DOCTOR
  • PATIENT
  • DRUG/TREATMENT
  • REPEAT PRESCRIPTION REVIEW DATE
  • APPOINTMENT,

all as described in the data dictionary.

Forms:

  • Main Form: a start-up main form that contains buttons to launch the other forms and reports;
  • DOCTOR form
  • PATIENT form
  • DRUG/TREATMENT form
  • REPEAT PRESCRIPTION REVIEW DATE form
  • APPOINTMENT form,

Each of them linked to its respective table.

Queries:

  • RepeatPrescriptionReview: a query that returns all prescription reviews along with patient data, irrespective of the current date.
  • RepeatPrescriptionReviewAsOfToday: a query that returns those prescription reviews along with patient data, conditional to current date and 7 days after.
  • ShowAppointments: a query that returns all appointments along with doctor and patient data, irrespective of the current date.
  • ShowAppointmentsAsOfToday: a query that returns those appointments along with doctor and patient data, conditional to current date and 7 days after.

Reports:

  • APPOINTMENT LIST report: shows all appointments, irrespective of past or future.
  • APPOINTMENT LIST FOR NEXT WEEK report: shows those appointments scheduled for next week (within 7 days as of today), grouped by doctor and sub-grouped by date.
  • REPEAT PRESCRIPTION REVIEW report: shows all repeat prescription review dates, along with patient and drug/treatment data, irrespective of past or future.
  • REPEAT PRESCRIPTION REVIEW FOR NEXT WEEK report: shows those prescription reviews scheduled for next week (within 7 days as of today), grouped by patient.

 

report-database