In Progress

Access 2007 Database

EXECUTIVE SUMMARY: We need an easy to use, easy to navigate and edit Access 2007 Database (or something compatible) created to keep track of donors, donations and the prisoners (if applicable) they are sent in support of. We also need to track inventory we offer as thank you gifts (consisting of hundreds of book entries). We need this info to be easily merged into MS Word documents without a lot of query codes I need to be instructed in how to use it if necessary. You will create the database and easy to use query codes in an easy to use format you can explain to me how to use.

OPERATIONS OVERVIEW: Promise Ministries International is a Michigan based, Christian non-profit Bible college level ministry to American prisoners supported by the tithes and offerings of those who believe in what we are doing. Our student applicants provide us with names and address of friends and relatives that we contact through 4 or more different fundraising letters we send in a series. Each letter we send has the prisoner's name and a FREE book offer with each donation which we need to track when sent. We want to track these letters and dates sent to donors along with any free books we send to either the donor or prisoner in response to the letter.

When money arrives, it is usually (not always) designated for a particular prisoner and is to be used to provide that student with any of the following: enrollment into or payment for one of our 5 separate Bible study programs (we are developing more); or they are purchasing a particular Bible or book (we have hundreds); or to pay for a degree; or any other miscellaneous purpose. We need to be able to quickly edit these.

Track donor info w/unlimited expansion:

Donor ID

DonorFName

DonorLName

Doc# [prisoners send offerings, too and they have dept of correctons numbers]

Address1

Address2

City

ST

Zip+4

HPhone [home phone]

CPhone [cell phone]

Email

PrisonerFName

PrisonerLName

Relationship [Options: son, daughter, husband, wife, father, mother, friend in Christ, friend, and option to add others if necessary]

DonationAmount

DonationDate

DonationTotal [to track each donation along with ability to track totals by day, week, month, or year(s).

WHAT I NEED: I need queries created to export specific data from the database to be used in an MS Word mail merge:

When the mail merge is executed, I want to pick a donor from the database, and a date. The query will give me all the donors' details (name, address, etc) and calculate the total donations made by the donor. I would like those totals to be separated into daily, weekly, monthly and yearly donations totals, based on the date I selected at the start.

EASY MAIL MERGE INTO WORD 2007: we send 4 separate fundraising letters to donors that we need to track with the letter sent [we use a code for them] and the date sent to the donor.

We also send 12 separate thank you receipts to donors that we often edit. We need to track these [we use a code for them] with dates we sent them to the donor along with any books or literature we sent as a thank you gift to them.

I also want to be able to print mailing labels or envelopes and/or lists of selected donors, gift dates, gift amounts, prisoner names, groups, etc from MS word

Print donor directory from Word

Skills: PHP, Software Architecture

See more: thank you letter format, thank you letter email, ms. international, ms international, email support executive, edit books from home, daily access, american software, architecture programs, summary of books, student database, operations inventory, ms access email, ministry, Michigan, mail access, hphone, executive summary, database receipts, college database, software calculate profit, book offer, prisoner, word merged, letter purpose

About the Employer:
( 3 reviews ) Battle Creek, United States

Project ID: #3986322

5 freelancers are bidding on average $210 for this job

finecodervw

Is it ok to make this as desktop based application. I am very keen to work on the project. Thanks.

$250 USD in 15 days
(140 Reviews)
6.0
thusitcp

hello sir, I can start this task asap. I can understand your requirement and has a ability to deliver high quality work thank you. thusitcp

$200 USD in 3 days
(15 Reviews)
3.9
S9oF76ZMb

Custom software development: w w w . The Administrator removed this message for containing contact details which breaches our Terms of Service . i o

$250 USD in 1 day
(0 Reviews)
0.0
logu85

Access Developer Here, I can Build the user friendly database, check PM

$100 USD in 5 days
(0 Reviews)
0.0
cfetterolf

Good evening, I know this project can be easily accomplished with a .NET WPF project with an SQL backend database. This kind of app will install on your desktop and have a user friendly interface. Please consider my More

$250 USD in 10 days
(0 Reviews)
0.0