Activity 1.4. Copying Access Data to a Word Document
Copy and Paste are Windows tools. In this activity you will use them to add data from an Access database to a Word document.
1.
Start Word. Open the Word file Meeting_Topics.doc from the folder that contains your project files. Save the file as Meeting_Topics_Firstname_Lastname
[Page 1350]
2.
On the taskbar, click the button to return to the Access file, Dept_Data.
3.
In the Access file, on the Objects list for Queries, double-click to open the Salary by Category query.
You can use copy and paste tools to get data from Access and then use it in another Office application.
4.
On the Edit menu, click Select all records. On the Standard toolbar, click Copy, and then on the taskbar, click the button to return to your open Word document.
When you use copy and paste, be sure to locate the correct position in the document for pasting the information.
5.
Find the area of the document under the heading II. Salary Comparisons. At the first blank line after the first paragraph, click to position the insertion point. Press to create another blank line for the information you want to add.
6.
On the Standard toolbar, click Paste.
The data from the Access table is added to the Word document in a table format. You can edit and format it in the same way as you can any other Word table.
Compare your screen with Figure 1.4.
Figure 1.4.
7.
Save your file. Leave the Word document open for the next activity.
Your taskbar should now show buttons for your Access file, your Excel document, and your Word document.