In my project I am using three tables Essay Example for Free

In my project I am using three tables Essay Calculate Date Due Back   Scroll through on the stock table to the desired item   The hire table displays all of that item and status etc   Change the status from available to on loan (L), select customer ID from the lookup and enter Date out   Click Calculate Date Due Back button to calculate date due back Validation And Verification I will use validation in my tables, e. g. length check for phone number, and the presence check for stock number. I eliminate a lot of the need for validation with lookup functions for example title in customer table, and item ID in hire table. This helps to avoid unnecessary mistakes, and prevents unneeded duplication. Testing I will now show hard copies of the database to prove that it is working correctly. This is the Customer Table The lookup function shows what a patient currently has on loan. Miss Russell currently has two junior crutches, a junior neck brace and a junior wheelchair which are due back on 23/02/2003 and 13/02/03 for the junior wheelchair. The wheelchair is currently overdue, and my overdue query will show this. Miss Russells other items are due to be returned within the week, so they should be on the Due This Week query, I will show a printout to prove my project is working correctly. The stock information query below shows that the junior wheelchair, stock #1 is in Miss Russells possession. I will now show that Miss Russell has returned the wheelchair, however it needs repaired, and Miss Russell requires a replacement. I will change the settings on the Stock Hire Linked table, and click the calculate Date Due Button These changes now appear in my tables and my weekly stock report. I will also show how I can add new items and customers. I will add a Mr Wilson, living in Gall Street, and in ward 5. This also shows my phone number validation, as I have purposely entered 11 numbers instead of 12.