• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Q&A

Q1:What format does my data take when I drag and drop something from one Office product to another?
A1: Office provides excellent intuitive conversions when you combine data from more than one Office product. When you drag a worksheet from Excel to Word, for example, the worksheet becomes a Word table. You then can use all the standard table-editing tools in Word to modify the appearance of the worksheet. Excel converts Word text to text-cell entries. Excel converts Access table data to worksheet cells, respecting the data types when possible (so the numbers stay numbers and the dates stay dates).
Q2:Why would you ever want to copy data and not create a link to another document?
A2: When you copy data, it is copied into the destination document, so the data resides in both the destination document and the source document. If you were to take the destination document to another computer, the document could not access its original link (if you had used a link). In addition, you might not want the destination document's data being hooked "live" to the source data. If you are creating archive files of older data, for example, you want always to copy the data and not form a link or shortcut to the original source data. Keep in mind that if you do copy or paste the data instead of forming a link, and if the data changes in its original location, the copied data will not reflect that change.
Q3:Why wouldn't you import a complete database into Word?
A3: A complete database contains tables, queries, reports, forms, macros, and modules, and all those items make little sense in a Word document. If you need to report data using the entire Access database, use Access to generate reports. Word is useful for printing database subsets. If you want to include part of an Access database table in a Word report, you can easily send the table's data into Word using the tools described in this lesson.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint