Logged out
Access All our Essays in an Instant
Swap your work for FREE access, or pay £4.99 for instant access
Design - In my project I am using three tables, the customer table, the hire table, and the stock table.
Member rating: No Rating | Words: | Submitted: Mon Sep 08 2003
Page Preview
On the left is an image preview of every page of this document, and below are the first 150 words with formatting removed:
Design In my project I am using three tables, the customer table, the hire table, and the stock table. Below I will sketch out an outline of the tables. Customer Field Name Data Type Length Validation Default Lookup Customer No Autonumber 1 - - - Title Text 3 - Mr Mr, Mrs, Miss, Sir, Rev Initial Text 1 - - - Surname Text 15 - - - Address Text 20 - - - Post Code Text 8 - - - Phone Number Number 12 length must equal 12 - - Ward Number Text 7 - - Ward 1 - Ward 10 Discharged Yes/No - - No - * Customer No - Autonumber to represent the customer ID number * Title - Title of customer. Lookup for Mr, Mrs, Miss, Sir and Rev. Defaults to MR. * Initial - Customer's first initial * Surname - Customer's surname * Address - Address of customer * Post Code - Postcode of Customer * Phone Number - Phone number of customer. Validation to make sure length is equal to 12 * Ward Number - The ward in which the patient stayed/is staying. Lookup for the 10 wards * Discharged -...
Get instant access
- Instant, unlimited access to our documents in full
- Swap your work for free access, or pay £4.99
- To see the full version of this document and 151,744 others
