How to create Books Library Checkin Checkout database

[NotesAndSoft]

Hello guys,


I need your help in creating Library checkin checkout system in access 2007,
Tables are:
Books
Patrons

and others but for checkin checkout i need these two (please tell me if i need other)
and other question that i have is
if i have a book called "Access"
and i have ten copies of it in my database
so how to checkin checkout stock of copies of book

Thankyou guys , i will really appreciate your help.

[June7]

You might take a look at the MS Lending Library template. http://office.microsoft.com/en-us/te...010206883.aspx