Design of solution - In solution to the doctors surgery system that I am implementing, I will be using Microsoft Access.

Authors Avatar

Design of solution

In solution to the doctors surgery system that I am implementing, I will be using Microsoft Access.  After studying the alternatives I feel that Access is the best solution since it will allow me to make databases with relationships and queries unlike other alternatives like Excel, hence this choice.

This system will need to be based upon three tables-

  • Patients Details
  • Doctors Details
  • Appointment Details

My implementation will begin with the design of the database before considering data collection, data capture and the various outputs required.  On completion I will need to thoroughly test the system to ensure that it works as expected by using both valid and invalid data.  I will then write user documentation to allow the staff to use the system.

Below I will show the table design, firstly with the patients details table

Join now!

Doctors Table


Appointments table

In all of the key fields above LI stands for Long Integer

Data Entry

Data entry is the ways in which I will enter data into my systems.  This would firstly be inputted with the use of hardware such as an keyboard.  Such methods as OCR could be used; however these would in turn end up being too expensive.  Data would be put into my system therefore through the use of the tables displayed above.  For instance, when I want to include a new member I would simply use the ...

This is a preview of the whole essay