Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
In Access 2010 Essential Training, Alicia Katz Pollock gives a comprehensive overview of creating databases in Access 2010, whether using predefined database templates or building from scratch. This course covers each step of constructing and modifying databases for custom purposes, as well as working with tables, forms, queries, macros, and reports and charts for record keeping and analysis. Exercise files are included with the course.
It's easy to create a sheet of mailing labels from any of your tables. Click one time on Customers, go to the Create Ribbon, and then over here to Labels. It even has its own button. You can select the manufacturer of the box of labels that you have. I'm going to use Avery, and then from the list of Avery, I'm going to choose 5160, which is a standard label that you can find in any Office Supply Store. Click Next. Here, you can change the Font that you want. We're going to leave that on Arial.
You can change your Font Size. Let's go ahead and make this 9. You can change your Font Weight, anything from Thin to Heavy. We're going to make ours Normal. You can change your Text Color to any color that you'd like, but because we're on an black and white printer, we're going to stick to Black, and click OK. If you wanted you could also select Italics and Underline, but we are going to leave those off. Click Next. Now we're going to arrange our label. You have to put in all the commas, punctuation and spacing yourself.
There's two ways to move the fields over: I can click on Company and press this arrow, tap Enter on your Keyboard to go to the next line; I can also double-click on a field to move it over. Go ahead and hit Enter again after Address1 and move over Address2. Hit Enter again to go to the last line. Move City over, and type a comma and a space. Move over State, type another space yourself, and move over ZIP Code. You could move over Country as well. For the sake of this demonstration, I'm not going to.
Click Next. Now it wants to know how you want to Sort your labels. If you're going to be sending them by bulk mail, do choose Zip Code and move that over. Then choose Next. We're going to change the name of our report to Customer Labels, and let's click Finish. I didn't get an error message, but let's take a look and see if everything fits okay. Click OK. My labels actually looked pretty good.
The Mailing Label Wizard is a welcome shortcut to laying out Mailing Labels with ease.
Find answers to the most frequently asked questions about Access 2010 Essential Training.
Here are the FAQs that matched your search "":
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.