... Surname, Forename, DOB, Street, Village, City, Post Code, Telephone, Membership Start Date, Membership End Date) tblMovies(Movie ID, Title, Rating, Format, Number of Copies) tblLoans(Loan ID, Movie ID, Member ID, Date Loaned, Date Return, Returned?) Tables will contain the following:- tblMember Validation Field Name Comment Data Type and Length Input Mask Required Allow Zero Length Other Member ID AutoNumber, Long Integer No Yes No Unique Primary Key Surname Text (20) Yes Yes No No Forename Text (20) Yes Yes No No DOB Short Date Yes Yes No No Street Text (30) No Yes No No Village Text (20) Yes No Yes No City Text (20) Yes Yes No Default = "Leicester" Post Code Uppercase Text (10) Yes Yes No No Telephone Number Text (15) Yes Yes No No Membership Start Date Short Date Yes Yes No No Membership End Date Automatically Calculated Short Date N/A N/A N/A N/A tblMovies Field Name Comment Data Type and Length Input Mask Required Allow Zero Length Other Movie ID AutoNumber, Long Integer No Yes No Unique Primary Key Title Text (40) No Yes No No Rating Multi-choice - U, PG, 12, 15, 18 Multi-choice N/A Yes No No Format Multi-choice - VHS Multi-choice N/A Yes No No Number of Copies Multi-choice - 1-5 Multi-choice N/A Yes No No tblLoans Field Name Comment Data Type Input Mask Required Allow Zero Length Other Loan ID AutoNumber, Long Integer No Yes No Unique Primary Key Movie ID Lookup field Lookup from Movies Table N/A Yes No No Member ID Lookup Field Lookup from Members Table N/A Yes No No Date Loaned Short Date Yes Yes No No Date Return Automatically Calculated Short Date N/A N/A N/A N/A Returned? Multi-choice Yes/No N/A No Yes No tblReservation Field Name Comment Data Type Input Mask Required Allow Zero Length Other Reserve Id Auto Number AutoNumber, Long Integer No Yes No Unique Primary Key Member ID Lookup field Lookup from Movies Table N/A Yes No No Movie ID Lookup Field Lookup from Members Table N/A Yes No No Identification of Storage Material and Format This system will be stored on hard disk, ...

See this essay or coursework document in full right now