That way, the Detail section (which represents the label) can be copied from right to left across the width of the page, and then down the page.
The only difference between label reports and ordinary reports is that label reports use multiple columns. The Detail section contains a template that defines how Access places the fields for a single label, and that template's copied across the form. The label report's really just an ordinary Access report, like the kind you've learned about throughout this chapter. (You could place a company logo in the corner of the address, and so on.)įigure 11-15. If you open it in design mode, then you can add extra touches.
Īccess saves your report, and then opens it in print preview mode (Figure 11-15) or design mode, depending on your choice. To create a batch of labels, here's what you need to do:Ĭhoose "See the labels as they will look printed" if you want to look at the finished product in Print Preview mode, or "Modify the label design" if you want to change it in Design view first. For more information, check out Word 2007: The Missing Manual. Word includes a mail merge feature that can extract data from an Access database, and then use it to generate any document you want. Instead, you'll do better using a real word processing program like Word. Getting Access to cooperate isn't all that easy. Tip: If you have a database that stores information about people, then you may have thought about using Access reports to build form letters and other documents. All you have to do is print, peel, and stick. You give Access the Avery number, and then it can create a report that puts the address information in the correct place. But no matter what type of label paper you pick, it has a standard Avery number that tells Access everything it needs to know about the labels' size, and how they're arranged. Label paper variessome types pack the information in very tightly, so you can print out dozens of return addresses at once, while others use larger labels for putting the mailing address on a letter or package. To make this work, you just need to buy a few sheets of label paper from your favorite office supply store. The Label wizard pulls address information out of any table you want and uses it to print out handy mailing labels. If you have a table with address information (like customer homes, business locations, or suspected UFO sites), Access has another wizard to offer you.
0 kommentar(er)
