If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Conference Attendee Scheduling
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? -- Thanks in advance! Rebecca |
#2
|
|||
|
|||
Conference Attendee Scheduling
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. -- Message posted via http://www.accessmonster.com |
#3
|
|||
|
|||
Conference Attendee Scheduling
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 he http://www.rogersaccesslibrary.com/f...ts.asp?TID=238 I also have a Training Registration database sample which might work for you with modifications: http://www.rogersaccesslibrary.com/f...ts.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/...UBED1=ACCESS-L "becca.raider" wrote in message news 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? -- Thanks in advance! Rebecca |
Thread Tools | |
Display Modes | |
|
|