• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  15. 15
    15
  16. 16
    16
  17. 17
    17
  18. 18
    18
  19. 19
    19
  20. 20
    20
  21. 21
    21
  22. 22
    22
  23. 23
    23
  24. 24
    24
  25. 25
    25
  26. 26
    26
  27. 27
    27
  28. 28
    28
  29. 29
    29
  30. 30
    30
  31. 31
    31
  32. 32
    32
  33. 33
    33
  34. 34
    34
  35. 35
    35
  36. 36
    36
  37. 37
    37
  38. 38
    38
  39. 39
    39
  40. 40
    40
  41. 41
    41
  42. 42
    42
  43. 43
    43
  44. 44
    44
  45. 45
    45
  46. 46
    46
  47. 47
    47
  48. 48
    48
  49. 49
    49
  50. 50
    50
  51. 51
    51
  52. 52
    52
  53. 53
    53
  54. 54
    54
  55. 55
    55
  56. 56
    56
  57. 57
    57
  58. 58
    58
  59. 59
    59
  60. 60
    60
  61. 61
    61
  62. 62
    62
  63. 63
    63
  64. 64
    64
  65. 65
    65
  66. 66
    66
  67. 67
    67
  68. 68
    68
  69. 69
    69
  70. 70
    70
  71. 71
    71
  72. 72
    72
  73. 73
    73
  74. 74
    74
  75. 75
    75
  76. 76
    76
  77. 77
    77
  78. 78
    78
  79. 79
    79
  80. 80
    80
  81. 81
    81
  82. 82
    82
  83. 83
    83
  84. 84
    84
  85. 85
    85
  86. 86
    86
  87. 87
    87
  88. 88
    88
  89. 89
    89
  • Level: GCSE
  • Subject: ICT
  • Word count: 8666

GCSE Database Project ICT

Extracts from this document...

Introduction

Checklist for Database Project ALL THESE MUST BE USED AS HEADINGS IN THE PROJECT Title Page Jack Jones, National Surgery of Dentistry for Any Purpose Project Using Microsoft Access 2008. Identify (5 marks) Identifying the user, Background Details The user will be the receptionist of the NSDAP who needs a way of making the system more efficient. The NSDAP was set up a few years ago and is a dental surgery with few patients. The user would like a way of arranging the patient's details easily as the number of patients is increasing rapidly. Currently the secretary is asking the new patients to fill in a hand written form, of which she copies onto another paper form. This form then is moved into a back storeroom, which is roughly kept in alphabetical order. When a patient wishes to book an appointment the receptionist gets the calendar, which has patient's appointments and views, which dates/times, are free. Once the patient has chosen a time, the secretary writes in the patients name for reference. On the day of the appointment, the secretary copies the calendar for the dentist or his assisting nurse, and then she finds the patient's information from the name off the calendar. These are kept in a box in time order, which the assisting nurse takes them in order and reads out the patient's names calling them to be seen by the Dentist. The dentist writes on the personal notes of the patient's record and writes a return date in the top left corner. The patient takes the record back to the secretary, who then asks the patient which time he/she would like to book on the allocated day, after which the date is scribbled out. After allocating the desk the secretary puts the file in another box and, at the end of the day, the secretary returns the patients card to the storeroom until the next appointment date. ...read more.

Middle

20/11/2007 Appointment Time Time 4 HH:MM Must Be Valid To A HH:MM (24 Hour) Format. 9.25 Appointment Details Text 250 (BLANK) You Have Exceeded 250 Character Please Abbreviate Details. To Receive Checkup Treatment Code Auto number 5 T0000 Incorrect Data. T5869 Relationships Patients Staff Patient ID PK 1-? Staff ID PK 1-? NHS No Title Gender Forename Date Of Birth Surname Patient Forename Job Title Patient Surname Qualifications Patient Address Emergency Telephone Number Patient Address Town Patient Postcode Staff ID ?-1 Height Weight Other Details Treatment Records Appointments Treatment ID PK 1-? Appointment ID PK Treatment Description Appointment Status Patient ID ?-1 Appointment Date Appointment Time Appointment Details Treatment ID ?-1 The above diagram shows the relationships of the tables, which spawns from the Staff Information Table as one Member of Staff, can have many patients, which in turn can have many appointments. The treatments can have more than one appointment attached to it, this enable the use of the same treatment on a different appointment. Form designs sketched in detail Menu NSDAP Menu Go To Patients Form Edit Patient Information Go To Staff Form Check Appointment Status Quit Check Kids Suitable For Brace The boxes in red are the buttons, which are featured in the initial design. Patient Information Patient Information Patient ID Title Patient Forename Patient Surname Patient Address 1 Patient Address 2 Town/City County Postcode Telephone Staff ID (Link) Table.Appointment Table At the bottom is the sub-form, which contains the appointments of the patient allocated. Staff Information Patient Information Staff ID Title Staff Forename Staff Surname Job Title Qualification Emergency Telephone Contact (Link) Table.Patient Table At the bottom is the patient table, it lists all the patients each member of staff has to deal with. Queries explained in detail Appointment Query Query 1 will be to search on the appointments table, under the appointment date and as I want to search for dates which are not stationary I shall use an algorithm that uses data from today's date ("Now()") ...read more.

