addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscontroller-playcrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobegmailgooglegroupshelp-with-circleimageimagesinstagramFill 1light-bulblinklocation-pinm-swarmSearchmailmessagesminusmoremuplabelShape 3 + Rectangle 1ShapeoutlookpersonJoin Group on CardStartprice-ribbonprintShapeShapeShapeShapeImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruserwarningyahoo

requesting help on MS Access Database

From: Maneesha S.
Sent on: Tuesday, November 15, 2011 2:32 PM
Hey everyone:

I am requesting some help on an Access database I'm building for the Philadelphia Mural Arts Program to track participation in one of our special projects.  I'm hoping someone can help!

I have three tables with fields as follows:

Table Participants:  Participants enroll in our program and we collect name, address, phone, etc and whether they are enrolled at site  X, Y, or Z and for program Year 1, 2, or 3.  Participants can not enroll for more than one year or more than one site.

Table DailyWorkshops:  Daily workshops are set up to show the workshop date, whether it was an A or B session (two sessions per week), who staffed that day's event, what artists attended, and what activities went on.

Table ParticipantAttendance:  Then I want to be able to check off what participants showed up that day.  I have a form DailyWorkshops and want to have a subform/subtable that I can check off whether each participant attended All, None, or Part of that day's session.  I'm having trouble creating that subform.   I think this information should ultimately be STORED in the ParticipantAttendance table but I'm trying to figure out how to have an input table to check off the participants each day.

Any help would be so much appreciated.... I can share the database as I've built it so far if anyone wants to look at it and send it back to me or talk on the phone .... thank you so much!!


**Table: Participants** 
ParticipantID   
FirstName   
LastName    
Address
Phone
SiteNameLookup  
YearLookup

**Table: DailyWorkshops**   
WkshpID 
WkshpDate   
AorB    
SiteStaff   
Artists 
Activities

**Table:  ParticipantAttendance**   
ParticipantID   Participants.ParticipantID
FirstName   Participants.FirstName
LastName    Participants.LastName
WkshpID DailyWorkshops.WkshpID
Level   *(here I have a lookup to fill in HALF/PARTIAL/FULL, not just yes/no)*

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy