o, hi, everyone! i'm relatively new to microsoft access--used it beginning of march to enter data at a friend's place, and decided this month to figure it out. i've been working on it for about a week and have learned a lot. but i'm stumped.

i'm trying to make a database similar to the "students and classes" one they have a wizard for. but i want it different than theirs, like with information they don't have, and i don't need all the info they do have.

so here's what i want to do. i have a table for students, a table for classes, a table for showing which students are in each class, a table for entering assignments for each class. i know that each student has several classes, and each class has several assignments. kind of like this:

Student = # Classes = $ Assignments = ^

#
/ | \
$ $ $
/ | / \ | \
^ ^ ^ ^ ^ ^

i want to be able to enter # and $ and get ^
(i typed that in microsoft word and copied it, so if things are crooked, i'm sorry!)

basically, that says it. I want to say, "for student #1, in class #5, what are the assignments she has?" and get a list. do you have any idea how that could be done? also, do you know of a website that teaches microsoft access from simple to complex, going into lots of detail?

i'd appreciate any help i can get!

Lisa

What you are describing is a Select query. You can display the results of a query in several different ways, including a Form or a Report.
Simply put, go to the Queries Tab, hit 'New', add the tables you wish to get data from, add the fields you wish to get data from to the query designer, then hit the View button.
I don't know of any websites that train a beginner to Access, sorry. There are lots of good books available though. Search the archive here for recommendations. Microsoft's website has some informative articles that teach some of the fundamentals, as well.

Shep