Site info Table Design

[Guest]

I am a coordinator for the local AARP tax aide program. I want to create
database for the local sites that I run.
Site table. How can I construct the Site Info Table so I can add it to the
volunteer info form and be able to select multiple sites and the different
days to vollunteer at the site. Ex. Each site is open a few days a week at
certain times. I want on the volunteer form to be able to select a #1 site
preference and the days they want to volunteer and choose a #2 site
preference and the days they would volunteer at that site. I hope you catch
my design need?

Thank you in advance

 

[John Vinson]

I am a coordinator for the local AARP tax aide program. I want to create
database for the local sites that I run.
Site table. How can I construct the Site Info Table so I can add it to the
volunteer info form and be able to select multiple sites and the different
days to vollunteer at the site. Ex. Each site is open a few days a week at
certain times. I want on the volunteer form to be able to select a #1 site
preference and the days they want to volunteer and choose a #2 site
preference and the days they would volunteer at that site. I hope you catch
my design need?

Thank you in advance

Well, you'll need several tables here. Just some ideas, not a full
design:

Sites
SiteID
Location
<any needed information about the site>

SiteDates
SiteID
StartTime Date/Time
EndTime Date/Time

This table would have one record for each block of time that
it's open, as StartTime #4/8/2005 10:00# and EndTime #4/8/2005 15:00#

Volunteers
VolunteerID
LastName
FirstName

SitePreferences
VolunteerID
Rank <1 for first choice, 2 for second, etc)
SiteID

Schedule
VolunteerID
SiteID
StartTime Date/Time
EndTime Date/Time


You'll need some fairly advanced forms to automate the choice of site
and times (using the start and end times to be sure that the user can
only volunteer for a site that's open at the desired time).

John W. Vinson[MVP]