Tables to create:
Books
Authors
Students
Loans
Perform data entry: 20 records in books table, 10 records in the authors table and 30 entries in the table students and 15 records in the table loans.
Suggested Fields (key field in red)
Books
Idbook (autonum)
Title (Text)
idauthor (num)
Students
Idstudent (autonum)
Name (text)
birth_date (date)
Phone (text)
E-mail (text)
Loans
Id_loan (autonum)
Id_book (num)
Id_student (num)
Loan_date (date)
Return_date (date)
1) Create the Table authors too.
2) Create 2 forms and 4 queries
Visit this link to learn more about QUERIES
http://office.microsoft.com/en-us/access-help/examples-of-query-criteria-HA010066611.aspx
