Access 2016 Advanced

Lesson 7 – Exporting Data

Access 2016

Steps

Practice Data

1. Select the Access data source you want to drag into Excel. The data source is selected. 2. Drag the data source to the desired location in the Excel workbook. The insertion point changes into an outline with a plus sign (+) attached when it is positioned over the Excel workbook and then the Access data appears in the Excel workbook.

Click Line Items table

Drag the Line Items table to cell A1 in the Excel workbook

Notice the Line Items table appears in the workbook in Excel. Close the workbook and Excel and do not save the changes.

Maximize the Access window.

C REATING W ORD M AIL M ERGE D OCUMENTS



Discussion

As there is no functionality in Word that can import data from Access, to export data from Access to Word, you need to work in Access. You can export tables, queries, forms or reports.

When you export an object using the Export Wizard, Access creates a copy of the object’s data in a Microsoft Word Rich Text Format file (.rtf).

Create a mail merge operation by using the Microsoft Access Mail Merge Wizard, which enables you to set up a mail merge process that uses a table or query in Access as the data source for the merge.



Procedures

1. On the External Data tab in the Export group click the Word Merge button . 2. Select the desired export options.

Page 82

OFFICEPRO, Inc.