Database Management Systems is the most important application for any organization. It contains and process large amount of data. As we all know that generating mass mailing is one of the common uses of one of the most general uses, but is also very important role of a database. The Microsoft Access report is one of the best tools available in the market which helps us to store, analysis and process any kind of data. MS Access contains the in-built Label creator which can be used to make and design labels for any kind of files and databases.
The most convenient features that Access has for all the users is that they can automatically start printing mailing labels from your own database. The labels are just a kind of reports. The instructions mentioned below apply to MS Access 97.
First and foremost open the Database window. And then open the Reports tab by clicking on it.
Now click on the icon new and you will see a dialog box appearing on the screen. Click on the icon which is their named as Label Wizard.
You need to locate the table or query that is to be used for the labels. And then Click OK.
You just need to follow the wizard’s instructions to select the fields and formatting used in the labels.
If you are willing to print addresses that are stored in an Access database, or you want to store and then format and print them using Access then just print your labels when you are satisfied with the result.
You can even start by creating a simple report that is formatted to look like a mailing label. The report will then get the address data from the table or query that stores the addresses. By Printing the report will give you a single label for each address in the underlying record source.
Use the Label Wizard to create the report. You can then customize the layout of the labels, or write Visual Basic® for Applications (VBA) code to extend the report to meet your needs. The last step would be to preview the labels. In case you’re not fully satisfied with the wizard’s work, you can even customize the look of your labels in Design view
As a note you may often want to print the addresses directly on the envelopes instead of printing them on labels and then applying the printed labels to the envelopes. To print a label on an envelope, you just need to define a custom label. In step 1 of the wizard, when you see a prompt to specify the label details, then you click Customize and create a custom label. Do not forget to set Label Type to Sheet Feed.
The above mentioned steps are quite simple to follow and give you a brief idea of all the options that Microsoft Access uses. So just follow the steps and you will be able to create labels from Microsoft Access report.