HOW DO I TRACK ATTENDANCE

[Guest]

I run a church youth group, and we have created a DB for the students we
have. What we want to create is a way to run a report that tells us ( who
hasn't been in 3 months, 6 months) Im pretty good with the report part of the
database, But am have trouble creating the attendance part. ie...All i need
is to track Wed attendance and sunday attendance, what kind of table to
create, and who to enter the information(form)
Any help would be great
thanks

 

[Guest]

I MEANT WHERE TO ENTER THE INFO NOT "WHO"

 

[Douglas J Steele]

Ideally, you need 3 tables: one that holds 1 row for each person whose
attendance you're tracking, one that holds 1 row for each event you're
tracking attendance for, and a third that represents the intersection
between those two (since the relationship between the first 2 tables is a
many-to-many).

Typically, you'd have a form with a subform. Depending on how you want to
record the attendance, you could have either the people or the events as the
recordsource for the main form. The third table would be the recordsource
for the subform, and whichever table you haven't already used could be the
row source for a combo box on the subform. You'd select the appropriate
person (or event) on the main form, and the subform would should you all of
the events that person has attended (or people that have attended that
event). You'd have a combobox on the subform that would let you indicate
additional events for the person (or additional people for the event)

Take a look at the list of resources Jeff Conrad has related to database
design at
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html#DatabaseDesign101