Any suggestions for issue listed?

  • Thread starter Thread starter JackH
  • Start date Start date
J

JackH

am currently working on an access database for the wellness division of the non-profit organization I work for. They are currently tracking all of there members, activities, member attendance, and payments in excel worksheets.

Here is the current table setup:

tblindividuals 1->many tblactivityindividuals many->1 tblactivities many->1 tblsourceactivities
tblindividuals 1->many tblpaymenthistory
tblindividuals 1->many tblmembership

the initial issue is how to handle attendance easily on a form. The person entering attendance, after a class/activity has been held, does not want to look up each individual and then assign the activity and put in the attendance. I need to know how I can assign several individuals at one time to an activity/class and also add the attendance of each individual that attended the class at one time.

Does this make since?

Some thoughts I had were:

1. Create a membership type and somehow be able to assign all individuals that would be allowed that activity/class by the type of membership.
2. Be able to pick the membership type on a form and somehow select all attendees at one time with the specific date and time


Any ideas would be greatly appreciated.

Jack
 
am currently working on an access database for the wellness division of the non-profit organization I work for. They are currently tracking all of there members, activities, member attendance, and payments in excel worksheets.

Here is the current table setup:

tblindividuals 1->many tblactivityindividuals many->1 tblactivities many->1 tblsourceactivities
tblindividuals 1->many tblpaymenthistory
tblindividuals 1->many tblmembership

the initial issue is how to handle attendance easily on a form. The person entering attendance, after a class/activity has been held, does not want to look up each individual and then assign the activity and put in the attendance. I need to know how I can assign several individuals at one time to an activity/class and also add the attendance of each individual that attended the class at one time.

Does this make since?

Some thoughts I had were:

1. Create a membership type and somehow be able to assign all individuals that would be allowed that activity/class by the type of membership.
2. Be able to pick the membership type on a form and somehow select all attendees at one time with the specific date and time


Any ideas would be greatly appreciated.

Jack
 
Your class/activity attendance is really a Many-Many table, as any one
activity can have many attendees, and any person can attend many activities.

tblPersons
personID - primary key (autonumber)
lastname
etc.

tblActivity
activityID
description
etc.

tblActivityHistory
eventID -primary key
activityID - foreign key (relate to tblActivity)
location
etc.

tblAttendance
attendID -primary key
personID -foreign key (relate to tblPersons)
eventID - foreign key (relate to tblActivityHistory)
etc.

Construct a data entry form with [Activity] info on the main form and the
[Attendees] on the subform in datasheet mode. You should be able to use
your Persons table to lookup any existing person for data entry of
attendance for each person. Display the names in a combobox, limited to
list, but use the personID for bound entry. This will allow quick data
entry of attendees from a sign-in list. A query of all four tables will
show the names of people attending a particular event, along with the event
info, and would be the record source of most attendance reports.

Other main/subforms could be used to show attendance history for a
particular individual, and/or event history for any particular activity.
-Ed
 
Back
Top