Scheduling

[Mike K.]

I am running access 2000 and I need to create an Access database that would
allow me to do the following:
Have the title of the book and author
A blurb about the book
The Teacher overseeing it
And the students that are going to read it.

I then need to be able to create reports of the students and the books they
are reading. I need a database that is similar to the one microsoft has on
their website. (I can't use it because I don't have Access 2003.) Any
suggestions on how to create this database?

Many, Many Thanks!

 

[nanne]

create 3 tables
books: book-id author title blurb teacher-id

people: people-id first name last name student or teacher

reading: book-id people-id first-date end-date

relate the tables

create queries/forms to edit the tables.

create query/report on the related data you require to see

suc^6
Nne

 

[B]

Thank you for the information. To be honest, my access knowledge is basic.
If you could be so kind as to give me just a few steps as to how I go about
doing the table, I would apperciate it.
Thank you so much.