Labels are necessary for every office whether it’s for labeling file folders or creating mailing labels for
direct mail campaigns. However, it can be tedious and time-consuming to re-type labels every time you need them. Microsoft Access provides a label creator that can be used to design labels for any use in an easy and efficient manner.
- Open the Access database containing the information you wish to include on your labels.
- Using the Navigation Pane, select the table containing the appropriate information. You may also choose a report, query, or form.
- On the Create tab, click the Labels button in the Reports group.
- When the Label Wizard opens, select the style of labels you wish to print and click Next.
- Choose the font name, font size, font weight and text color you would like to appear on your labels and click Next.
- Click the fields you would like in the Available Fields box and using the > button, place the fields you wish to appear on the label on the prototype label. When finished, click Next to continue.
- Choose the database field(s) you would like Access to sort, click the > button to place in the Sort by box, and click Next.
- Specify a name for your report and click Finish.
Your label report will then appear on the screen. Preview the report to ensure it is correct. Once you’re satisfied with the design, load your printer with labels and print the report.
Subscribe to Monthly Training Updates
Receive monthly productivity and training insights, software tips, and notices of upcoming classes!