Schedule/Class Management Database

[B]

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?

In a reponse I got, I was told to create three tables and relate them. What
does that mean? How do I do that? Step by step would be great, if any one
has the time. Here are the instructions I got from a very nice person. I am
a beginner in access bt well versed in all other office products.

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

Many, Many Thanks!

 

[Brendan Reynolds]

I'm afraid I don't have time to provide step-by-step instructions, but here
are links to some resources that you may find useful. The first is to the
Access 2000 assistance page on Microsoft's web site. The second is to the
Access 2003 training page, which has on-line tutorials. This latter is a new
feature of the web site, and there isn't, as far as I know, an Access 2000
version, but much of the Access 2003 stuff will be relevant to Access 2000
as well.

http://office.microsoft.com/en-us/assistance/CH010423431033.aspx

http://office.microsoft.com/en-us/training/CR061829401033.aspx

 

[mnature]

If you do not understand how to create tables and then relate them, you will
not be able to do this project within a reasonable amount of time. You
simply do not have the knowledge or tools to do it. That is not to say that
you cannot obtain the knowledge and tools in the future, and I would
encourage you to learn about programming an Access database.

You should go to whoever controls the money for buying software, and proceed
to plead with and perhaps even try emotional blackmail to get them to
purchase Access 2003 for you. The template that Microsoft has for Classroom
Management would probably be perfect for you, would not cause you emotional
trauma through trying to learn Access programming at the same time you are
putting a database together, and the template is completely free (which your
time is not).

The template includes 8 tables, 6 queries, 13 forms, 6 reports, and 3
macros. You would not only have to learn how to make tables and relate them,
you would also have to learn how to make queries, forms, reports, and macros.

On Microsoft's site, they will sell a standalone Access 2003 for $229 US.
Office Professional (which is the office suite which includes Access) sells
for $499 US. You may be able to get a copy of Access 2003 from one of the
big retailers or a software store for less than that (if your work would
reimburse you for such a purchase).