Relational Database

Closed

Description

I’ve been told that it would be best to use Access to create a database whereby I will fill out an Intake Form that will include many different fields that will then be used to merge and create:

1. An initial letter

2. An Agreement between the business and our company

3. An invoice

4. A reminder email or letter for an overdue account

5. An Invoice for work conducted by an associate

6. A check payable to the associate that conducted the work

7. Various letters (marketing) using a “merge” from the database.

Presently, I have developed these letters, agreements, and invoices in Microsoft Word and Excel.

I’ll need to see which companies have outstanding balances and how old the receivable is, and then generate a facsimile or email (with the invoice attached)

I’ll want to be able to sort and generate reports by the various fields.

I’ll want part of the program to be able to create checks and print them along with an envelope.

If you think this can be accomplished in something other than Access, I’d be pleased to consider other options.

Skills: Data Processing, Excel, Microsoft Access, Word

See more: excel relational database, relational database using excel access, how to create database program, database marketing companies, relational, receivable, old letters, invoice processing , d associate, companies database, Account receivable, account payable, generate reports excel, work database letters, word merge excel, database invoice microsoft access, microsoft excel account, relational database microsoft access, data merge word, create access database reports, microsoft merge, email data access 2013, access 2013 form print, merge excel program, invoice access excel

Project ID: #4218849

Awarded to:

BadihBarakat

+10 years expert in Database Management and VB Programming. Please, refer to private message for details...

$150 CAD in 6 days
(3 Reviews)
2.2

15 freelancers are bidding on average $172 for this job

fastudiovw

I have 20+ years of experience programming ms-access, .net & sql server. At your disposal for any doubt or question, Regards Fabio

$250 CAD in 10 days
(613 Reviews)
7.1
pkcyber

I have an idea for u. Please see ur pmb

$200 CAD in 3 days
(23 Reviews)
5.4
amcsummers

I was doing my contracting work with VWorker for the past 3 years, I had completed 70 projects ranging from Excel VBA to SQL Server database construction. VWorker was sold to Freelance.com in November 2012 so I thought More

$250 CAD in 14 days
(43 Reviews)
5.3
infoshree80

Having More than 15 years of experience in development.Please check Inbox

$200 CAD in 17 days
(15 Reviews)
4.6
expertatwork

Experts here. please see your PMB !

$145 CAD in 4 days
(39 Reviews)
4.4
NourElDeen

Dear Sir, I'd like to do that project. Best Regards, NourElDeen

$135 CAD in 10 days
(24 Reviews)
4.3
www1980

Experienced MS Access and VBA developer. Ready to do this project for you.

$250 CAD in 12 days
(10 Reviews)
3.9
nmlarsath

I am interesting to complete your requirement. its easy job pl see more in PM

$90 CAD in 10 days
(14 Reviews)
3.5
sthakral

Hi Hello, I have expert++ level grasp of MS Access. I'd be happy to discuss further and reach a consensus. A few more details in PMB Best, Sandeep

$200 CAD in 3 days
(2 Reviews)
3.1
epdailo

This can be done in Access or Excel, depending on the amount of Data you have.

$60 CAD in 7 days
(2 Reviews)
2.2
lokeshk9936

Please see PM

$250 CAD in 10 days
(1 Review)
2.2
onlineupdatebd

I am experienced with my skills. Please see PMB.

$150 CAD in 10 days
(1 Review)
0.0
writemedown

Please check your inbox.

$150 CAD in 3 days
(1 Review)
0.0
DaddyWarbucksEsq

My name is George Panko, dba The Immaculate Cohhection. I am relatively new to this freelancer site, but am well-established on Guru.com. Since 2001, I have specialized in designing, developing, and maintaining MS More

$100 CAD in 2 days
(0 Reviews)
0.0