need help, please

[BonnieOJH via AccessMonster.com]

I need to make a database for a Career Day coming up soon at my school. There
will be 300-350 students making 5 choices of 20 different presentations.
However, each student will only attend 4 of the sessions (allowing for
alternate choices if their first four choices are taken). I need two kinds of
output (reports): a roster for each presentation of the students signed up
for that presentation, and a printed schedule for each student so they know
what presentation to go to when.

I'm relatively new to access, and I know this is something that could be done,
but I don't know how to do it. Is there a way??

Thanks,
Bonnie

 

[Piet Linden]

I need to make a database for a Career Day coming up soon at my school. There
will be 300-350 students making 5 choices of 20 different presentations.
However, each student will only attend 4 of the sessions (allowing for
alternate choices if their first four choices are taken). I need two kinds of
output (reports): a roster for each presentation of the students signed up
for that presentation, and a printed schedule for each student so they know
what presentation to go to when.

I'm relatively new to access, and I know this is something that could be done,
but I don't know how to do it. Is there a way??

Thanks,
Bonnie

This isn't too hard. It's a twist on the "students classes" database,
but instead, these are presentations...

relationships:
Student---(1,M)---Choice---(M,1)---Presentation

tables:
Student(
StudentID (PK),
FirstName,
LastName,
....)

Choice(
CStudentID (references Student.StudentID)
CPresentationID (references Presentation.PresentationID)
Attend (Yes/No)
)

Presentation(
PresentationID (PK),
Topic,
Presenter,
Location,
StartDateTime,
EndDateTime)