Making a Volunteer Database PLEASE HELP

[KasBennett32]

Hello I work for a school and have been allocated to make a Volunteer
database using the forms the parents filled out.

I woould like to be able to access the data based on what they agreed to
volunteer to do.....for example:

I need to type in their name address, phone number, then if they passed
fingerprinting, then "what" it is they opted to volunteer for "field trips"
or "clasrroom helper" for example. There are many more categories. I would
like to be able to print each category as the school has the need........how
do I do this in access?

I am unfamiliar with "query" ....and some of the terminology just to let you
know.



any help would be appreciated.....my email is (e-mail address removed)

thanks so much for helping someone out!!!!


regards
Mrs. Bennett

 

[John W. Vinson]

Hello I work for a school and have been allocated to make a Volunteer
database using the forms the parents filled out.

I woould like to be able to access the data based on what they agreed to
volunteer to do.....for example:

I need to type in their name address, phone number, then if they passed
fingerprinting, then "what" it is they opted to volunteer for "field trips"
or "clasrroom helper" for example. There are many more categories. I would
like to be able to print each category as the school has the need........how
do I do this in access?

I am unfamiliar with "query" ....and some of the terminology just to let you
know.



any help would be appreciated.....my email is (e-mail address removed)

It's a BAD IDEA to post your email address on a public forum like this.
Unfortunately, there are lots of spammers and identity thieves and other
criminals who can and will harvest email addresses from the newsgroups. I hope
you won't need to cancel this address and get a new one!

That said... Access can certainly set up an application such as you describe.
I'd start with three tables:

Volunteers
VolunteerID <Autonumber, Primary Key>
LastName
FirstName
Phone
<other fields describing this person>

Tasks
TaskID <Primary Key>
TaskName <e.g. "Field trip to Science Museum">
<information about the task itself, e.g. TaskDate, etc.>

Assignments
VolunteerID <long integer, who volunteered for this task>
TaskID <long integer, what they volunteered for>
<any information about THIS person with respect to THIS task>

There are some good tutorials and other resources available; you might want to
look at Crystal's tutorial to get started:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials