Access 2016 Intermediate

Lesson 12 - Using Advanced Report Design

Access 2010

8. Select the desired font and color options.

9. Select . 10. Select the field for the first row from the Available fields list box. 11. Press [Enter] . 12. Continue adding fields from the Available fields list box, as appropriate. . 14. Add the field by which you want to sort from the Available fields list box. 13. Select

15. Select . 16. Type a name for the report.

17. Select

.



Step-by-Step

Use the Label Wizard to create file folder labels.

If necessary, display All Access Objects in the Navigation Pane.

Steps

Practice Data

1. Select the table with the label

Click Customers

information in the Navigation Pane. The table is highlighted.

2. Select the Create tab on the Ribbon . The Create tab appears. 3. Select the Labels button in the Reports group. The Label Wizard opens. 4. Select the Filter by manufacturer list. A list of manufacturers appears. 5. Select the desired label manufacturer. The manufacturer is selected and the corresponding label types appear in the What label size would you like? list box.

Click Create

Click

Click Filter by manufacturer

Click Avery

Page 234

OFFICEPRO, Inc.