Designing Reports   «Prev 

Using the Label Wizard

To quickly review the basic steps and some good practices, you can start by creating a report to print event badges. This will use the built-in features for labels to get a preset size. You will also customize the look by formatting the company name, using the person�s preferred name if it is provided, and formatting the fields to emphasize the person�s name and company. You might also include conditional formatting, such as designating a color based on the role of the person.
You could also include a company or event logo, a barcode, or other event specific fields.
You can use a similar approach for envelopes, address labels, and other purposes.
Start by selecting query qryEventPerson as the record source. Then on the Create Ribbon, go to the Reports tab and click the Label button. This opens the Label Wizard. To quickly create a name badge that will fit in most badge holders, you might choose Avery 4168, continuous feed, to create name badges that are 2 1/6 inches tall by 4 inches wide. After clicking Next, you can customize the font. This example uses Calibri, size 10, Medium weight in the default black color. After clicking Next, you will begin selecting the fields to appear on the badge.

Create Labels using the Label Wizard

Create labels using the Label Wizard 1
Create labels using the Label Wizard 1

Create labels using the Label Wizard 2
In the New Report dialog box, choose label wizard at the bottom.

Create labels using the Label Wizard 3
The first window of the Label Wizard asks me to select the label I want to use.

Create labels using the Label Wizard 4
I have selected Enlgish as the unit of measure (my labels are measured in inches) and Avery as the manufacturer.

Create labels using the Label Wizard 5
Here I have used the scroll bar to display my label (5163), I have selected it, and now I am ready to go on to the nexst windpow by clicking the Nexst button.

Create labels using the Label Wizard 6
This window asks me about the text appearamce of my label. I am going to choose Arial black in 12 pt.

Create labels using the Label Wizard 7
6

Create labels using the Label Wizard 8
8

Create labels using the Label Wizard 9
9

Create labels using the Label Wizard 10
10

Create labels using the Label Wizard 11
6

Create labels using the Label Wizard 12
12

Create labels using the Label Wizard 13
13

Create labels using the Label Wizard 14
6

Create labels using the Label Wizard 15
15