• 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. Peer reviewed

    Principles of Computer Networks

    3 star(s)

    IEEE 802.3 This standard defines the MAC layer for bus network using CSMA/CD. It is considered as a LAN technology and uses very few WAN applications. Connections between node and infrastructure are made using various fibre cable connecting switches and hubs together.

  2. ICT Sample Work Welcome Centre Requirements

    of Delegates, No. of Servings and Qty fields will be numbers, food option will be a drop down box GENERAL INFORMATION Catering Table. Fields to be input: Food Price per Delegate Equipment Table Fields to be input: Equipment Price per 1/2 Day Room Table Fields to be input: Max.

  1. Smart Card System

    The chips are standard micro controller card chips, with masked-in software for the cryptographic authentication algorithms. * Signature-transporting cards - In this card, it store stores publicly verifiable digital signatures created by the system provider and fills them in like blank checks when spending them.

  2. Computing Module 3 Writeup

    Validate = False Exit Function End If If (txtCandidatesEntered.Text = "") Then MsgBox ("Number of candidates entered has to be entered") Validate = False Exit Function End If End Function In the validation rules for the Add Centre form listed above, txtCentreNo.Text = "" means that the field has been left blank, as demonstrated above.

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

    This is to say that if a set of models represent the same thing then it should be possible to put them altogether without introducing inconsistencies. Reduce complexity To deal with systems not too complex to understand directly by breaking them up into more manageable parts and separating out a

  2. ict implementation

    should open The "homepage" worksheet should open 8 Click the command button "invoice" To check the "Invoice" opens The overall Invoice" should open The "Invoice" worksheet opens 9 Click the command button "hide grid lines " To check if the gridlines disappear when clicked The grid lines should disappear The

  1. 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.

  2. 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.

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