Take Control: Producer (Page 1) 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40

Label Design

What Do You See? The Label Wizard should display your customer names in two columns. Go to Design View and see what the Label Wizard built.

 

The Detail section uses the name and address fields from the Customer query. The FullName and CityStateZip fields concatenated, or combined, several fields into one text string.

 

You can create aggregate fields in a report, too.

Report Design Tools->View->Design View
 

 

  Microsoft Access 2007 Exam 77-605 Topic: 2. Creating and Formatting Database Elements

  2.6. Create reports  2.6.7. Create labels using the Label Wizard