How to Create Labels From Microsoft Access Reports

By eHow Computers Editor

Rate: (10 Ratings)

One of the most convenient Access features for many a user is automatically printing mailing labels from your database. The labels are really just a kind of report. These instructions apply to MS Access 97.

Instructions

Difficulty: Moderately Easy

Things You’ll Need:

Step1
Open the Database window.
Step2
Click on the Reports tab.
Step3
Click New. A dialog box appears.
Step4
Click Label Wizard.
Step5
Locate the table or query that is to be used for the labels.
Step6
Click OK.
Step7
Follow the wizard's instructions to select the fields and formatting used in the labels.
Step8
Print your labels when you are satisfied with the result.

Tips & Warnings

  • If you're not fully satisfied with the wizard's work, you can customize the look of your labels in Design view.

Comments

| View All Comments

jimlemon said

Flag This Comment

on 1/15/2007 I found that the values entered in Page Setup for columnar labels did not correspond to the printed labels. To ensure that the printed pages conform to these values, the height of the detail field must be set to the same height as that in the Page Setup - Columns dialog.

View All

Post a Comment

POST A COMMENT

Request a New How-To Article

Looking for more How To information? Chances are there’s an eHow member who knows how to do what you’re looking to do. Submit an article request now!

eHow Article:  How to Create Labels From Microsoft Access Reports

eHow Computers Editor

eHow Computers Editor

Category: Computers

Articles: See my other articles

Related Ads