MS+Access+Labels

= Microsoft Access  =

Creating a Report for Address Labels
// After creating a table you may wish to create a report of addresses labels //  1. Click Report tab  2. click new  3. click “label wizard”  4. in label wizard, use drop down menu to find the table or query you would like to get your information from & click “ok”  5. Choose label size Avery #5260 works best with basic size labels 1 x 2 5/8, 3 across  6. choose font (you may want to play with this)  7. from the “available fields” box select the fields you want listed on your labels  8. <span style="font-size: 18pt; mso-bidi-font-weight: bold; mso-bidi-font-style: italic; mso-bidi-font-size: 10.0pt;">move these fields to the “prototype label” box – be sure to put first and last name on first line, address on second, etc. (spaces between where needed) <span style="font-size: 18pt; mso-bidi-font-weight: bold; mso-bidi-font-style: italic; mso-bidi-font-size: 10.0pt;"> 9. <span style="font-size: 18pt; mso-bidi-font-weight: bold; mso-bidi-font-style: italic; mso-bidi-font-size: 10.0pt;">sort by Last <span style="font-size: 18pt; mso-bidi-font-weight: bold; mso-bidi-font-style: italic; mso-bidi-font-size: 10.0pt;"> 10. <span style="font-size: 18pt; mso-bidi-font-weight: bold; mso-bidi-font-style: italic; mso-bidi-font-size: 10.0pt;">click next and give label Report a name <span style="font-size: 18pt; mso-bidi-font-weight: bold; mso-bidi-font-style: italic; mso-bidi-font-size: 10.0pt;"> 11. <span style="font-size: 18pt; mso-bidi-font-weight: bold; mso-bidi-font-style: italic; mso-bidi-font-size: 10.0pt;">click finish