We use cookies to give you the best experience possible. By continuing we’ll assume you’re on board with our cookie policy

Computing AS Project Documentation Essay Sample

  • Pages: 7
  • Word count: 1,693
  • Rewriting Possibility: 99% (excellent)
  • Category: patient

Get Full Essay

Get access to this section to get all help you need with your essay and educational issues.

Get Access

Introduction of TOPIC

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.


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


Task Description

Patient Table

Design the Patient table and the properties of its attributes

Equipment Table

Design the Equipment table and the properties of its attributes

Equipment Status Table

Design the Equpstat table for the Equipment Form Drop-down box

Patient Titles Table

Design the Titles table for the Patient Form Drop-down box

Equipment Report

Design a Report to show current equipment status

Equipment Return Letter

Design a report, in the style of a letter, which is sent to patients who have overdue equipment.

Patient Entry Form

Design a form to provide a “front end” for the patient entry table

Equipment Booking Form

Design a form to book equipment out to patients

Main Menu Form

Design a form which can execute the other forms and records

Autoexec Macro

Design a Macro that executes automatically on database open and opens the main menu


Implement some kind of security into the database

Design of Equipment Loaning System

There are several types of equipment, ranging from wheelchairs to neck collars, and each type of equipment is available in different sizes, there are also several of each type and size of equipment.

When deciding how to input and store the equipment into my database, I decided that their was two potential paths that I could follow: to place the equipment into my database with one record for each type and size of equipment, and having a “number in stock” field to represent multiples of equipment types with the same size. The second way of representing the data would be to let each individual piece of equipment have its own record.

I elected to take the second route, although it would take more space, it would mean that if an item was damaged in someway, a note of the problem could be made in a “notes” field in the items record.


e second problem I discovered was coming up with a way of having a code for each individual piece of

Sorry, but full essay samples are available only for registered users

Choose a Membership Plan
equipment. 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








Elbow Crutch


Neck Collar


Junior Size


Small Size


Medium Size


Large Size


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


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. I have employed a basic password protection system into the database, with only one user, as I feel that a multi user password system with different levels of access for each user would be inappropriate in this instance because the only users would be the desk staff, and occasionally the administrator for backup purposes.

To provide security on an electronic level, I would recommend making sure there is an appropriate firewall system installed if the terminal the database is running on is connected to any network external to the hospital. I would also recommend a weekly backup to a removable media, kept in a fireproof safe, with back copies kept for as long as possible, in case the system is infected with an undetected Trojan. On a physical level, I would recommend that rooms where terminals have access to the database are kept locked.


Task Number


Screen Dumps from Access

Patient Table

Design Views of Patient Table

Patient Table

Data Views of Patient Table

Equipment Table

Design Views of Equipment Table

Equipment Table

Data Views of Equipment Table

Equipment Status Table

Design Views of Equipment Status Table

Patient Titles Table

Design Views of Patient Titles Table

All Tables

Screen Dump of Entity Relationship Diagram

Equipment Report

Screen Dump of Equipment Report

Equipment Return Letter

Screen Dump of Customer Letter (Report)

Equipment Form

Design View of Equipment Form

Equipment Form

Data View of Equipment Form

Patient Form

Design View of Patient Form

Patient Form

Data View of Patient Form

Main Menu Form

Design View of Main Menu Form

Main Menu Form

Data View of Main Menu Form

Main Menu Form

Show Visual Basic Code used

Autoexec Macro

Screen Dump of Autoexec Macro

Patient Table

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

We can write a custom essay on

Computing AS Project Documentation Essay Sample ...
According to Your Specific Requirements.

Order an essay

You May Also Find These Documents Helpful

Evolving practice of Nursing and Patient Care

Nursing is a unique healthcare profession that is an affiliation in maintaining and delivering healthcare services, education, health advice, and counseling. The aim of the research and the presentation is to educate nurses on the advanced changes to health care delivery in the American healthcare system. The economic changes in the USA translate into healthcare evolution. Healthcare reform has been put I place to curb with the demographics and technological changes that affect healthcare systems. Expected growth and change Continuity of care. The quality of care provided in healthcare systems is based on the patient's relationship with the care provider and the ability to provide services in response to emerging needs. The consistency of the staff in attending to the patient's needs is a source of quality caregiving. The government and acute care facilities have generated efforts to include a continuum of care in advanced models of care and remission. The...

Preventing and Treating Common Dental Problems

Dentists diagnose and treat problems with patients’ teeth, gums, and related parts of the mouth. They provide advice and instruction on taking care of the teeth and gums and on a diet choices that affect oral health. (Occupational Outlook Handbook) Dentists usually work four or five days a week and full-time dentists work about forty hours a week, but some may work more. Depending on what their patients need they will work mornings and evenings to fit their schedule. Most dentists are “solo practitioners,” this means they own their own business and work alone or they have a small staff. Some dentists have partners or work with other dentists as associate dentists. This field interests me because I think this is a field that I will enjoy and not get tired of. I have always wanted my own business and making a good amount of money will allow me to...

Communication for building good patient-professional relationships

Effective communication is essential in all health and social care settings as part of building and maintaining good patient-professional relationships. These skills help both patient and professional to learn about each other and understand each other, so that they can for that reason meet each other’s needs. This includes language at an appropriate level and using methods of communication that the individual is comfortable with. A type of communication used in health and social care is verbal, this is used to communicate by one person speaking and the other person listening. Verbal communication is the skill to use words to put forward ideas, thoughts and feelings to another person in a variety of environments. Effective listening however, is much harder than speaking and requires a lot more skill than just waiting for the other person to finish talking. “Communication is the simplest way to really get a sense of how...

Popular Essays


Emma Taylor


Hi there!
Would you like to get such a paper?
How about getting a customized one?