Microsoft Office Tutorials and References
In Depth Information
Using Access Data in a Word Document
Exporting a Query from Access to Word
To export an Access query, you convert the query into rich text format , a special text for-
mat that preserves the layout of the data. The query becomes a text file with an .rtf exten-
sion, often called an RTF file. You can then insert the RTF file into a Word document.
Now that you have created and saved the Services Requested Query, you can export it
and convert it into an RTF file. Then you’ll switch to the brochure document and insert the
query as a table.
To export a query and insert it into a Word document:
1. Click the Services Requested Query in the Database window to select it, if necessary,
click File on the menu bar, and then click Export . The Export Query ‘Services Requested
Query’ To dialog box opens.
2. Type Services Requested Query in the File name text box.
3. Click the Save as type list arrow, and then scroll to locate and click Rich Text Format .
4. If necessary, click the Save in list arrow to navigate to the Tutorial.02\Tutorial folder
included with your Data Files.
5. Click the Export button. Access converts the Services Requested Query into an RTF file and
stores it in the location you specified.
6. Close the Lifestyles Services database.
Now you will insert the RTF file into the brochure.
7. Click the New Services Brochure - Microsoft Word button on the taskbar. The brochure
appears in the Word window.
8. In the New Services Brochure document, scroll to page 3, and then click in the empty para-
graph above the second paragraph.
9. Click Insert on the menu bar, and then click File . The Insert File dialog box opens.
10. Click the Files of type list arrow, and then scroll to locate and click Rich Text Format .
11. Click the Look in list arrow, and then navigate to the Tutorial.02\Tutorial folder included
with your Data Files, if necessary.
12. Click Services Requested Query , and then click the Insert button. The query results are
inserted into the document as a table.
You need to center the table.
13. Position the pointer over the table, click the Select Table button , click the Center but-
ton on the Formatting toolbar, and then click in a blank area of the document. See