Attendance Tracking

[bhrosey via AccessMonster.com]

I am trying to design a very simple database for tracking attendance of my
church's youth group. We meet weekly and for various events and fundraisers.
I want to be able to track who attended each week or each event. I would
also like to use it to be able to print out contact info (phone, email, etc...
) So far, all I have is Tbl_Students and a form to enter in their
information. Please help.
ps. John Vinson, if you see this could you please email me a copy of your
church member database? thanks

 

[PieterLinden via AccessMonster.com]

Attendance designs are generally

Event---(1,M)---Attendance---(M,1)---Person

Then Attendance is something like
EventID, PersonID, Attended (Y/N)

I'm pretty sure there are attendance-type databases all over the place...
I've seen similar questions many times here.

 

[Fred Boer]

Hi:

I have a teacher "daybook" application I wrote using Access 2003. It can
track class attendance, and it might help give you one idea on how to
approach this. You can click on a "Build" button, and a checklist of
students is produced for each class.

I'd be happy to share, but I cannot publish new material to my website (as
listed in my signature), since I've had to change ISPs and my new ISP does
not provide a web page. (My old ISP has yet to kill my webpage!.. <g>)

If you are interested, the website listed in my sig provides my email
address.

Cheers!