Print the Access data table by using the Word beautification settings

The access database processing function is very powerful, but the printing setting function is inferior to the Word, so we can ask Word to beautify the setting and print the Access data table. First, open-source database Access. After sorting and other data processing, select the object containing the data to be exported in the Navigation Pane. Next, we will introduce

The access database processing function is very powerful, but the printing setting function is inferior to the Word, so we can ask Word to beautify the setting and print the Access data table. First, open-source database Access. After sorting and other data processing, select the object containing the data to be exported in the Navigation Pane. Next, we will introduce

The access database processing function is very powerful, but the printing setting function is inferior to the Word, so we can ask Word to beautify the setting and print the Access data table. First, open-source database Access. After sorting and other data processing, select the object containing the data to be exported in the Navigation Pane. Next, we will introduce different subsequent operations based on different Access versions.

I. Access2003 table

In the "Tools" menu, point to "Office link" → "publish with Microsoft Office Word" (1), the system will automatically generate a file in the Word RTF format, the Word editing window of the file is automatically opened.

Ii. Access2007 table

Click the "external data" tab, and in the "Export" group, click "Word" (2 ). The "Export" command can be used only when the database is opened.

In the export wizard, specify the name of the target file. If you want to view the Word document after the export operation is complete, select the "open target file after export" check box; if you select the record to be exported before starting the export operation, you can select the "export only selected records" check box (3 ). However, if you want to export all records in the view, make sure that the check box is empty. If no record is selected, this check box is displayed as unavailable. After setting, click OK.

No matter which Access version is used, if the. rtf file with the same name already exists, a dialog box is displayed, prompting you to click "yes" to overwrite the file (4 ). Click "no" to change the name of the target file. Now, in the Word editing window, the table is converted from the Access database. At this time, you can further set the font, border, and shading of the table, and print the output in Word.

Iii. Notes

When you use the export Wizard to export an object, Access creates a copy of the object data in a Word RTF Format File (*. rtf. For tables, queries, and forms, visible fields and records are displayed as tables in Word documents. The export wizard always exports formatted data. This means that only the fields and records that can be viewed in the object or view are exported together with the display format settings. Columns and records hidden due to filter settings are not exported. For reports, the report layout is also retained during export to try to make Word documents as similar as the report.

Before the Access database is published or exported as a Word Table, check the source data to ensure that it does not contain error values such as the error indicator (green triangle) or # Num. Before exporting data to Word, you must solve the error first. Otherwise, you will find that such a value is replaced with Null.

If the target Word document exists and is open, close it before proceeding. You cannot append data to an existing Word document. In the database, if you only want to export a table, query, or a part of the form, open this object and select only the desired record.

When you export data from Access to a Word document, the data is always exported to a New Word document. If you want to insert data into an existing Word document, you must export the data from Access to a new word document, then copy and paste the data from the New Word document to the existing document. Alternatively, you can copy rows from an Access table, query, form, or report and paste them into an existing document.