A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

stewardship/charitable church contributions



 
 
Thread Tools Display Modes
  #1  
Old April 14th, 2009, 05:09 PM posted to microsoft.public.access.tablesdbdesign
Sewingmom
external usenet poster
 
Posts: 8
Default stewardship/charitable church contributions

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/ca...product/co.gif

we are looking to record by envelope numbers/names


  #2  
Old April 14th, 2009, 07:26 PM posted to microsoft.public.access.tablesdbdesign
Fred
external usenet poster
 
Posts: 1,451
Default stewardship/charitable church contributions

Your application is very simple but very specialized.

Maybe someone knows of a template.

Do you know / are you looking to learn Access? Or, are you seeking to avoid
that? If it's the former, this might be a good one to do yourself....to
start with, post and ask for recommendation on a table structure.


  #3  
Old April 14th, 2009, 07:46 PM posted to microsoft.public.access.tablesdbdesign
Sewingmom
external usenet poster
 
Posts: 8
Default stewardship/charitable church contributions

so does anyone know of a template?

"Fred" wrote:

Your application is very simple but very specialized.

Maybe someone knows of a template.

Do you know / are you looking to learn Access? Or, are you seeking to avoid
that? If it's the former, this might be a good one to do yourself....to
start with, post and ask for recommendation on a table structure.


  #4  
Old April 14th, 2009, 09:18 PM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default stewardship/charitable church contributions

On Tue, 14 Apr 2009 09:09:04 -0700, 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/ca...product/co.gif

we are looking to record by envelope numbers/names


I've got a church membership database that I donate to those who ask... but it
doesn't presently have a contributions tracking table. It would be easy to add
one, but my time's sort of stacked up at present. If you'ld like to contact me
offline at jvinson at wysard of info dot com (edit out the blanks and fix
the punctuation) I'd be willing to discuss schedules (the price is right, $0).

--

John W. Vinson [MVP]
  #5  
Old April 15th, 2009, 05:13 AM posted to microsoft.public.access.tablesdbdesign
BBC via AccessMonster.com
external usenet poster
 
Posts: 39
Default stewardship/charitable church contributions

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/ca...product/co.gif

we are looking to record by envelope numbers/names


--
Thanks
Brian

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

  #6  
Old April 15th, 2009, 09:19 PM posted to microsoft.public.access.tablesdbdesign
Sewingmom
external usenet poster
 
Posts: 8
Default stewardship/charitable church contributions

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/ca...product/co.gif

we are looking to record by envelope numbers/names


--
Thanks
Brian

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


  #7  
Old April 18th, 2009, 05:14 PM posted to microsoft.public.access.tablesdbdesign
Bob Waggoner[_2_]
external usenet poster
 
Posts: 80
Default stewardship/charitable church contributions


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/ca...product/co.gif

we are looking to record by envelope numbers/names


--
Thanks
Brian

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


  #8  
Old April 18th, 2009, 07:53 PM posted to microsoft.public.access.tablesdbdesign
Sewingmom
external usenet poster
 
Posts: 8
Default stewardship/charitable church contributions

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/ca...product/co.gif

we are looking to record by envelope numbers/names

--
Thanks
Brian

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


  #9  
Old April 19th, 2009, 09:05 PM posted to microsoft.public.access.tablesdbdesign
Bob Waggoner[_2_]
external usenet poster
 
Posts: 80
Default 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/ca...product/co.gif

we are looking to record by envelope numbers/names

--
Thanks
Brian

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


  #10  
Old April 20th, 2009, 12:10 AM posted to microsoft.public.access.tablesdbdesign
Sewingmom
external usenet poster
 
Posts: 8
Default stewardship/charitable church contributions

that sounds great. If no one else is using it then I will be glad to take
off your hands, how much did you say?





"Bob Waggoner" wrote:

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/ca...product/co.gif

we are looking to record by envelope numbers/names

--
Thanks
Brian

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


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:53 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.