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?

 

[PieterLinden via AccessMonster.com]

This is a slight twist on the standard "Students and Classes" database.

Student---(1,M)---SectionRoster---(M,1)---Section---(M,1)---Course---(M,1)---
Department

I would deal with the rules, wherever possible, with groups, but then assign
individuals to each Section (in the Section Roster).

This schema is documented absolutely to death in books and on the internet,
so dig around and you'll find a good starting point.

 

[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