Integrating Excel with Word & Integrating Access With Word & Excel?

Question

I know nothing about Access and very little about Excel or Word. I do know that all these Microsoft Office applicatons are well integrated, so I need a couple examples of a business office need that would benefit from the following:
1) Integrating Excel with Word
2) Integrating Access with Excel
3) Integrating Access with Word

Right off the line, let me thank you for your help. It is much appreciated.

No really looking for extended explaination. Just a couple of examples of who they are used in each other, thats all. Thanks

I mean NOT really looking for an extended explaination & already have book, but book is not giving me the answer. Thanks

Answer 1

I work with all three applications most of my time at work (I'm a technical writer and trainer) and have integrated them at one time or another. It is handy!

1) You can copy a range of cells from Excel and paste them into Word, retaining the columnar format. It is much easier to create formulas in Excel than Word, so do all your math there before you import it into Word.
2) The datasheet in Access is very much like a spreadsheet in Excel, but you can perform much more complicated sorting and searches in Access. Do all your database work in Access, then copy and paste the results into Excel to compliment your spreadsheet.
3) The same with using Access info in Word - do all your sorting and searching in Access, then copy and paste the results into Word to illustrate a report, for instance.

Answer 2

Integrating Excel And Access

Answer 3

1) Integrating Excel with Word
Data in Excel can be merged with Word for Mailings lists, form letters, envelopes, etc. I often will copy a header row out of Excel, format it Word and paste it back into Excel. I know you can do it formulas and macros which I mainly do, but sometimes this ways is faster You can can also copy tables from Excel and paste the tables in Word. This is great when a recipient may not have Excel. Almost a all computers now a days come with Word but not Excel, which is an additional cost, so I do find this useful

2) Integrating Access with Excel
The absolute best feature is that you can have your database in Access, run queries and make tables. You can then analyze and manipulate the data in Excel either by exporting your tables or using using the Analyze button on the toolbar. I imported a table from Excel into Access as was able to do a query and then analyze the final results in Excel. Doing the query in Excel would have taken me hours because I would have to manually examine the data and correlate my results. I had the project done in abut 45 minutes. Another difference is between Excel and Access is that Access can hold much, much more data.

3) Integrating Access with Word
You can export data tables such as an name, address, etc., to Word for merging things like form letters, envelopes, etc. Although you can do this in Access, I find it extremely clunky.
You can also export your data into Word and then you will have much flexiblity with formatting. The toolbars are more intuitive when formatting a Word document.

Answer 4

Integrating Excel with Word (or access-excel,..) means to use both application in the same project or simply in the same file document or sheet
For example, in document file you can insert a tablet from excel.

Answer 5

Excell allows you to have an instant adding machine feature and can ordinate lists easily. I use it exclusively for my business billing etc. You would benefit greatly by reading a book about the various MS programs. No one can go into a 90-500 page treatise on how and why for your questions.

Answer 6

a million (A) - be conscious, Excel, PowerPoint 2 (C) - Is rapidly assigned because of the fact the regular key 3 (A) - are seen to each reviewer. 4 could be its (B) - absolute cellular reference. 5 (D) - =C4*$G$18 6 (D) - varieties. 7 Dont understand i can't in a position to work out your 8th question.