Computing project using Microsoft Access Essay

One of the administrative tasks in a hospital is to hold open a express of loans to patients of equipment such as wheelchairs and crutches. The patients borrowing the equipment may static be in hospital or they may digest been discharged. Records have to be unploughed of what equipment has been borrowed, by whom and when, and also if any equipment is not procurable beca use up it is being repaired. You have been asked to create a computer application to supplant the present manual virtuoso to record the necessary details to modify greater control to be kept and so cut plenty on loss and wastage.Design For this project, I am going to use Microsoft vex. The mesa below shows my design tasks list for the hospital patient and equipment database. labor movement Number Object Task Description 1 unhurried hedge Design the long-suffering table and the properties of its attri notwithstandinges 2 Equipment Table Design the Equipment table and the properties of its attributes 3 Equ ipment Status Table Design the Equpstat table for the Equipment take in Drop-down boxwood 4 Patient Titles Table Design the Titles table for the Patient coordinate Drop-down box 6 Equipment discipline.Design a Report to show menstruation equipment status 7 Equipment Return Letter Design a report, in the style of a letter, which is sent to patients who have overdue equipment. 8 Patient Entry edition Design a form to fork forth a front end for the patient entry table 9 Equipment engagement Form Design a form to book equipment out to patients 10 main(prenominal) fare Form Design a form which lavatory execute the other forms and records 11 Autoexec macro Design a Macro that executes automatically on database open and opens the important menu 12 warrantor Implement some kind of security into the database.Design of Equipment Loaning transcription There are several types of equipment, ranging from wheelchairs to neck collars, and individually type of equipment is for sale 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 unflinching 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 line of work 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 token was damaged in someway, a note of the problem could be do in a notes field in the items record. The second problem I discovered was coming up with a way of having a cipher for each individual piece of equipment. Again, I found two main ways of doing this An auto number scheme, or a system which would cease a user to determine what the equipment is just by looking at the code.I felt that the second way would be a part way of doing this, so I devised a system that fulfils this requirement (shown below). circumstance Codes Code Explanation WC Wheelchair CR Crutch EC Elbow Crutch NC Neck learn -J Junior Size -S Small Size -M Medium Size -L biggish Size -A Adult Size To get the individual items code, you simply tag on 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 freshet up the order of the numbers. Equipment Booking Form DesignSecurity This database holds surreptitious information about patients, and should therefore be kept secure from illicit access, both fleshlyly and electronically. As stated in the data justification act, it would be the hospitals responsibility to keep the data secure. I have utilize a basic password protection system into the database, with only one user, as I fe el 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 accepted there is an appropriate firewall system installed if the terminal the database is running on is attached 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. Implementation Task Number Object Screen red cents from Access 1.Design View of Patient Form 13 Patient Form Data View of Patient Form 14 Main bill Form Design View of Main Menu Form 15 Main Menu Form Data View of Main Menu Form 16 Main Men u Form Show optical Basic Code used 17 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 change 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 postal code when the combo box which controls the status of the item is changed. I used this oddment 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, differently it undoes this action.