Project Detail

Excel access to database  

Excel access to database is project number 335596
posted at Freelancer.com. Click here to post your own project.

 

| More Free Trial For New Buyers
 

Status:

Selected Providers: ServiceQuality

Budget: $30-250

Created: 10/28/2008 at 22:19 EDT

Bid Count: 20

Average Bid:
$ 108

10/29/2008 at 22:19 EDT

Project Creator: john58
Employer Rating: 10/1010/1010/1010/1010/1010/1010/1010/1010/1010/10 (1 reviews)

Bid On This Project
 

Description

This is probably a simple question to answer, but I don't have the answer. I am not a programmer, but can do the basics of creating an MS Access table, and do some creation work in Excel and Word.
I have a document in Word which is an invoice. It is linked by mailmerge to an Access table. The invoice does calculations for a rental bill. I need to send out rental bills to 6 rentors. First I enter data into MS Access. This data changes somewhat each month. Then I open the Word document and move from record to record confirming that the bills are filled out and calculating correctly. Then print copies and send the bills out.

Here are my questions which I have not been able to find answers for on the web. The answers may be simple but I have spent too much time already trying to find them.

1. Can I use an Excel document to make calculations and move from record to record in Excel and have the data supplied from my table in MS Access? I would rather use Excel than Word, but Excel doesn't seem to have a mailmerge type of functionality.

2. Could I instead use Microsoft Office Accounting Express to do this billing? I want to have one invoice that does all the calculations and moves from record to record just like in Word.

I just need someone to tell me what the options are, if additional software (such as add-ins) is needed, or if I should just stick with the current working method of using Word, mailmerged to Access. For this information, I am willing to pay someone. I send out 6 bills each month to 6 different rentors. Each bill looks similar, but has different figures. I have also created 6 Excel workbooks, but this means I have to enter data into each one individually, and it would be easier to enter the data into a table in some database, whether Access or some backend database in an already existing program like MS Office Accounting, which I have.

Thank you.

Messages Posted:3 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

 

150

2 days

10-29-2008 01:37 EDT

Hello - It can be done in excel using Access as the data base. Please refer to PMB.

help

 

100

1 day

10-28-2008 23:57 EDT

See PM for details

help

 

80

2 days

10-29-2008 06:47 EDT

yes, this can be done as a one button automation. simply, excell is not made to do database operation. even if you can import/link data from acces, it's easier to make all calculations in access and then lauch the mailmerge from word. if the bill layout changes a lot between customers, we can even build the word document dynamically from access. everything is possible, but the simplest is the best...

help

 

90

3 days

10-29-2008 00:17 EDT

Please see PM

help

 

30

3 days

10-29-2008 13:20 EDT

We are sending some answers and recommendations in a Private Message.

help

 

199

10 days

10-28-2008 23:01 EDT

(No Feedback Yet)

I can do it.

help

 

150

5 days

10-28-2008 23:16 EDT

(No Feedback Yet)

You said you already have a database with information for the invoices right? It is very easy to transfer data from access to excel. If you choose me, just describe in detail what you need, and I guarantee you will be satisfied with the outcome. Hope we can work together.

help

 

30

1 day

10-29-2008 00:19 EDT

(No Feedback Yet)

Hi! See PM for details.

help

 

150

3 days

10-29-2008 00:41 EDT

(No Feedback Yet)

You can use VB6 then output report to excel. But I'd rather suggest to use VB6's datareport for your mailmerge requirement. I can do this in 3 days. Just send me the format of your billing and the structure of your access database. I will send you the program and you only pay when satisfied.

help

 

30

5 days

10-29-2008 01:13 EDT

(No Feedback Yet)

i can give support as per your requirement

help

 

30

1 day

10-29-2008 03:25 EDT

(No Feedback Yet)

It would be better if you create a report in Access that does the calculations. The report would be your invoice, doing away with Word altogether. I could this if you're not sure how.

help

 

150

3 days

10-29-2008 07:15 EDT

(No Feedback Yet)

I will write a program for your access database. You can input, check your data and print your invoice.

help

 

80

2 days

10-29-2008 07:21 EDT

(No Feedback Yet)

hai just send me your data structure and report format you will be satisfied

help

 

150

4 days

10-29-2008 07:34 EDT

(No Feedback Yet)

Hi, The answer of your first question is yes while some import might be require. I don't know nothing about Microsoft Office Accounting Express. The price I quoted here is for making a program that can import the data directly from your access database/excel and do the calculation and generating shipping labels when you need to. If you are willing to pay $550 I can provide a program of front-end solution with every part of your work covered. Please note that no deposite is required, you do not have to pay for my program until it is working and you are satisfied with it. Best regards, cuitw

help

 

50

3 days

10-29-2008 08:11 EDT

(No Feedback Yet)

• Layout Designing Expert Adobe Photoshop, Adobe Illustrator & Macromedia Freehand, Publishing Expert Macromedia Freehand, Corel DRAW, Adobe Photoshop, Adobe Illustrator, Adobe Acrobat & Adobe Streamline, QuarkXpress, Web Design Intermediate Photoshop, Flash & Dreamweaver. Inpage, Miscrosoft Office 98/2003 (Word/Excel/Access Power Point) Windows 98/2000/XP/Vista/Mac , Animation Intermediate Macromedia Flash, Adobe Image Ready,

help

 

150

7 days

10-29-2008 09:45 EDT

(No Feedback Yet)

I am a software programmer and make all it automized. You have to enter only figures rest the part will complete autometically.

help

 

100

2 days

10-29-2008 10:11 EDT

(No Feedback Yet)

I am intrested in this projet please contact me. I have my team of 3 people to work here in my company

help

 

150

2 days

10-29-2008 12:16 EDT

(No Feedback Yet)

It is very simple and easy project for me, the solution is in the excel VBA, VBA can retrive the MS Access data into excel sheet of any custom format and you can see 1 by 1 record through excel templete, and can generate multiple sheet of all bills. you can depend on me.

help

 

100

10 days

10-29-2008 14:18 EDT

(No Feedback Yet)

I can do it.

help

 

200

3 days

10-29-2008 14:55 EDT

(No Feedback Yet)

I am an accountant that now does access database development so I can develop what you need in Access/Excel as well as keep the accounting aspect in mind. Thank you!!

help


    Bid on this Project