• 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. ICT Sample Work Welcome Centre Requirements

    Chris is more of an advanced user, and can do all of the above to a more complex level, as well as use graphics and multi-media packages for design work. 6. What hardware and software do you have at The Welcome Centre?

  2. Computing Module 3 Writeup

    This produces a message box, which displays the error. The validate value starts off True. If any of the validation criterion are breached, then this validate value is made False and this value is taken up into CmdAddCen Public Sub and this stops the database from being updated, as it will only be updated if Validate=True.

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

    Be capable of manipulation by computer Drawing models is essentially an iterative process a model is produced, shown to the users then redrawn as many times as is necessary until the users are happy with it. Using a model that can be manipulated by computer cuts out the drudgery of

  2. ict implementation

    23 24 25 Implementation User interface To set up my new computer system I need to use a spreadsheet software package and so I choose to use Microsoft excel. I used this software as it is simple to use for setting up and provides the most commonly used spreadsheet package .

  1. Smart Card System

    Otherwise, the end node transmits the Idle_Up control signal. 1. The repeater polls all local ports to determine which end nodes are requesting to send a data packet and at what priority level that request is (normal or high). 2.

  2. Flexible Architectures in Communication Security Application

    Our first approach is to add instruction set support for fast substitutions, general permutations, rotates, and modular arithmetic. Performance analysis of the optimized ciphers shows an overall speedup of 59% over a baseline machine with rotate instructions and 74% speedup over a baseline without rotates.

  1. Creating a computer system for Wooten Basset Rugby Club

    Invitation letter to other clubs inviting them to a match. * Player and parent data. Store contact details about players and parents. * Statistics. Store statistics on players including points scored, tries and appearances. * Team information. Store details on rival teams such as contact details.

  2. Computer Aided Design Package

    The system that I have been asked to come up with will have two users; these two users are currently working with Engineering ? Us and they will need to be trained in using the new system as they have not had any training or experience with any CAD application.

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