Conclusion

This is fulfilled as the query contains two parameter values. The final quantitative objective runs well with no errors, as it is a simple value search query and brings the wanted results. A critical Comment on anything that you think could be improved The query results in objective 1 clearly does not work efficiently as it brings up previous appointments both completed and un-booked. The forms do not have the logo of the surgery, which is still to be generated. The interface the user uses is too large for the screen and the user has to constantly keep scrolling down to relevant data. User feedback in the form of a letter or questionnaire. Letter Enclosed After This Page. Jack Jones 44 Manor Road Walsall West Midlands WS2 9PU Friday, 24 April 2009 Dear Jack, I am writing this letter to thank you for your expert construction of the surgery's database. However, a few more additions would make the database as efficient as possible for the Surgery. Firstly, a friend of ours, who is also a sign writer, has offered to construct a sign with a logo, can you please insert the logo into the forms, to embellish the company within the database. In addition, have you found a way to correct the error with regards the 6-month reminder, as staff have found it slightly annoying to be sifting through all previous appointments. Those are the only additions I feel are necessary at this stage. Many Thanks in Advance, Dr. Jack Bate NSDAP Evidence that you understand the user's comments by making suggestions for future improvement The logo will be inputted in place of the system-generated image, the query will be rectified to only display the last result. A calendar will be inserted to enable the secretary to be able the receptionist to view all sections of the appointment field. All previous data entries (in terms of appointments) will be saved to a separate database labelled 'Archive'. ?? ?? ?? ?? Jack Jones 11W Centre Number 20297 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE ICT Systems and Application essays

  1. ICT Project - Statement of the Problem

    When a customer calls in to book a table the booker fills in the sheet, which include the customers name, telephone number, and what table they will be sitting at. After filling out this sheet the booker then goes on to putting the information in the bookings for the day book.

  2. Different types of technology How I use ICT at home and at school

    help them out with something they could've Googled in a few seconds. Remote assistance is thus a very useful tool as it lets me see or even control the problem with my eyes, thus helping them solve it much quicker and it works vice versa.

  1. Explain the difference between primary and secondary sources of data, with examples.

    In interviews you are able to understand how they really feel and can speak for themselves. Also interviews are able to get closer to their experiences. The information is not already known by the questions set, this means the interviewer can focus on specific information.

  2. ICT PROJECT

    * Ms Gammon wants the new system to automatically convert numerical marks to percentages. Storage * Ms Gammon wants the new system to be able to store 40 students' personal detail and also store results for up to 70 tests.

  1. GCSE Calculator Project

    You must first choose the event that you want the instructions to happen on. In this example I have chosen for the even to happen when the user clicks the button. Once I chose the event I have to write in the set of instructions I want to happen in VB.

  2. Health and Safety Issues in ICT

    For children with years of typing ahead of them, using the keyboard with index fingers only is highly risky. RSI is easier to prevent than cure. Interactive whiteboards If using an interactive whiteboard, make sure that children are supervised at all times during the projector's operation.

  1. This project is designed to help non-computerized library to easily keep track of their ...

    Expansion of the library is possible however; searching for particular item is very much time consuming and arduous. It is really exhausting to keep the files organized. * Replacing the system to a computerized one. This will help in keeping the file up-to-date, organized and will consume less time for the user.

  2. Computer study project outline - library and book club database.

    Whereas Search A book will also allow students and teachers to add their books so that they share their favorite books or some important books. If you see, whenever we want some good books to read or good book for reference we ask our friends or teachers and when they

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work