How to Print Labels from Microsoft Access

Quick summary

Microsoft Access includes a built-in Label Wizard that lets you create and print labels directly from any table or query in your database. By following a short series of steps in the Reports group, you can configure label size, field layout, and sort order before generating a print-ready label report.

Steps

1. Click on the 'Create' tab in the Ribbon.
2. In the 'Reports' group, click on 'Labels' to open the Label Wizard.
3. The Label Wizard will prompt you to choose the label size and standard label formats.
4. Click 'Next' to proceed.
5. Set up the text appearance and click 'Next'.
6. Choose the available fields you want to sort and click 'Next'.
7. Select the fields you want to display and arrange them in the desired order on the label, then click 'Next'.
8. Once satisfied with the label layout, name your label and click 'Finish'.
9. Access will generate a Label Report ready for printing.
10. Click the 'Print' option to send your labels to the printer.
11. Click 'OK' to finalize and complete the printing process.