Share this page
Access - Label Report
Access offers you several types of reports. This Web page how demonstrates to create a report labels and to change it. For more data about reports, watch to go to the Web page on reports.
The exercise of this page consists in creating a report labels that contains the list of the mail labels of the list of the customers of the company. This is to demonstrate that you may have on a label of the text and the fields at the same time. To realize the exercise of this page, you need the database demoacc2.mdb or demoa2k2.mbd for Access on 2000. You will find this document on the demonstration files Web page.
Access allows you to create quickly and easily labels from the data of your tables and your queries. The next part consists in creating a new report from the data of the Customers table.
the main menu, click on the reports tab .
the list of reports that you can create, select the Label Assistant.
The assistant labels will ask you some questions on the type of labels on that the report will print the chosen data. For the exercise, the chosen labels will be that of 2 " (inches) by 4 " (inches) from the Avery company.
the mesuring unit option, select the English option.
The option Counts frontally indicates the number of labels that are the one next to another. It's always possible that you don't find the size(format) that you wish from the units of measure, the companies and the types of labels. You can so press the button To personalize to generate your own sizes(formats) of labels with the data that you possess.
The assistant labels you demand then the kind of presentation of text that you want. pay attention not to choose a size of too big font. Otherwise, the text will not enter on the label.
the font type, size, style and the color of your choice.
The label assistant asks for the kind of presentation of text that you want. Pay attention not to choose a font size that's too big. Otherwise, the text will not enter on the label.
There are two ways to select a field.You can:
a field from the left column and press the button
For this exercise, place the fields in the same order as described below:
the Nom (name) field.
The label will pass to the next row every time you press the Enter key. As you have just carried out, you may have several fields on the same row. Furthermore, you may have also of the text and the fields on the same row.
the field Adresse (Address).
We presume in this case that all the clients are in the province of Québec. Another field (province) will be required if they are spread outside the province. Another field (country) will be required for international business.
the the field Code postal.
The required fields and the presentation are all placed correctly on the label. verify with the picture for this part of the exercise above.
Press the Next button.
The assistant asks you then if you want to sort out the records on one or several fields. For the purpose of the exercise, the records will be sorted out in order crossing according to the name of the company.
the list fields available form the left column, select the Nom field.
Press the Next button.
The assistant will ask you that name it's necessary to give to the report. It suggests you the title Labels customers. It's a rather good description of the report. So, we will save the label report.
this exercise, leave the options "as is".
Access will take a moment to generate the report according to the options that you chose and to save it in your database. Here is what should look like the first label of the report.
the View menu, select the Creation Mode option.
Access uses the function SupprEspace() to remove spaces useless to the end of a field. The software uses also the command & to glue together parts of text, placed between quotation marks, or the other fields. look at the first row of the label. The function pastes together the field Nom, the text that was the field Personne contact put between quotation marks, "-".
For more data about my way of modifying this report, please read the Web page on forms. Tools used to create forms and reports are the same.
|You like what you read?
Share it with your friends.