• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17

Report: Computing project using Microsoft Access

Extracts from this document...


Richard Clark Computing AS Project Documentation Introduction One of the administrative tasks in a hospital is to keep a record of loans to patients of equipment such as wheelchairs and crutches. The patients borrowing the equipment may still be in hospital or they may have been discharged. Records have to 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. You have been asked to create a computer application to replace the present manual one to record the necessary details to enable greater control to be kept and so cut down on loss and wastage. Design For this project, I am going to use Microsoft Access. The table below shows my design tasks list for the hospital patient and equipment database. Task Number Object Task Description 1 Patient Table Design the Patient table and the properties of its attributes 2 Equipment Table Design the Equipment table and the properties of its attributes 3 Equipment Status Table Design the Equpstat table for the Equipment Form Drop-down box 4 Patient Titles Table Design the Titles table for the Patient ...read more.


Again, I found two main ways of doing this: An auto number system, or a system which would allow a user to determine what the equipment is just by looking at the code. I felt that the second way would be a better way of doing this, so I devised a system that fulfils this requirement (shown below). Item Codes Code Explanation WC Wheelchair CR Crutch EC Elbow Crutch NC Neck Collar -J Junior Size -S Small Size -M Medium Size -L Large Size -A Adult Size To get the individual items code, you simply add a number onto the end of the code. E.g. Junior Wheelchair number 1 would be WC-J1.Using this system, new pieces of equipment can be added with ease, whereas with an auto number system, it would mess up the order of the numbers. Equipment Booking Form Design Security This database holds confidential information about patients, and should therefore be kept secure from illegitimate access, both physically and electronically. As stated in the data protection act, it would be the hospitals responsibility to keep the data secure. ...read more.


Table Equipment Status Table Patient Titles Table Entity Relationship Diagram Equipment Report Customer Letter Report Equipment Form Patient Form Main Menu Form Main Menu (Vb Code) For the main menu, I decided to incorporate a clock, as it provides a purpose (to tell the time), and also looks good on the form. Equipment Form (Vb Code) For the equipment booking form, I used two visual basic sub forms; the first sets the return date and the out date when the "loan out" button is pressed, and the second sets the return date and the out date to zero when the combo box which controls the status of the item is changed. I used this last bit of code because it saves the user having to delete the date manually when the equipment is returned from loan, but it has the downside of having to set the status before pressing the "loan out" button, otherwise it undoes this action. Autoexec Macro To add a professional finish to my database, I made a macro that opened the main menu form automatically on open. This requires no Vb coding, just a macro called Autoexec. 2 2 ...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. Marked by a teacher

    The systems development life cycle (SDLC) is a conceptual model used in project management ...

    3 star(s)

    are reasonable and well within the capabilities of the technology being used. In fact targeted performance should be less than 70% of the published limits of the technologies. Technical requirements are tight for the equipment to be used. [GAN10] Ganthhead(2010), Rapid Application Development Process, http://www.gantthead.com/process/processMain.cfm?ID=2-19516-2 [BPC10] BPC, Articles and Glossary,

  2. Visual basic

    sp1 = True sp2 = False Exit Sub End If End Sub Private Sub Image5_Click() 'When you click on the image5 box image appears and it show you "O or X" If sp1 = True And O5.Visible = False Then X5.Visible = True sp2 = True sp1 = False Exit

  1. Computing Project

    Contain numbers 12 The minimum age you have to be to watch a film DVD ID String Variable Must only Contain numbers 126 The ID of the DVD which is specific to every DVD Price Currency Max 3 char Must only be numbers �1.50 The price charged for the loan Data Dictionary - (Usernames and Passwords)

  2. 140 Computing A-Level Revision Questions

    Describe a binary tree and how it may be implemented in main memory. How does it facilitate sorting? 85. Explain the use of an accumulator in the CPU. 86. An instruction consists of two parts. What are they? 87.

  1. Video Club Database Project

    * Produced customized input screens, using Ms Access to automate data entry wherever possible and to perform various validations. * Use Ms Access modules to enable fast searches for a particular Customer and past stay. * Design reports as needed. The database contains two entities, which are CUSTOMER and MUSIC.

  2. Barilla SpA - Case Report

    demand, the long, costly change-overs made it was nearly impossible to quickly and efficiently produce whichever pasta was selling extremely well at the moment. Another cause of these problems was the large number of SKU's that Barilla's dry products division produced.

  1. I have been given the task to design a database for a company called ...

    field, which makes it impossible for the user to enter in anything but a capital letter for the first character. There is an input mask to make sure the Business postcode has a letter, letter, number, number, number, letter, and letter.

  2. Spare Parts Database Project

    Wong; I invested about Rs 100000 in the business. 1.3 Problems with the current system a. Tracing previous orders placed by a customer Each time a costumer comes in to buy an auto part or has a problem with the goods, the information is written on paper. However, I have frequently encountered loss of important documents and the customer

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