Coursework.Info - Inspiration in an Instant

On the left is an image preview of every page of this document, and below are the first 150 words with formatting removed:

Design Section - GCSE ICT Coursework Two - Database Project André Skepple-Garraway - Candidate No. 8218 1st April 2002 Form Designs Members Information Design and Field Definitions Table Field Name Data Type Field Size Validation Description Customer ID Text 7 Input mask: LL00\0900 Members chosen ID number Surname 20 -- Members Surname (Alphabetic order) Forename 50 Members Forename Telephone 13 Input mask: 0\ 20\-0000\-0000 Member's telephone number Gender 1 Input mask: L "M" or "F" Member's gender (M or F) Date Joined Date/Time -- Default value:=Date() Date Member joined. For a new member has today's date (=Date()) Date of Birth -- Member's Date of Birth Address Text 50 Member's address Post Code 8 Input mask: La09\ 0LL Member's post code Town 20 -- Member's town Borough Member's borough Video Information Design and Field Definitions Field Name Data Type Field Size Validation Description ID Number Text 12 Input mask: L\-000\-0000\-L Video's ID number given by the store for easy search and classification. Title 50 -- Video title to recognise the video by the staff and customers. Barcode 15 Input mask: "5 "000000\ 000000 The number recognised when the video is scanned in. Number created by manufacturers. VHS or DVD 3 Input mask: LLL To tell what format the video is to categorise by. Rating 2 -- The video's rating to restrict the purchase of video to people...

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 146,168 others

OR

Receive email updates for this category

• Simply tell us your email address and receive a weekly Study Help Email for FREE
• Receive 3 FREE essay views with each email
• Get all the latest essays from Coursework.Info & discussion from TheStudentRoom.co.uk