“Labels”

In “Access”, we have a wizard that helps us to create labels.

First, select the table in the “Navigation pane” that contains the data for which you want to make “Labels”. In this example, its the “Students” table.
Select the “Create” tab in the “Ribbon”.

And click the “Labels” button.
This opens the “Labels Wizard”.
In the first Wizard window, we determine the dimensions of the “Labels” we are to use.
Click the downward pointing arrow and select your “Labels” manufacturer.
Then select a product number from the list in the window .

If your label does not appear in the list, click the “Edit” button.

In the dialog that appears, give a name to the label.

Give the number of adjacent labels.
And give the different sizes and margins.

Click OK.

And click “Next” in the wizard window.
In the second wizard window, we determine which fields should be printed in the label.
Select the field in the “Available fields”, and click the ‘>’ button.
This brings these fields into the “Label Master” section.
If you have a second field, for ex. firstname, to be printed on the same line as the lastname, first press the “Spacebar” on your keyboard, then select the second field, and then click the ‘>’ button.
Click the “Enter” key on your keyboard to add a field on the next line.
Click the “Next” button when you’re done.

This brings us to the third window of the wizard.
In the third window, you determine which field you want to sort the labels.
Select this field in the left column and click the ‘>’ button.
If you want to sort multiple columns, place them all in the right pane.
Click the “Next” button.

And in the last window of the wizard, we determine whether we want to display the labels in “Print Preview” or if you still want to make design changes.

I choose the first and click the “Finish” button.

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats