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:

I am taking over my fathers business that is the video shop; my father never used Microsoft access to record all the DVD and videos so he recorded them all in a book. I am going to use Microsoft access to record all the DVD's and videos and customers who have a store card to keep tabs on everything that is rented out. This will be easier than storing the information in a notebook because I will be creating a series of tables to make this new idea more efficient and manageable. DVD'S/Videos Field Name Data Type Length Primary and Foreign key DVD/Video ID Number Auto Number Long Integer Primary key Title Text 50 characters - Genre Text 50 characters - DVD/Video Text 50 characters - Classification Text 5 characters - Running Time (Min) Number Long Integer - Stars Text 50 characters - Customers Field Name Data Type Length Primary and Foreign key DVD/Video ID Number Auto number Long Integer Primary Key Title Text 5 characters - 1st Name/initial Text 50 characters - Surname Text 50 characters - Address Text 90 characters - D.O.B Date/Time - - Telephone Text 20 characters - E-mail Text 50 characters - Mobile Text 20 characters - Borrowing Log Field Name Data Type Length Primary and Foreign key Customer ID Number Number Long Integer Foreign Key DVD/Video ID Number Number Long Integer Foreign Key Date Rented Date/Time - - Date Due Date/Time - - Returned?? Yes/No - - Overdue...

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 149,410 others