Here is my database situation:

Database Books:

Tables:
Books: book id (primary key), title, price, quantity, category
Students: ssn (primary key), name, email, password

What I am working on is an online bookstore project. I'm using MS Access 2000, 2003, and 2007 (depending on where I am). Basically, we need to be able to log them in compared to the information in the students table. The login information will be their ssn and password. We need also a registration page that'll take that information in and send it to the students table.

For the books, we need it to read from the books table and print out the books as well as price and quantity. There should be a way for them to click somewhere to order it..or something..this part evades me. I'm not quite sure how we should do this. We also need a way for books to be entered in, which would work like the registration page I imagine.

I'm simply looking for suggestions and ideas, especially on how to connect all this stuff. Our teacher doesn't give us really any help, and expects us to figure it out, and none of us can - which is about 10 people total. We've been trying for weeks, and I'm simply getting frustrated more and more with each thing I try.

Thanks!