Question: b . tblReturns Field Name Data Type Description ReturnID AutoNumber A unique ID for a returned book field size long integer indexed yes ( no
b tblReturns Field Name Data Type Description ReturnID AutoNumber A unique ID for a returned book field size long integer indexed yesno duplicates BorrowID Number A unique ID for a borrower Field size long integer reuired no indexed no BookID Number Unique ID for the book field size long integer required no indexed yesDuplicates ok returndate datetime return date for the book borrowed format short date required no indexed no Actreturndae datetime date the book was actually returned on format short date required no indexed no lateday number number of days that the book is submitted late field size long integer required no indexed yes duplicated ok fine currency fine levied for late book submission required no indexed no import and append data from ABLreturn.txt in the tblreturns table
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
