When I visited my local dental surgery Essays

When I visited my local dental surgery Essays When I visited my local dental surgery Essay When I visited my local dental surgery Essay CD-ROM Drive * 56K Modem * 3.5 Floppy Disk Drive * Keyboard , Mouse 3 years parts and labour return to manufacturer. Supplied with original Microsoft XP installation CD and all drivers for Windows 95/98/ME/2000 and XP Price: à ¯Ã‚ ¿Ã‚ ½ 475 including VAT Laptop Supplier: thelaptopsite.com Reference LAP03-829021 Manufacturer Hewlett Packard Model Evo NX9005 Processor AMD Athlon 2000 Memory 256mb HDD 30gb FDD 1.44 FDD CDROM/DVD DVD/CDRW Operating System Windows XP Professional Display 14.1 tft Condition New Manufacturers Warranty Price: à ¯Ã‚ ¿Ã‚ ½ 799 including VAT I have decided to recommend a desktop tower computer rather then a lap top because: Desktop comes with a larger screen size, it can be placed on the floor under the desk and out of sight; it is much cheaper then a similar spec laptop. The price of the desktop recommended will be approximately à ¯Ã‚ ¿Ã‚ ½1200. DESIGN All forms will be designed in this style. This will ensure everything looks similar for the user. Item Text details Text Position Colour Background Main Heading Font:20:Italic:Bold Centered Blue Form colour Labels Font: 14: Bold Left aligned Black Form colour Buttons Font:12:Bold Centre Black grey Forms N/A N/A N/A Dark Cyan background Compulsory data Font:12: Left Black Light orange Optional data Font:12 Left Black Light green Diagram showing the major components of the inputs and outputs User FORMS Design: Query1. Purpose: View patients belonging to a specified surgeon. Input: Surgeon name Process: Query database to look all patients against name given. Output: shows gender, forename, surname, contact numbers for all patients found. Query 2. View patient details. Input: Patient forename and surname Process: Query database to look for all patients against forename and surname. Output: Show full record details about the patient Pressing new patient Button brings up this form Database design New patient record Field Name Type Length Required Indexed Validation Duplicates Record ID Auto Number Primary key Yes No No No Medical No text 20 chars Yes No No No Gender text 1 char Yes No M/F Yes Forename text 20chars Yes No Type Check (cap first letter) Yes Surname text 20 char Yes Yes Type Check (cap first letter) Yes House No text 10 char Yes No No Yes Address1 text 50 chars Yes No Type Check (cap first letter) Yes Address2 text 20 char Yes No Type Check (cap first letter) Yes Address3 text 20 char Yes No Type Check (cap first letter) Yes Address 4 text 20 char Yes No Type Check (cap first letter) Yes Post code text 9 char Yes No Type Check (ccnn ccnn) yes Day time No text 12 char Yes No Character check Yes Mobile No text 12 char Yes No Character Check Yes DOB Date 10 char Yes No Type Check Yes Last appointment Date 10 char Yes No Type Check Yes Expiry date date 10 Char Yes No Type Check Yes Reminder status Text 1 char Yes No Y/N Yes Payment status Text 10 chars Yes No Paid, Defer, Free Yes Amount due Currency Integer No Yes Type Check Yes Surgeons table Field Name Type Length Required Indexed Validation Duplicates Surgeon ID Auto Number Primary key Yes No N/A No Title Text 4 char Yes No Dr, Mr, Mrs, Miss Yes Forename Text 20 Char Yes No Type Check (cap first letter) Yes Surname Text 20 Char Yes Yes Type Check (cap first letter) Yes Address1 Text 50 Char Yes No Type Check (cap first letter) Yes Address2 Text 20 Char Yes No Type Check (cap first letter) Yes Address3 Text 20 Char Yes No Type Check (cap first letter) Yes Address4 Text 20 Char Yes No Type Check (cap first letter) Yes Post Code Text 9 Char Yes No Type Check (ccnn ccnn) Yes Home No Text 12 char Yes No Character Check Yes Mob No Text 12 char Yes No Character Check Yes Surgery Table Field Name Type Length Required Indexed Validation Duplicates Patient ID Number Long Integer Yes Yes field key No Surgeon ID Number Long Integer Yes Yes field key No Diagram showing how the tables are linked together by key fields. Appendix A Questions for the interview 1. When patients joins the clinic what information do you record.? 2. When patient makes an appointment what information do you take down? 3. When patient arrives for his treatment, how do you note who is waiting for which surgeon? 4. When a person needs a follow-up appointment what do you record? 5. What additional tasks do you perform for a follow-up appointment? 6. How do you record information about patient payments of treatment? 7. What difficulties do you experience when you become very busy? 8. What happens to patients that you cannot deal with? 9. How do you track patients for different surgeons? 10. How many people are there working at the surgery? 11. How do you know how much to charge for different treatments? 12. Do patients cancel appoints? 13. What happens when they do this? Appendix B Answers given at interview A.1 When a new patients comes to register with us, we know the number of new patients that each surgeon will take. If they can take on new patients, then, we ask them to fill in a form about their medical details otherwise we refer them to another dental surgery. We then check the form and ask them to sign their declaration. We ask for their medical card and record the number as well as their names and address details. We also ask for details about their family members and their details. A.2 We take down their first name and surname and record it in our appointment planner against the surgeons name and time of appointment. The planner allows us to make appointments every 15 mins. A3. Yes, when a patient arrives, they usually say the time of their appointment and their name. We write a tick against their name, which indicates they are wait in reception. A4. We do the same as we did before as if the patient is making a new appointment but we know their name and surgeons name so simply agree on suitable time? A5. When we agree on the appointment time and day, we fill in a appoint card with the date and time details and hand it to the patient. We also ask about them to see if they wish to pay today or pay for everything at the end of the treatment. Most patients prefer to pay as treatment is being carried out. Some do decide they will pay the total amount at the end. We also have patients that dont have to pay if they are on job seeker allowance or social security benefit. A6. We make a note on the treatment card, if they have paid or deferred payment or no charge. If they pay we write out a receipt for them. A7. I find it very frustrating when we have people making queries and we have to wait for the appointment planner to be freed up before we can deal with the patient. We sometimes spend time looking for patient sheets in the filing cabinet which one of us has not filed and may be lying on the desk. Sometimes we dont get the treatment sheet and have to ask the dental nurse to look for it the surgeons treatment room and the customer is kept waiting. A8. The dental surgeon refers the patient to the specialist clinic. This involves writing to the clinic and requesting an appointment. It can three to four weeks for the appointment to come. A9. We file each patient records in different filing cabinet and on the planner we write down the name of the surgeon so that his patients are under his named column. A10. There are the three surgeons, three medical nurse and two of us at reception. A11. We have a list of treatments and prices against them. The surgeon writes down what treatment he has carried out and calculates the total. A12/13. Yes, quite often, all we do is put a diagonal line across it and make a new appointment. If they cancel before 48 hours, we do not charge them, otherwise we charge them à ¯Ã‚ ¿Ã‚ ½20. Appendix C Notes taken during observation Observing the surgeon: Receptionist takes the notes from the filing cabinet and passes it to the nurse. The surgeon checks his last notes. The nurse calls the patient in. The treatment is carried out and the surgeon writes, the treatment he carried out and indicates if follow-up appointment is needed, he makes a brief notes about what he needs to do next time. The patient leaves the treatment room and the nurse returns the patient file to the receptionist desk. The next patient is the called in. Observing the Dental Nurse: Dental nurses are only involved in fetching and returning the patients records to and from the surgeon and assisting the surgeon. They do not write anything on the patients notes. Observing the Receptionist: Confirmed what the receptionist said she did with customer handling process. All information given during the interview was correct. Also observed the time wasted when the clinic becomes busy and how frustrated they become having to share a single appointment planner. The times they take to write out the receipt and appointment card is quite effective, but it takes a lower priority to ensuring surgeons receives the patients records and are not waiting. This means keeping the customer waiting longer then is necessary. Customer are frequently kept waiting as they try to pay for treatment or make follow-up appointments. New people arriving are given higher priority.