• 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

The Phoenix Hospital has asked me to create a computer application to replace the existing manual one. In this system patient details have to be kept and information about borrowing of equipment.

Extracts from this document...

Introduction

Write up for Hospital Equipment Loan System Specification Background The Phoenix Hospital has asked me to create a computer application to replace the existing manual one. In this system patient details have to be kept and information about borrowing of equipment. Records must be kept of what equipment has been borrowed, by whom and when, and also if any equipment is not available because it is being repaired. Aim My aim is to successfully create a database for the hospital, which they can4 use on an everyday basis. The database will need to: > Ability to store details of equipment. > Item code to identify the item and the type of equipment. > For each piece of equipment it must find: - whether it is available, being repaired or out on loan - if on loan, to whom and at what address or ward number - if on loan, when is it due to be returned or the loan renewed - if being repaired, when was it sent for repair > Produce a hard copy of the above information for any piece of equipment. ...read more.

Middle

code Text 4 - - Type Text 50 - - Price Currency - - - Figure 2 Equipment Details Record Structure Stock Table Field Name Data Type Field Length/ Format Validation Rule Input Mask Item ID Text 4 - - Equipment ID Text 3 - - Location Text 10 - - Repair Table Field Name Data Type Field Length/ Format Validation Rule Input Mask Repair ID Text 50 - - Date of repair Date/Time - - 99/99/00;0;_ Estimate days Text 50 - - Item ID Text 50 - - Figure 4 Repair Table Record Structure Loan Table Field Name Data Type Field Length/ Format Validation Rule Input Mask Loan ID AutoNumber Long Integer - - Patient ID Number Long Integer - - Date Loaned Date/Time - - 99/99/00;0;_ Figure 5 Loan Table Record Structure Sub Loan Table Field Name Data Type Field Length/ Format Validation Rule Input Mask Sub Loan ID AutoNumber Long Integer - - Loan ID Number Long Integer - - Item ID Text 50 - - Returned Yes/No - - - Figure ...read more.

Conclusion

Query Design View Figure 22.2 Available Query Datasheet View Location Query Figure 23.1 Location Query Design View Figure 23.2 Location Query Datasheet View Update Location Query Update Repair Query Figure 25.1 Update Repair Query Design View Figure 25.2 Update Repair Query Run Update Stock Query Figure 26.1 Update Stock Query Design View Figure 26.2 Update Stock Query Run Forms Figure 27 Patient Form Welcome Screen Form Equipment Details Form Figure 29 Equipment Details Form Repair Form Reports Locations Report Figure 31 Locations Report Design View Equipment on Loan at End of Week Figure 33 Equipment on Loan at End of Week Design View Figure 34 Equipment on Loan at End of Week Datasheet View Letter to patients mail merge template Letter to patients Figure 36 Letter to patient mail merge Testing Validation of gender Validation of Ward Numbers Invalid value for date field Figure 39 Invalid value for date field Inappropriate value for input mask By Leo Kadis .Candidate Name: Leo Kadis Candidate Number: 6677 Module 3 Hospital Equipment Loan System Page 1 of 25 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Computer Science 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 AS and A Level Computer Science essays

  1. Flexible Architectures in Communication Security Application

    We present analysis of a 0.25um physical design that runs the standard Rijndael cipher algorithm 2.25 times faster than a 600MHz Alpha 21264 processor. Moreover, our implementation requires 1/100th the area and power in the same technology. We demonstrate that the performance of our design rivals a state-of-the-art dedicated hardware implementation of the 3DES (triple DES)

  2. Computer Aided Design Package

    that when an update is released for any of the software running on the computer they can then go to that company's website and find the file then download and install it. The web browser may also be used for more than just viewing websites, some of the applications may

  1. ICT Sample Work Welcome Centre Requirements

    He is a complete novice at using computers. He will need introductory training that includes: * Logging in to the network * File Management (files and folders - creating, renaming, moving, copying) * Word Processing (Use of word documents, file management - opening/ saving, formatting) * Spreadsheets (Use of spreadsheets, file management - opening/ saving, formatting, working with multiple worksheets)

  2. Computing Module 3 Writeup

    Validate = False Exit Function End If If txtCentreNo.Text > 79999 Then MsgBox ("Centre number must be between 10000 and 79999") Validate = False Exit Function End If If (txtExaminerNo.Text = "") Then MsgBox ("Examiner number has to be entered")

  1. You have been asked to create a database to handle various account combinations of ...

    It is therefore necessary to capture the essence of the business and model around those core concepts to be able to handle changes properly. Be consistent with other models in the system Different models of the same system can be integrated or cross checked against each other for consistency.

  2. ict implementation

    and the homepage worksheet will open (2) (1)Homepage button (2) as you can see below the homepage opens once the homage navigation button has been clicked Test number 8 The user clicks on the worksheet button "invoice " (1)as shown below and the following will show(2)

  1. Smart Card System

    Each TCP packet contains the starting sequence number of the data in that packet, and the sequence number (called the acknowledgment number) of the last byte received from the remote peer. With this information, a sliding-window protocol is implemented. Forward and reverse sequence numbers are completely independent, and each TCP

  2. Creating a computer system for Wooten Basset Rugby Club

    Store details on rival teams such as contact details. * Fixtures. Store fixture information including scores, dates and venues. * Ability to see reports on players from the club. * An ability to track membership payments. The system must indicate whether a players has paid his membership for that season.

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