Most of the reports that you will create in Microsoft Access will be used for common data printing requirements.
However there are times when entirely different kinds of printouts are required, such as when you need to create mailing labels.
Mailing labels are created in Microsoft Access by using a report. The basic label can be created by starting with a blank form, or you can use the label wizard. The Wizard is much easier to use and can save you a great deal of time.
Usually, in a large enough company, labels will be created for mailing purposes; addressing packages or envelopes. However, it is just as easy to create product labels, name tags or any other type of label. Rather than having to create the report from scratch, or use the standard Access Report Wizard, you will find that the Label Wizard will save a lot of time and will create exactly the kind of result that you need to print labels.
We can create a report, to print mailing labels by using the Mailing Label Report Wizard:
We can change the record source of the report, if for example, the report design suits a different table or query. For instance, if we have a table that holds Customer Names and Addresses and another table that holds similar Supplier information.
An efficient way of producing mailing labels in Microsoft Access, for both sets of data would be to change the record source in the reports properties dialog box.
Mail Merge for Microsoft Access
The easy solution to create Microsoft Word, Excel, Email or PDF documents from data in your MS Access database. Documents of any level of complexity can be created easily (contracts, invoices, reports). Supports email mail merge, labels and envelopes, directory reports and listings. Free Trial Version available to download.