Originally Posted by
cmccarter
My wife has be given the "oportunity" to be the registrar of an upcoming Garderer Jamboree. The database has only a few requirements and I have started to build it but I am violating the prime rule tall and thin vs shoe and fat. The requirements are
fname
lname
email
returning (y/n)
Referred by
Association
Lunch typr (regulas/salad) {using listbox)
Remarks
Confirmation sent (Y/N
paid (y/n)
dated entered in db (auto assigned)
All the above can be in a normal table (call it Tbl_Attendiees)
Here's where i get totally lost At the jamboree there will be 7 workshops all of which will done during 3 sessions (so a total of 21 workshops. each attendee eill be able to choose 3 workshops to attend. I need to keep track of which workshop they select.
Right now I have the workshops in their own table and use a drop list box on the attendees tbl to show. But I need to figure out how to keep track of the number of people assigned to each session/workshop.
Nuce to have options will be able to send emails to attendeed, build reports bases on number attending weach sorks shop/session
I had a sample somesent me las year but with over 50 tables/queries/reports I was a bit overwhelmed. I know I can do this using Excel and a lot of sorting and manual intervention but can it be done simply and efficiently with access? I am NOT a programmer just a husband with a mission. any and all help appreciated. can posty a copy og present database if needed.