Thread: Event manager database
2014-07-17, 06:06 #1
- Join Date
- Jan 2001
- St. Marys, Ontario, Canada
- Thanked 0 Times in 0 Posts
Event manager database
I have Access 2000. I am trying to create a very simple database to assign volunteers for events. The example I got with Access is much too complicated and I have gotten totally confused trying to adapt it. Here is what I want.
I want a table with the volunteer information. I want a table with the event information. I want a table with the different times the volunteers will work, which will vary depending on the event. I think I need another table to link up the volunteer information and event tables, but I'm not sure.
From this I want to create a form with a subform that shows the volunteer and the various events he has volunteered for. I also want a form with a subform that shows an event and all the volunteers working on it with their times.
Finally, I want to create a report showing the event with the volunteers sorted by their start time. Since most people don't have Access, I want to be able to export it to Word or Excel, which I don't think is difficult to do.
Can anybody help me or send me an example of what I want? I figure it isn't that difficult, but I lack the expertise.
Subscribe to our Windows Secrets Newsletter - It's Free!
Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!
+ Get this BONUS — free!
Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!
2014-07-17, 11:29 #2
- Join Date
- Mar 2010
- Winston-Salem, NC USA
- Thanked 3 Times in 3 Posts
Let's start with the database design first. Click on the image to expand it.
I hope I've accommodated all your criteria and keep in mind this is a simplistic diagram. You can add detail as needed.
First I would have an Event table that contains the basic info about the event. Next would be an Event Schedule. This is where you breakout your "sessions" whether it be one session, multiple sessions across one day, or multiple sessions across several days. I should have included a session description in this table.
You have your Volunteer table with each volunteer's information and where all the action is would be in the Volunteer Schedule table. This is the place you pick the session and assign the volunteer to it.
I believe this design will allow flexibility in generating any sort of report that you require; Listing of Volunteers by event, listing of events by volunteer, lisitng of volunteers by session, and so on.
Last edited by Bender; 2014-07-17 at 11:33. Reason: Addl CommentDo your part!!! Report SPAM to http://www.spamcop.net/