New to Access, volunteer project

[Guest]

I am a parent volunteer at a local high school and we are trying to move away
from excel spreadsheets to manage our volunteers here at the school. I have
started a database and have created a table called ParentVolunteers that
will contain Volunteer contact info, but I need to input the projects they
have volunteered for. i.e. Teacher Appreciation, Fall Picnic, Senior Prom,
etc. I am stumped with the prospect of how to manage the volunteer
opportunities. We have a list of things to volunteer for, and some people
volunteer for several things. I understand I should create at least another
table, I am just unsure how to link multiple things to one person. The I
have to create a form that will allow me to enter this data, into both
tables. The last time I worked with Access, was in 1998, I believe it was
Access95 then. Any tips you can offer will be fabulous. We are in the middle
of registration and I would like to actually send out some kind of
acknowledgement to those who have volunteered in a timely fashion. Thanks.

 

[Guest]

Well it looks like you will need at least 3 tables:
Volunteers, Activities and VolunteerActivities
You will list volunteers in the Volunteers table, activities that anyone can
volunteer for in the Activities table and VolunteerActivities will link
volunteers and activities.

I'd post any further questions in the Table Design forum.

Dorian

 

[John W. Vinson]

I am a parent volunteer at a local high school and we are trying to move away
from excel spreadsheets to manage our volunteers here at the school. I have
started a database and have created a table called ParentVolunteers that
will contain Volunteer contact info, but I need to input the projects they
have volunteered for. i.e. Teacher Appreciation, Fall Picnic, Senior Prom,
etc. I am stumped with the prospect of how to manage the volunteer
opportunities. We have a list of things to volunteer for, and some people
volunteer for several things. I understand I should create at least another
table, I am just unsure how to link multiple things to one person. The I
have to create a form that will allow me to enter this data, into both
tables. The last time I worked with Access, was in 1998, I believe it was
Access95 then. Any tips you can offer will be fabulous. We are in the middle
of registration and I would like to actually send out some kind of
acknowledgement to those who have volunteered in a timely fashion. Thanks.

As Dorian suggests, you need a third table.

You might be able to use my free Church Membership database. It lets you enter
Families which consist of People; Activities; and each person can be linked to
any number of activities and vice versa. If you'ld like a copy email me at
jvinson <at> wysard of info <dot> com. There's nothing particularly "churchy"
about the database other than that it's called MEMBERS.MDB.

John W. Vinson [MVP]