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

In my project I am using three tables Essay regard escort delinquent Back Scroll through on the stock table to the desired point in time The hire table displays all of that item and status etc Change the status from available to on bring (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 give 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 right away show hard copies of the database to strain that it is working correctly. This is the Customer Table The lookup function shows what a tolerant presently has on loan.Miss Russell currently has two junior crutches, a junior neck evoke and a junior w heelchair 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 inside 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 in like manner show how I can add new items and customers. I will add a Mr Wilson, livelihood in Gall Street, and in ward 5. This also shows my phone number validation, as I crap purposely entered 11 numbers instead of 12.