Help, Trying to build a Non-Profit database for my Dad

[Lali1Kanobi]

I need to build a database for a non-profit organization that my Dad's taking
collections for. I need to be able to input data on a monthly basis of:

- How much was collected per month,
- Who the contributors were,
- Some kind of statement indicating the total amount each contributor
donated in a given year, 2 be supplied to each contributor for tax deduction
purposes?

I've started inputing info, but I more than just a little bit dumbfounded as
to how to organize, format the information, into the appropriate tables,
reports, etc . . .

Please help,

 

[Mark]

I provide help with Access applications for a very reasonable fee. I can
create the database for you for a very reasonable fee. If you are
interested, contact me at (e-mail address removed).

Steve

 

[Tony Toews [MVP]]

I provide help with Access applications for a very reasonable fee. I can
create the database for you for a very reasonable fee. If you are
interested, contact me at (e-mail address removed).

Steve Santos is soliciting work again. Please ignore his requests as
these newsgroups are for free assistance.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[John W. Vinson]

I need to build a database for a non-profit organization that my Dad's taking
collections for. I need to be able to input data on a monthly basis of:

- How much was collected per month,
- Who the contributors were,
- Some kind of statement indicating the total amount each contributor
donated in a given year, 2 be supplied to each contributor for tax deduction
purposes?

I've started inputing info, but I more than just a little bit dumbfounded as
to how to organize, format the information, into the appropriate tables,
reports, etc . . .

Please help,

I would suggest the following tables:

Contributors
ContributorID <Autonumber primary key>
LastName
FirstName
<other biographical/contact data such as address>

Contributions
ContributionID <Autonumber primary key>
ContributorID <Long Integer, link to Contributors>
ContributionDate Date/Time
Amount Currency
PaymentType <Text, "Cash", "Check", "Visa", etc.>
CheckNumber (or last four digits of credit card if you take CC)
Comments <reason for contribution, dedication, etc.>
<any other info needed about this specific contribution>

You could use a Form based on Contributors, with a Subform based on
Contributions.

Totals for the month and/or for the year would be calculated on demand using
Totals queries, and NOT stored in any table. You just need the individual
payments stored in the tables. A Report could be sent to each contributor
detailing and/or summarizing their contributions.

 

[John W. Vinson]

I provide help with Access applications for a very reasonable fee. I can
create the database for you for a very reasonable fee. If you are
interested, contact me at (e-mail address removed).

Steve

Beat it, Steve. You're way over the line here. This is a NONPROFIT wanting
FREE HELP - which everyone here *except you* is willing to provide FOR FREE.

You've been sleazy for a long time... and you're going downhill.

 

[Irene]

hi John,

if i follow your instruction to do the database and help Lali1Kanobi, will
you oppose? i have make an "add new contributors" form, add contribution
form. i also have make a report which is group by contributors. if i facing
some question, will you help me to modify?

 

[Irene]

hi Lali1Kanobi,

can u giv me ur email add? i will email u the database. Dun worry, it is
free of charges. hope that the database is suitable for u.

 

[John W. Vinson]

hi John,

if i follow your instruction to do the database and help Lali1Kanobi, will
you oppose?

Of course not! I'm just another volunteer here; I don't (and the other MVP's
don't) "run" the newsgroup. I was slamming Steve because he's NOT acting as a
volunteer.

i have make an "add new contributors" form, add contribution
form. i also have make a report which is group by contributors. if i facing
some question, will you help me to modify?

Sure, just post a description here on the newsgroup. Lots of us will be glad
to help.

 

[Lali1Kanobi]

Thanks to all for your help. Special Thanks to John and Irene. I'm going to
implement your suggestions, and I'll let you know how it goes.

I'm preparing the info for the Miami based Chapter of the Non-profit
organization.

Once I'm done, If I'm allowed to, I'll post the web-site, so you can see
what your suggestions helped create.

Thanks Again,
Lali1Kanobi

 

[Lali1Kanobi]

I'd give you my e-mail, but I'm not sure how to do that without broadcasting
it. I don't know how to reply to you individually. If you know how let me
know and I'll give you my e-address.

Thanks for your Help, it's greatly appreciated,
Lali1kanobi