Find Jobs
Hire Freelancers

Access 2007 Database

$30-250 USD

In Progress
Posted over 11 years ago

$30-250 USD

Paid on delivery
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
Project ID: 3986322

About the project

5 proposals
Remote project
Active 11 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
5 freelancers are bidding on average $210 USD for this job
User Avatar
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
4.5 (140 reviews)
6.0
6.0
User Avatar
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
5.0 (15 reviews)
3.9
3.9
User Avatar
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.0 (0 reviews)
0.0
0.0
User Avatar
Access Developer Here, I can Build the user friendly database, check PM
$100 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 bid. Thanks.
$250 USD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Battle Creek, United States
5.0
3
Payment method verified
Member since Nov 15, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.