Re: stewardship/charitable church contributions

50 entries is one service - even at a little church (I know, I pastored a
little church). I wrote the database still in use at Dyess AFB, Texas. [Call
the chapel there and talk to Yvonne].

Tables include: [tblTithes&Offerings] and [tblNames]

Tithes&Offierings fields include: [LiChkID] (autonumber primarykey);
[LiCheckNo] (Long Integer for recording the number on the check or envelope);
[txtLastName] (txt field); [txtFirstName] (txt field - you can rejoin the
names in queries or reports later but keeping them separate helps sorting
issues); [CurAmount] (currency field for amount of check or cash offering);
[dteDate] (Date on the check or today's date if cash - set the default to
Date() and then just change it as needed). You can add any other fields you
want. [Also, you could create a simple code for the date field that will put
in today's date with a double-click event if you don't want it to be the
default for the record you create.

If you are not familiar with Access Queries, reports and / or VBA - I'll be
happy to walk you through (using this forum) writing queries and reports to
extract just the information you need. It's a great learning experience and
not very complicated. Plus, it's a lot cheaper doing it yourself than paying
for something off the shelf that goes overboard.



"Sewingmom" wrote:

thanks for all the help i found one that will work for now. It only allows
up to 50 entries before we have to start paying though.
it is called church trac. It is very good I just hate that we will have to
pay later


"Bob Waggoner" wrote:


I wrote a database for the Air Force chaplain service that will do what you
want.
You're welcome to it. It tracks contributions and creates reports to send to
contributors regarding their annual contributions.
It also tracks attendance and has a few other features. The person using it
was not a database expert when I wrote it.

Maybe someone can tell me how to contact sewing mom without either of us
getting inundated with junk mail.

RC W
"Sewingmom" wrote:

that does sound a bit overkill for what we need but thanks.

"BBC via AccessMonster.com" wrote:

I am in the process of developing a DB for a charitable organization
(supporting children & families in Africa). It is not ready for final
release but is about to start inital user testing. It is fairly complex and
might be overkill for your needs, "manages" clients (demographics),
contributions, child or project sponsorships, events/projects (ex fund
raisers), client interests, and will have a very basic product inventory and
sales component.
Would Excel do what you need.


Sewingmom wrote:
does anyone know of a free program that i can use for recording my church
contributions for a little church? There are some good programs out there
but right now we don't have the finances to purchase, they are so expensive.
I would love one that is somewhat close to this example.
http://www.powerchurch.com/images/captures/features_product/co.gif

we are looking to record by envelope numbers/names

--
Thanks
Brian

Message posted via http://www.accessmonster.com


.

Relevant Pages

  • Re: stewardship/charitable church contributions
    ... I wrote a database for the Air Force chaplain service that will do what you ... It tracks contributions and creates reports to send to ... "Sewingmom" wrote: ...
    (microsoft.public.access.tablesdbdesign)
  • Church Organizer Pro 1.7
    ... Church Organizer Pro is a flexible database management software with ... ready to use church membership management solutions. ... ready-to-use church member management solutions make it easy to set up ... Complete database template that gives you an easy way to ...
    (comp.software.shareware.announce)
  • Re: Orphans
    ... >nothing about the church affiliation of a Person or Family. ... >Family can make multiple Contributions to the same Church or multiple ... >Churches in the same Batch. ... FamilyID, both as foreign key, both nullable and with a CHECK constraint ...
    (microsoft.public.sqlserver.programming)
  • Re: Orphans
    ... > A Batch can own one or more Churches ... > A Church owns People and Families ... does "A Church owns People and Families" mean? ... Each person and each familiy is allowed to make multiple contributions ...
    (microsoft.public.sqlserver.programming)
  • Re: PK & FK problems in data consolidation
    ... related to member table as one to many. ... In order to have a memership report by church, by regional, by Union, by ... I have sent you my database thru your email and explained my problems, ... The Affiliation table brings ChurchID, RegionID, UnionID and DivisionID together. ...
    (microsoft.public.access.formscoding)