Tuesday 8 January 2019

Microsoft Access Reports – Address Labels

Address labels have a separate wizard that generates address labels


1. Select the table or query the data is coming from.


2. Click on the label button.


3. Select the label size my selecting the manufacturer and product number.

4. On the next step choose the font, size and colour.

5. Then design the prototype label by adding the fields required by using the single arrow in the middle.  The return key will move you to the next line and the spacebar is used for gaps in the fields if multiple fields are to be on one line.

6. On the next step choose the sort order.

7. On finishing you will see a preview of the address labels.


No comments:

Post a Comment