Label wizard access how to#

The Label Wizard creates labels exactly how you tell it to. OK, there's a slight twist to the Label Wizard. The ContactName field appears in the Prototype label. ĭouble-click the ContactName field in the 'Available fields' list.

You've done this before: Double-click a field to add it or select the field and click the button. It's time to tell the Label Wizard which fields you want to use, as shown in figure. If you're satisfied with the default font (Arial 8 point), you can simply click Next.

You can format the font type, size, weight, and color. The next window of the Label Wizard lets you change the font used in your label. Make sure that the Unit of Measure is set to English, and then select 5161 from the list and click Next. Save yourself time and headaches and always make sure to buy Avery or Avery-compatible labels.

Label wizard access how to#

If you're not using Avery labels, you may have to click the Customize button and tell the Label Wizard how to set up your nonstandard labels. Simply scroll down and find the number that matches the one on your label box. If you're using Avery labels, the Label Wizard lists the various types of labels by product number. The first screen of the Label Wizard appears, as shown in figure. Select Customers from the table or query drop-down list and click OK.

Select Label Wizard from the list but DON'T CLICK OK YET.Īny time you create a report you have to tell Access which table or query contains the fields you want to use in your report. The New Report dialog box appears, as shown in figure. In this lesson, you will use the Label Wizard to create a set of mailing labels.Ĭlick the Reports icon in the Objects bar.Īccess lists all the reports in the current database. The Access helps you quickly create labels for any number of uses: mailing labels, name tagseven labels for your floppy disks! The Label Wizard supports a huge variety of label sizes and brands (as long as they're from Avery). The completed labels.įor, nothing beats a good stack of. Select the fields and enter the text you want to see on your labels. Select the product number for your Avery labels. Select the table or query to use for your labels.