... Description Cost Of Replacement Status Borrower ID Automatically incremented Retrieved from Loan Form Auto number Text (5) Text (25) Currency Text Number (2) Unique Primary Key>= 0 "L" or "R" or "A" =Patient ID Loan Table This table is the Loan Table; it stores information of who had a piece of equipment on loan, and also when it was taken out, and when it is due for return. Attribute Name Comments Data Type & Length Validation Loan ID Patient ID Equipment ID Date Borrowed Date Due Back Date returned Automatically incremented Retrieved from patient tab. Retrieved from Equip. tab. Auto number Number Text (6) Date/Time Date/Time Date/Time Unique Primary Key =Date() =date + 42 Consultant Table This table holds the information about the Consultant treating each patient. This is then linked to the admission table. Attribute Name Comments Data Type & Length Validation Consultant ID Consultant Name Automatically incremented Auto number Text (30) Unique Primary Key Design of Input Form Patient Form 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 ...

See this essay or coursework document in full right now