1) Load Word and open the desired document.
2) Load Access and open the desired database and query.
The toolbar displays application buttons for each open window.
To modify the query to display the appropriate data:
1) Display Design view.
2) Change the criteria for the appropriate field.
3) Run the query.
With all Office applications you can:
1) Cut, copy, and paste selections within and between tables and objects in an Access database.
2) Perform these operations between Access and other applications.
To drag and drop, both applications must be open and visible in the window.
1) Right-click a blank area on the toolbar.
2) Select File/Windows/Vertically from the shortcut menu.
3) Click the Access window to make it active.
4) Choose Edit/Select All Records to select the query datasheet table.
5) Drag the table to the desired location in the Word document.
Edit and format the table in Word as any other table.
1) Choose Undo File from the taskbar Shortcut menu.
2) Drag the sizing handle to increase the table size.
3) Center the table after selecting it.
Linking an Access Object to Another Application
When a linked object is created, the data is stored in the source file and a graphic representation of the data is displayed in the destination file.
The creation of a link makes a connection between the source file and the destination file.
A live link means that changes made in the source file are automatically updated in the destination file when it is opened.
To create a link to a query:
1) Display the Database toolbar in Word.
2) Move to the desired location in the Word document.
3) Click:
Insert Database.
To select the database file to insert:
1) Click:
.
2) Select the appropriate Access file.
3) Click:
.
4) Open the Queries tab and select the desired query.
5) The Link to Query is preselected.
6) Click:
.
Modify the query settings if desired and use the AutoFormat button to select a format for the table.
1) Select desired style.
2) Click:
3) Click:
.
Select All, if necessary.
Select Insert Data as Field so data can be updated if the source changes.
Click:
.
To format the table in Word:
1) Center the table.
2) Insert a blank line above the table.
To sort the table data:
1) Select the desired column.
2) Click:
.
Updating a Linked Object
To update a linked object:
1) Switch to the Access Query datasheet window.
2) Close the query.
3) Open the desired table.
4) Edit the appropriate data.
5) Switch to the Word document.
6) Click: Update Field to update the data in Word.
Scroll to confirm the change.
Sort the table again.
7) Save the Word document and close Word after printing the document.
8) Close the database.