• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

One of the administrative tasks in a hospital is to keep a record of the number of patients who loan out their equipment.

Extracts from this document...


1.0 Introduction One of the administrative tasks in a hospital is to keep a record of the number of patients who loan out their equipment. The patients may borrow equipment such as wheelchairs, crutches or even elbow collars depending on their injury. Some patients may still be in the hospital while others may be discharged. Records have to be kept of what is being borrowed, by whom, and when. It is also necessary to mention any equipment that is not available because it is being repaired. I have been asked to create a database to replace a manual one to record the necessary details and so that they can cut down on paper wastage and storage space. 2.0 Problems with Current System The current system to keep this sort of information is through lots of paper work and file organisation. Files of patients stored in the cabinets are manually stored and can cause misplacements of files. The records of patients and equipment all have to be searched through alphabetically (assuming these files are in alphabetical order) ...read more.


4.0 Data flow Diagram Patient Details Item Details Selected Patients Letters Reports 5.0 Constraints and Limitations The system developed is to be used by staff in the hospital. This is intended on replacing the old system. This could make the storage of information more in order and content. 5.1 Software Microsoft Access will be used to make this database. Microsoft Word will also be used in link with Microsoft Access to create word documents such as mail merge documents, which will be used to notify patients. 5.2 Hardware The computer used in the hospital needs to have a fast processing speed and a large hard disk. The speed is very useful when a lot of files are stored and the computer could slow down its search speed if it ahs to go through more files. The memory is required to store many lots of patients so that even previous patients have a file if accidently they return to the hospital they don't need to create a new file. ...read more.


I will have to decide on the fields I would need on the form, the way the data is to be viewed and the style of the form. Creating Queries A query is a question, for example "how many patients are borrowing equipment?" I will create several queries because there may be a lot of questions asked and to answer them in one simple way would make it easier for the user to find. For example to see what equipment is in stock, instead of checking each item the computer can find out for you by going through each item and finding it out in a matter of seconds. Creating Reports A report can be used to display a table or query in an appealing way, for example a report may be used to print out a full report on the location of all equipment, when it is due for return or renewal and that the patient should be contacted. I will also use mail merge for the letters of contacting patients to notify them of returning of renewing their equipment on loan. Section 1 - Investigation ...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. System administration report

    Check back up log file to see if backup runs okay. If okay, proceed, if not then investigate and re-run back up if required. 7.20 am Label and back up tape with date and time and insert new backup tape. 7.30 am Change backup scheduler dates to run backup tonight.

  2. Analysis of Whipps Cross Hospital

    Tables: I am going to have two tables first table to get the details about the staff of Whipps Cross Hospital and the second table for the patients in Whipps cross hospital. For each table I will have different columns in which I will have suitable fields for instance for

  1. Benefits and drawback for patients and staff of using a database system

    You can use the website anytime of the day. Also you can book appointment over the internet without leaving the comfort of your home to go outside for an appointment also you can find out where the dentist is on the online map.

  2. Creating a system - I will be solving a number of problems about the ...

    Name: Position in company: Department function What are your aims and objectives for the current system? What documents/reports will you need to be produced using the gathered data? How does the current system work? Are there any security issues with the current system?

  1. A2 ICT, Task 3 - St. Anthony’s Hospital

    As St. Anthony's is a private hospital, it has a lot of dealing with insurance companies and with government agencies but also with the National Health Service (NHS). All this administration and transfer of data brings about a number of issues for the system.

  2. I. C. T. - creating a record system.

    Mock examination results. 2. Class results. 3. Exam Results/Expected results. ANALYSE: It appeared to be that they already had a record system; therefore they had a few programs that may benefit me. The most suitable package I found is Microsoft Excel.

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