Conference Attendee Scheduling

[becca.raider]

I am trying to build or find a template to schedule conference attendees
based on a group that I assign them. Attendees have required sessions based
on their groups and elective periods that I can assign them classes based on
the preference they indicated on the registration forms.
Example: Group 5A has required classes during period 1, 2, and 4 with
periods 3 and 5 elective options. Group 4A has required classes during
periods 1, 4, and 5, etc.
Some classes will be attended by multiple groups and the electives classes
will not have a group, but a bunch of individuals.
I have a table with attendee info. I have a class table with ClassName,
Period, Room, StartTime, EndTime, Instructor, MaxNumber (max number of people
in the class).
I need to be able to print individual schedules for people as well as
rosters for each class. I also need to be able to scroll through the elective
classes during a period to see which has openings.
Does anyone know of a template or point me in the right direction to build
it?

 

[Roger Carlson]

On my website, www.rogersaccesslibrary.com, there is design tutorial called
Consolidated Widgets which shows a step-by-step process to design a "widge"
trade-show conference with sessions, and presenters, and the like. It's
likely more complicated than you need, but it should give you a rationale.
You can find it here:
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=238

I also have a Training Registration database sample which might work for you
with modifications:
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=232


--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L