Prev: church member database
Next: System for Analyzing a database
From: bhrosey via AccessMonster.com on 4 May 2010 17:31
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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/201005/1

From: PieterLinden via AccessMonster.com on 4 May 2010 20:42
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.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/201005/1

From: Fred Boer on 4 May 2010 22:52
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!
--
Fred Boer - Amateur Access Enthusiast
Interests: Library software / Z39.50 / Web Services
Freeware Small Library Application available here:
http://www3.sympatico.ca/lornarourke/


"bhrosey via AccessMonster.com" <u33878(a)uwe> wrote in message
news:a784b68c70ee6(a)uwe...
>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
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/201005/1
>


 | 
Pages: 1
Prev: church member database
Next: System for Analyzing a database