Church database

tmarsh said:

I keep track of church members' weekly giving using a works database and I want to use access but I'm having trouble with sorting the structure. I have one table holding personal details but I'm not sure how to set the giving table.

tb_main - name, address etc.
tb_offerings - envelope no, week no, date, amount

Members give using an envelope system so I person has one envelope. One envelope has many amounts and dates. Also, I would like to archive data after a few years.

I've looked through some posts here but none address this exactly.

Any suggestions please?

Thanks.

Click to expand...

mhartman said:

Hello:

The enclosed link below has a complete data model for churches. It even includes the offerings portion. You can modify this to your needs

http://www.databaseanswers.org/data_models/church_members/index.htm

Regards
Mark

Click to expand...