Re: Schedule/Class Management Database

Tech-Archive recommends: Speed Up your PC by fixing your registry

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

--
Brendan Reynolds
Access MVP


"B" <B@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D5CAABC1-AE6F-4688-B82D-3042BD0F9259@xxxxxxxxxxxxxxxx
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!


.

Relevant Pages

  • Re: Membership Table Question
    ... You are right about human relations defying a database. ... >> where the main tables include Family Info, Child Info, ... Because students sign up for either ... >> teacher in the family, what is the best way to link the ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Mechanical Aptitude Test
    ... And that teacher became one of my best friends ... If it's fair for the teacher to do it, then the students may ... Following instructions, btw, is part of why the Great Merkin Pubic has about 10,000 congressional dicks, and about 100,000 lobbyists dicks up their asses. ... Mark Spitz learned to swim in Hawaii, starting at age two, and began formal training in California at age six. ...
    (alt.machines.cnc)
  • Re: Mechanical Aptitude Test
    ... And that teacher became one of my best ... If it's fair for the teacher to do it, then the students may ... Following instructions, btw, is part of why the Great Merkin Pubic has about ... Absolutely Vote, but NOT for a Democrat or a Republican. ...
    (alt.machines.cnc)
  • Re: Mechanical Aptitude Test
    ... And that teacher became one of my best ... If it's fair for the teacher to do it, then the students may ... Following instructions, btw, is part of why the Great Merkin Pubic has about ... training in California at age six. ...
    (alt.machines.cnc)
  • Re: Problems adding text to memo field
    ... The database contains the following tables: ... Homerooms- HR#, HR Teacher; ... I have built a query with the following SQL coding: ... Info].Comments, [Students Info].CourseStatus ...
    (microsoft.public.access.formscoding)