Database Design

This is the form that is used for the use of inputting patient details. It has a nice clear layout, and should be simple to use. This form is used for adding, looking up and editing any patient details on the data base. It is not linked to any table apart from the Patient Table. The search tool was also added to make it easier and quicker to search for patients in the database. Admission Form This is the form that is used for the use of inputting details of admissions into the hospital.

Again, it has a nice clear layout, and should be simple to use. Equipment Form This form is used for inputting and editing the status of pieces of equipment. Also a search tool was added so it is easier to search for a specific piece of equipment. . Loans Form This form is used for when a piece of equipment is loaned out to one of the patients of the hospital. It also gives the date of the piece of equipment was loaned and also the date when it is due back, and date returned. Report Design Equipment Status Report.

We Will Write a Custom Essay Specifically
For You For Only $13.90/page!


order now

Reminder Letter Queries I used queries in the database, because it meant I could gather information from more than one table, so I could adjust what information would be shown and be able to be edited in the forms. Admission Query – This links information from Admission table and Patient table. This query is used in the admission form. Information from both tables can be edited and added from this form. Loan Query – This links information from Equipment table, Loan table and Patient table.

This query is used in the Loan form. Information from both tables can be edited and added from this form. Current Patient Query – This links information from Admission table and Patient table. This query is used in the Equipment Status report and the Loaning form. Information from both tables can be edited and added from this form. Equipment Query – This one was added because not all fields of the equipment record was needed for this query. So some of the fields were removed.