Sedang Disiapkan

Excel access to database

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.

Kemahiran: Perakaunan, Pemprosesan Data, Excel, Destop Windows

Lihat lebih lanjut: what does an it programmer do, send an invoice, programmer rental, programmer of software need to find one, processing find programmer, office web accounting, office basics, need to find programmer, need of excel programmer, ms excel programmer, ms access programmer, microsoft excel software, microsoft excel programmer, microsoft access web database, me excel, i need to find a programmer, i need a ms access programmer, find ms office programmer, find a windows programmer, find a programmer on the web, find an excel programmer, find a database programmer, excel &, billing microsoft, bill in accounting

Tentang Majikan:
( 3 ulasan ) Keaau, United States

ID Projek: #335596

Dianugerahkan kepada:

ServiceQuality

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

$30 USD dalam 3 hari
(1 Ulasan)
1.0

20 pekerja bebas membida secara purata $108 untuk pekerjaan ini

agihcam

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

$150 USD dalam 2 hari
(40 Ulasan)
5.2
mahfuzmurshed

Please see PM

$90 USD dalam 3 hari
(64 Ulasan)
4.5
cnut17

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 m Lagi

$80 USD dalam 2 hari
(4 Ulasan)
4.2
Abikris

See PM for details

$100 USD dalam sehari
(5 Ulasan)
2.5
Shoaibik

I can do it.

$199 USD dalam 10 hari
(0 Ulasan)
0.0
cuitw

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 d Lagi

$150 USD dalam 4 hari
(0 Ulasan)
0.0
gaurangt9

I can do it.

$100 USD dalam 10 hari
(0 Ulasan)
0.0
ashiruddin

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 genera Lagi

$150 USD dalam 2 hari
(0 Ulasan)
0.0
leenaam

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

$100 USD dalam 2 hari
(0 Ulasan)
0.0
pvccpr1965

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

$150 USD dalam 7 hari
(0 Ulasan)
0.0
sameerjeez

• Layout Designing Expert Adobe Photoshop, Adobe Illustrator & Macromedia Freehand, Publishing Expert Macromedia Freehand, Corel DRAW, Adobe Photoshop, Adobe Illustrator, Adobe Acrobat & Adobe Streamline, QuarkXpress, Lagi

$50 USD dalam 3 hari
(0 Ulasan)
0.0
ebedsat

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

$150 USD dalam 3 hari
(0 Ulasan)
0.0
sureshnair282

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

$80 USD dalam 2 hari
(0 Ulasan)
0.0
jsnolasco

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 Lagi

$150 USD dalam 5 hari
(0 Ulasan)
0.0
jweinke

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.

$30 USD dalam sehari
(0 Ulasan)
0.0
sureshyd

i can give support as per your requirement

$30 USD dalam 5 hari
(0 Ulasan)
0.0
romytiu

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 a Lagi

$150 USD dalam 3 hari
(0 Ulasan)
0.0
mrkibria

Hi! See PM for details.

$30 USD dalam sehari
(0 Ulasan)
0.0
mnash0915

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!!

$200 USD dalam 3 hari
(0 Ulasan)
0.0