Template Issues

Where Are Microsoft Access Label Reports Saved?

Maira Mehtab Sep 21, 2026 868 views

Question details

The user wants to know the storage location of Microsoft Access label reports and how to preserve the displayed data.

Product: Microsoft Access
Device & OS: not provided
Scenario: Creating label reports from templates and trying to save or locate the generated label output.
Observed behavior: Access saves the report definition in the database but does not permanently store a copy of the displayed data, retrieving it fresh from the Record Source upon opening.

Before you start

Ensure you have Microsoft Access installed and the database containing your label report template is currently open.

Solution 1Recommended

Export the Label Report as a PDF to Preserve Data

Since Access only saves the report definition, exporting the report to a PDF is the best way to save a permanent, unchanging copy of your generated labels.

Microsoft Access stores the label report definition (the layout and structure) inside the database itself. It does not save the actual records. Every time you open the report, it pulls live data from its Record Source. To capture the exact state of the labels at a specific time, you must export it.

Open the report

Locate and open your saved label report within your Microsoft Access database.

Filter the report (optional)

Apply any necessary filters at runtime to display only the specific records you want to print or save.

Export to PDF

Navigate to the External Data tab on the ribbon, click on PDF or XPS, and choose a destination folder to save your static file.

Solution 2

Use a Make-Table Query to Save a Data Snapshot

If you need to keep a historical record of the exact data used for the labels inside the database, create a make-table query.

Free Microsoft Office alternative

Use WPS Office for Easier Label Creation

While Microsoft Access is powerful for complex databases, WPS Office offers a highly compatible, free alternative for creating and printing labels using simple spreadsheets and word processing.

1. Prepare data in WPS Spreadsheet: Organize your label data (names, addresses, etc.) into columns and save the file.
2. Open WPS Writer: Create a new document, navigate to the References tab, and select Mail Merge.
3. Insert merge fields: Connect your saved spreadsheet as the data source and insert the merge fields into your label template.
4. Generate labels: Click Merge to New Document to generate all your labels, which can be saved or printed immediately.

100% compatible with Microsoft Word and Excel formatsEasily create professional labels using the built-in Mail Merge featureFree, lightweight, and fast alternative to the standard Microsoft Office suiteIntuitive interface with no steep learning curve

Frequently Asked Questions

Why doesn't my Access label report save the actual data?

Access reports only save the layout structure and definition. They are designed to retrieve live data dynamically from the Record Source each time they are opened, ensuring the information is always up to date.

How can I filter my Access label report output?

You can apply a filter at runtime when opening the report. This allows you to display specific records for printing without permanently changing the underlying query.

Can I create labels in Word instead of Access?

Yes. You can export your Access data to an Excel or CSV file, and then use the Mail Merge feature in Microsoft Word or WPS Writer to generate and print your labels easily.

Document & File Issues