Basic help with project

[undergroundpanda]

hey guys, I'm not sure if this is the right spot for this, so feel free to move it if I'm wrong.



Anyway, I've got a major school project where I have to make a relational database in access. Problem is, never used it before. I'm hoping to get basic ideas of what exactly I should be doing for what I want to do, more of a what to do instead of a how to do it.

I'm making a database to manage textbook loans to students, I'm basically going to have a student table with name, a drop down list(if possible?) of books they currently have loaned, and as of now can't think of other data for that table.
The other table will be a list of the books, each will have a unique id code that I'll make up, then respectively belong to common names, and then subjects. There will be a check box of if it's loaned, and who to.

My aim is basically to have a database that lets you:
1. view a list of the textbooks and students(and what books they have)
2. change books to and from "loaned" and to specific students
3.??? as far as I know not much else.

I'm hoping to get general guidance as to how complex this may be, and how to go about it. Thanks guys.

[alansidman]

This may be helpful.

http://www.databaseanswers.org/data_...rary/index.htm

http://www.databaseanswers.org/data_...hool/index.htm

Alan

[June7]

Check out the Lending Library template database. Open Access, enter Lending Library in the 'Search Office.com for templates' box.