fundraiser donor database

[Jude]

I need to find an Access database that keeps track of donor information for a
non-profit organization. This would include name, address, etc. Donation
amount, date, donated for ? and a place where I can keep notes. I know
Access can do this but I have almost no experience on Access. Took a class
but was overwhelmed. Would hope someone out there can help. I really don't
want to re-invent the wheel.

 

[Evi]

Depending on what version of Access you have
With Acc2003
You could start with the Personal Address Book template at
http://office.microsoft.com/en-gb/templates/CT101426031033.aspx
and add a table to it, TblDonations. This will have its own Primary Key
then it will have a Number field with the same name as the Primary Key of
the people table (perhaps personID)
You will create a link from the Primary Key of the People Table in the
Relationships window

To Tbldonations you will add fields like Amount, DonationDate.

If you create a Form based on this latter table using the Wizard, it will
probably lead you to create a Main form (based on TblPeople) and a Subform.
Otherwise, we can talk you through this.



If you have Access 2007 then there is no need to do this
there is a Charitable Contributions template at

http://office.microsoft.com/en-gb/templates/CT102512241033.aspx
Evi

 

[Daniel Pineault]

Evi is right if you are ready and willing to do some work and we can all
guide you. That said for a good cause, I am willing to offer my services.
If you are interested simply goto to my website and use the contact form to
forward me your e-mail address and other contact info and we can discuss your
needs a little further.

http://www.cardaconsultants.com/en/contactform.html
--
Hope this helps,

Daniel Pineault
For Access Tips and Examples: http://www.cardaconsultants.com/en/msaccess.php
If this post was helpful, please rate it by using the vote buttons.

 

[Ed Robichaud]

Jude-
I have donation/fundraising/membership databases in Access that you are
welcome to and can
easily modify for your needs. Contact me thru:
http://edrobichaud.com/default.aspx