Em Andamento

Mods to a MS Access Database

I work with a non-profit organization. We have an Access database of donors over the years, and records of each donation received from each donor. Currently, as we receive each donation the staff updates the database to record the donation, and then manually prepares a "thank you" letter to the donor in MS Word. They have ten different letter templates they fill in based upon the type of donation.

I need the Access database modified to automate the production of these letters. Basically, the staff would enter the new record of the donation, and then click a button on the record to produce one of the pre-formatted letters (that I will send you) with the data (name, address, amount, etc) filled in from the donation record. The letter needs to be formatted to fit our letterhead. Finally, some donations are from businesses and some are from individuals. The grammar and structure of the letter is slightly different for an individual versus a business, and this would need to be accounted for. The donor records do not differentiate between the two, and it would be fine if the staff picked as part of producing the letter.

Additionally, the staff needs to be able to select some of the donors in the database and produce a batch of envelopes printed with the donor's address (from the database) to mail these letters. The envelopes would be done in a batch after several letters are produced since they have to go change letterhead to envelopes.

Finally, the general content of the pre-formatted letters changes periodically to reflect the name of a production or campaign, so the staff would need to be able to update the letter templates on the fly.

Habilidades: Microsoft Access

Ver mais: different type data structure, database one word two, campaign letterhead, microsoft access business, mail access, letters a, fly, work database letters, work non profit organization, changes data access, database templates microsoft access, microsoft access business templates, fill database word, production access microsoft, letter change address, change address letter, access business templates, access templates business, microsoft word letterhead templates, letterhead templates microsoft word, askjoshbrooks, letterhead templates microsoft, pre database, access production, microsoft access production database

Acerca do Empregador:
( 2 comentários ) Manassas, United States

ID do Projeto: #6794918

Premiar a:

rsliter

Hi - I'm new to the freelancer website and am looking to begin building a strong online reputation and client base. I'm much more interested in developing a long term relationship with you and getting a great rating o Mais

$155 USD em 3 dias
(0 Avaliações)
0.0

35 freelancers estão ofertando em média $175 para este trabalho

illuminesoft

We are amongst Top 1% Outsourcing Providers worldwide. We have successfully finished over 450 projects in last 13 years. ID : 6794918 Greetings, We are interested to work on this project, please find my comments Mais

$611 USD in 12 dias
(239 Comentários)
7.4
Premshanks

This is my proposal a) I shall give you MS Access menu based solution where your staff can maintain the template master i.e., template name, Path of the MS Word document. b) In the donation screen - we can add a Mais

$110 USD in 3 dias
(194 Comentários)
6.1
fabest

Dear, I am Access/VBA expert since 11 years. I checked your project description, and I confirm I can develop your Access DB. I will focus on user friendly interface. As you can see I have very good rate, you can b Mais

$108 USD in 3 dias
(21 Comentários)
5.3
abdellatif81

Hello, I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 8 years of experience working around Microsoft database (Access ,Sql Se Mais

$133 USD in 4 dias
(9 Comentários)
4.9
shadowdancerlv

I intend to use VBA to perform programmatic mail merge to the word documents based on selections made in the UI. I've done this for over a decade so I'm 100% certain about succeeding on this project. One large chunk o Mais

$263 USD in 14 dias
(4 Comentários)
4.9
customizedata

I have gone through the details. What i would suggest is we make a separate setup form for various letter templates. Form contains 1- letter template name. 2- letter template On the donation form we can have Mais

$200 USD in 7 dias
(26 Comentários)
4.4
paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a database. I have 7 years’ experience designing and developing Access databases. I would approach your project by creating a draft Mais

$150 USD in 6 dias
(14 Comentários)
4.3
dipakmoliya

Hello! I have been in this industry for 6 years and such jobs are my daily practice. I can assure you that if you work with me once, you will always work with me for these kind of projects. I have been read your Proj Mais

$123 USD in 3 dias
(24 Comentários)
4.3
NeilSargent

I am an expert in Microsoft Access with 17 years’ experience and particular skills in VBA and integrating Access with Excel, Word and Outlook. I developed a similar database for the UK charity, The Children's Family Mais

$250 USD in 10 dias
(3 Comentários)
3.9
acronymsolutions

Hi, I have gone through your requirements,I am a Database programmer at CMMI-5 Level company since August 2004.I am working on MS Access, Shell Script,PL/SQL,T-SQL,MySql,MSSQL Server,Oracle database, I can do your job Mais

$225 USD in 7 dias
(5 Comentários)
3.7
smb310570

Give me your MS Access database and all the MS Word letter templates which you want to print. I will add the functionality in MS Access database, on just a click of button, to make the LETTERS and ENVELOPS in MS W Mais

$150 USD in 7 dias
(14 Comentários)
3.3
sonarkaushik

Sir, I am well versed in this kind of jobs and can do your project as per requirement. Refer my online work portfolio at [url removed, login to view] Looking for further discussions in this regard. with than Mais

$155 USD in 5 dias
(3 Comentários)
2.9
sflogics

Hi, We’ve had a good look at your project description and we’re very interested in providing a solution. We are a professional development company head-quartered in Pakistan. If you like what you see and if our qu Mais

$200 USD in 3 dias
(1 Comentário)
2.6
milanmartinjuk

Hi, Your project sounds simple enough and I believe that I'll be able to perform the task perfectly, considering that I've done a lot of these for my own use. You're welcome to check my reviews and should you hav Mais

$111 USD in 3 dias
(1 Comentário)
2.0
nksundaram

Experienced software professional with 20 years in design, development and maintenance of large enterprise level applications. I have something similar where given a word document, the data can be filled in from acc Mais

$155 USD in 10 dias
(2 Comentários)
1.8
vsprybhanu

Hi, Experienced MS Access VBA, VB6 and [url removed, login to view] Programmer. Expertise in Data Entry, Data Processing, MS Access, Excel and Programming. Read and understood your project description. I use MS Access databa Mais

$45 USD in 3 dias
(2 Comentários)
2.0
JohnABC

Thanks for the opportunity to bid on your project. Please feel free to contact me about the below brief using the “discuss project” button under this bid! I am a data analyst who works for a major public department. Mais

$65 USD in 5 dias
(2 Comentários)
1.6
tandonshailendra

Understand you need Access 2007/2010/2013 based offline solution. You being non profit organization I shall keep my charges to minimal. I am sure there must be frequent donors. As such you would like to keep separate t Mais

$100 USD in 5 dias
(1 Comentário)
1.4
bgriffin001

I have been doing Access for many years. I already did this same DB for a christian food bank in Toronto..Carleton is this you? I have a great deal more experiece than anyone else you will find here. My clients NAS Mais

$111 USD in 3 dias
(1 Comentário)
1.0
bspanovic

Hello Similar projects have already been implemented, and I have experience with them. I'm Microsoft Certified Database Developer & Administrator. I working with Microsoft Access since it first version. I hav Mais

$197 USD in 14 dias
(1 Comentário)
0.4