MS Access allows you to create and format mailing labels through the Label Wizard which reduces your typing stress and facilitates your work and also create various types of chart and graphs through the charts wizard and include them in a report for easier data analysis. You can also format your reports and mailing labels which are part of reports. The most efficient way to build mailing labels is to create it using the Label wizard in Microsoft Access. In this tutorial part, I will explicitly explain and give you a step by step guide on how to create mailing labels and how to create charts of different types especially in MS Access version 2010, 2013 2016 and later versions which you may be finding difficult to create.

how to create a mailing label and design charts in microsoft access

This is part 2 of chapter 7 of the Free Online Access Tutorial Series at Microsoft Tutorial website. In this part, I will explicitly explain how you can create a mailing label through the access label wizard and how to different kinds of charts for any version of MS Office Access you have on your pc.

In the previous part (Part 1) at http://www.microsofttut.com/2017/04/how-to-design-professional-reports-in-ms-excel.html, I explained how to learn and build databases in Access and MySQL through SQL in detail. Also see the full tutorial course content of this Microsoft Access Tutorial Series at http://www.microsofttut.com/p/course-content-for-microsoft-access.html.

CREATING MAILING LABEL IN MS ACCESS
Mailing label is one of the special operations that can be achieved using Microsoft Access. This operation is used to extract or retrieve some information or fields that are needed in hard copy format from an existing database table. It is mainly used by organization’s secretaries to lessen the volume of characters to type when sending bulk SMS and also saves the user or the secretary the troubles of retyping the information. The Labels feature or icon is located in the Reports group in Microsoft Access Create tab and is very similar to Reports but with minor difference as you will see shortly.

For example, assuming you are the secretary, the Manager of your company may tell you to send a memo for a meeting to all the staff in the company, instead of starting afresh to type the name and address of all the staff, you can use the mailing label in MS Access to extract the needed information from a database already containing workers bio data like the workers payroll system table, etc.

To Create a Mailing Label in MS Access:
1. First highlight the table or query you wish to use as the data source for the label from the Navigation pane. Referring to the above example, I will select the workers payroll system table.

2. Click Labels located in the Reports group under the Create tab. This prompts the report wizard dialogue box.

3. Specify the orientation of the label by choosing a suiting dimension for your label as shown below. The default setting is ok for use but you can also create a customized dimension for your label by clicking the Customize tab. Click Next.

select any label dimension of your choice

4. Specify the font type, font style, font size, font weight, text colour, etc. (the default selections are ok). Then click Next.

5. Select the fields needed in the mailing label. For example, first name, etc. use the > button to transfer the selected fields from the available fields: box to the prototype label: and then click Next.

6. Specify the sorting field for the mailing label and again use the > button to transfer it to the Sort by: box and then click Next.

7. Lastly, type a unique name for your mailing label, specify whether to see how the labels will look when printed or to further modify your label in the design view and click Finish.

8. MS Access extracts all the record in the selected fields and displays them based on your specified settings.

HOW TO CREATE A CHART OR GRAPH FOR YOUR DATASHEET DATA OR INFORMATION
A chart or graph is a graphical representation of information. Charts are normally used to summarize the relationship among data and to summarize all financial analysis. Some professionals like Data Analysts and Managers prefer graphical representation of data using chart to tabular representation for a more efficient comparison of information.

For example, you might want to chart the data from your sales report table, workers’ payroll system table, etc. You can create a chart and include it in your reports using data from a previously created table or query as your data source.

There has been a rumor that charts are no longer supported in MS Access 2013 and later versions, and that you have to first create it Excel or export your data to Excel. No you can still create your charts directly in MS Access 2013 and later versions but with limited features. If you want a more control to your charts, then create it in MS Excel, a perfect application for creating charts

To Create a Chart for your Data in MS Access 2013 and later Versions:
Click http://www.microsofttut.com/2017/04/guides-to-create-mailing-labels-and-charts.html to study full tutorial post with screen to screen images.