Access 2016 Intermediate

Lesson 12 - Using Advanced Report Design

Access 2010

Steps

Practice Data

15. Add the field by which you want to sort from the Available fields list box. The field name appears in the Sort by list box.

Double-click Store Name

16. Select Next .

Click

The next page of the Label Wizard appears with the insertion point in the What name would you like for your report? box.

17. Type a name for the report.

Type Customer Labels

The text appears in the What name would you like for your report? box.

18. Select Finish .

Click

The Label Wizard closes and the labels appear in the print preview window.

Create the following label. Insert the correct punctuation by typing a comma and space after the City field, and a space between the State/Province and Postal Code fields. Two lines under the Country field, add the text Attn: and insert the Contact Name field.

{Store Name} {Address} {City}, {State/Province} {Postal Code} {Country}

Attn: {Contact Name}

Return to the table and continue on to the next step (step 14).

Notice that the labels appear in three columns. The address labels are printed in alphabetical order by store name and the text Attn: appears on every label before the contact name. Close the print preview window and the label report.

Page 236

OFFICEPRO, Inc.