I have designed a system to be used in a medical centre. The medical centre at the moment uses a paper based system to store all its patients’ details. The system is not able to cope with a dramatic increase of patients so will then require a computerised system to cope with the increase. The increase is due to a home estate being built in the village which will increase patient numbers. The system consists of some basic functions which are-* The patient details – Which will include things such as the name, address, date of birth, telephone number and primary doctor.* The staff details – this will include information such as staff code, name, address, phone number and also their role.* The treatment details – this will include information such as patient ID, the date visited to the surgery, staff code and also the treatment which was received.I have included a few extra features to make processing information quicker such as-* When a name or number of patient is given, the patient’s details will be bought up and also allows updates of their details.* The system will print details of patients who have this doctor as primary doctor.* Insert details of the new patients; delete existing patients.* Insert staff details.By making this modification the system is able to store much more information than a paper based system. The system has been extended with the extra features as a basic system will just store patient details. I have built the system so that it is easy to navigate through for the user. I have used the forms in Microsoft access to produce the navigation forms.Set of major screen shots and reportsIn this section I will show all the major screen shots of the main screens which are used in the system. I will also show the reports which I have required in the system such as the details of patients with a particular primary doctor and the patients who have been prescribed different medication by particular doctors.Main screen- this is the main screen used when the system is on stand by and not in use.Main menu- This is the main menu where all the functions can be accessed from.Patient details- this screen is where all the patient details can be added,edited and deleted.Staff details- from this screen all the staff details can be added, edited and deleted. The patient details form can also be accessed from this form. The ‘find staffs patients’ button will bring up the details of all the patients that are cared for by a particular doctor.Prescriptions- this form allows the user to input the name of the prescription which the patient is given.Treatment details- on this form the user inputs the details of the patient’s treatment which was received. A link is also provided if a prescription for medication is required.Appointments- this screen allows the user to book and appointment for the patient when they require it. A date and time is entered and also a printout is available for a copy to be given to the patient.This is one of the reports which I have included in the system. The report shows all the doctors with the patients which they care for.This is another report which shows the prescription details of patients. The report shows the different prescriptions given to patients and by different staff.Shots of sections of code from SQL.I have used SQL (structured query language) code to produce queries for the system. The queries I have produced are linked with the tables and also the requirements of the user. The user does not require many queries except the query to find all patients which are allocated to a particular doctor when a doctors Id is entered and when a patient number is entered the system will find the patients details.A) This is the query where when a patients ID is inserted then their details will be displayed. Patient details query in design view.This is the SQL for this patient details query.b) This query shows all the patients that a particular member of staff is in charge of. It shows all the patients who have a particular doctor as their primary doctor. staff details query in design view.This is the SQL view for the staff details query.Test logI will be testing the system to make sure the desired output is met. I will use test data to test my system and along side I will state the expected result I expect to gain and the actual result.Test Plan/Log for medical recordsForm : Main MenuTest DataOutcome1, From main screen click “patient form” Command button (Does it open correct form?)The patient form will open up and I am able to add, edit and delete a patient.1, From main screen click “prescriptions form” Command button (Does it open correct form?)When the booking form is clicked the form opens for a patient.1, From main screen click “staff details form” Command button (Does it open correct form?)This form opens a new screen with the staff details and then other sub-command buttons will let you add, edit and delete details.1, From main screen click “patient details” Command button (Does it open correct form?)This opens all the patients’ details but with a query a specific patient can be found.1, From main screen click “Exit” Command button (Does it Exit the system?)Exit returns you to the main page where all the different command buttons are available.Test Plan/Log for medical recordspatient details formTest DataOutcomeSelect the Name field enter characters which is longer then 15 characters.A name longer than 15 characters cannot be entered.Select the Surname field enter characters which is longer then 15 characters.A surname longer than 15 characters cannot be entered.In “Telephone no” field enter a large number such as 0112233445512 and record the results.A phone number of up to 12 digits can be entered.In “Telephone no” field enter a combination of numbers and letters such as 44gts906jk and record results.When letters are filled into the telephone number field the number is not accepted.In “patient number” field, check for input mask. E.g. E00001. Enter 564631 and record resultsThe number is not accepted due to auto number. A patient will be given a number automatically when they join the surgery.In “patient_ID” check for input mask is I_____.When a patients ID is inputted into the system all their details show up.In “patient_ID” field enter a combination of numbers and letters such as 88gfsdf34 and record the results.When a combination is inputted into the system the system does not accept it.On “Add patient” command button. Does it create new record?A new patient form will show up to add a new patient otothe record.Click the “Exit” Command button on the main page. Does it close the “main page” ?The system will return to the main page.Test Plan/Log for medical records.Staff formTest DataOutcomeFrom main screen click “staff form” Command button (Does it open correct form?)The staff form should open.On Booking form check navigation buttons (Previous) Does this take you back to the first record?The navigation button should you to the previous page.In “Telephone” field enter text value, check for validation E.g. Enter HelloAnd record the results. In the membership formThe text should not work as it is a number fiend.In “Telephone no” field enter a large number such as 73948723423 and record the results.Only an 11digit phone number will be able to be entered.In “Employee number” field, check for input mask. E.g. E00001. Enter 564631 and record resultsEmployee numbers will be auto number so when ever an employee is entered they will be assigned a number automatically.Click on “Add New Employee” command button. Does it create new record?A form to add a new employee should open up.Click the “Exit” Command button on the main page. Does it close the “main page” ?The user should return to the main page where al the options are to navigate the system.Test Plan/Log for appointmentTest DataOutcomeFrom main screen click “appointment” Command button (Does it open correct form?)The appointment form should open.On appointment check navigation buttons (back) Does this take you back to the first record?The back button should take the user back to the main screen.In “Telephone” field enter text value, check for validation E.g. Enter HelloAnd record the results. In the appointment formThe text should not work as it is a number fiendIn “Telephone no” field enter a large number such as 73948723423 and record the results.Only an 11digit phone number will be able to be enteredIn appointment details the date can be entered for the appointment and saved.The date should show up on the patient details as well as on appointment details.In “doctor” field enter a combination of numbers and letters such as 88gfsdf34 and record the results.This should not be accepted. when the patients ID is entered, their primary doctor ID should show up.Click the “Exit” Command button on the main page. Does it close the “main page” ?The user should return to the main page where all the options are to navigate the system.