Create mailing labels in Access
MS Access gives you several different options for creating labels containing data stored in your Access tables. The simplest is to use the Label Wizard in Access to create and print a report that is formatted to fit your labels. The labels can contain data that is stored in Access tables, or data that is imported or linked from other sources such as Microsoft Excel or Microsoft Outlook .You can create the labels as a report within Access, or you can "merge" the data with a Microsoft Word document and then print the labels from Word.
A perennial database task is printing mailing labels from lists of ID,Name,Gender and Phone. The easiest way to create a report that prints on labels is to use the Label Wizard, which contains a long list of preset formats for all standard Avery brand and compatible labels. (Most boxes of label sheets include an Avery number that specifies the size of your labels.) After you create a report with the wizard, you can make further changes in Design view.
Use Access to create and print labels
In Access, you create labels as a report that is formatted with a small page size to fit the desired label. The most common use of labels is for mailing, but any Access data can be printed in a label format for a variety of purposes. In the case of mailing labels, the report gets the address data from the tables or queries containing the addresses. Printing the report gives you a single label for each address from the underlying record source.
The Label Wizard asks you a series of questions about your labels and the data you want to display on them. The wizard creates the report
Please Watching My Video is Below
No comments:
Post a Comment