Simple Database

theserginhus

Registered User.
Local time
Today, 05:41
Joined
May 25, 2004
Messages
12
Hello. I am trying to create a database where I can enter contributions from members of my church, in order to give them report at year's end. We are small number, about 70, but we collect offerings every Sunday. I tried on my own, but did not achieve much. I searched about many-to-many and many-to-one, but still don't get it right. Can someone help me with the simple structure and I do the rest? I use person's information (name, etc), amount given and date of offering.
Thanks in advance.:confused:
 
Here is a real simple structure with which I would use a Main form for the member information and a subform for the offering details.

tblMembers
MemberID - Autonumber (Primary Key)
FName - Text
LName - Text
Address - Text
City - Text
State_Province - Text
ZipCode_PostalCode - Text
Phone - Text


tblOfferings
OfferingID - Autonumber (Primary Key)
MemberID - Long Integer (Foreign Key)
OfferingDate - Date
OfferingAmount - Double


Relationships -

tblMembers - - - - tblOfferings
MemberID<------------>MemberID
 
but you probably also need to build in something for gift aid, to gross up the collections where necessary, i would think


so if you use bob's idea, then also add to the members table fields

giftaid y/n
giftaideffective date/time

and also add to the table offerings
giftaid y/n
giftaid_percent double

as you will need these as time goes on - you probably also need a constants table to hold the gift aid rate as eg this year the gift aid is 22%, but next year its 20% - which is why i'm suggesting storing the rate in the offerings table

no doubt you will also need a "member" called "general offerings" or something similar to allow for general collections from members who do not giv individual - ie collection plate

any problems pm me, and i'll help.
let me know which access you are using - all in a good cause


having said all this, i assumed you were in the UK - if not ignore this, as I do not know US arrangements!
 
Last edited:

Doco!!

Good to hear from you!
:)

--------------------
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------
 
Doco,

With my recent move I might have lost contact info. Would you mind sending a message to me when you get a moment? Use the contact form on my web site.

Thanks!

P.S. Sorry for the interruption everyone.
:)
--------------------
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------
 

Users who are viewing this thread

Back
Top Bottom