... No Number Lookup - - Customer No. - Customer Table Status Text Lookup - A A, L, R Date Out Date 8 - - - * Item ID - Lookup to stock table for the ID of a stock item * Individual Stock Number - The stock number of the particular item * Customer No - Lookup to the customer table for the customer id number * Status - Current status of the item, available, on loan, or in for repair Stock Table Field Name Data Type Length Validation Default Lookup Item ID Text 2 - - - Description Text 20 - - - Cost Of Replacement Currency 6 - - - * Item ID - Two letter mnemonic code for item e.g. WJ for wheelchair - junior * Description - A description of the item e.g. Wheelchair - Junior * Cost Of Replacement - The amount of money required to replace an item Relationships The Image below outlines the relationships in my database. Data Capture Forms Customer Customer No Title Initial Surname Address Post Code Phone Number Ward Number Discharged Stock Table Linked to Hire ...

See this essay or coursework document in full right now