Unit Iv
Unit Iv
Unit Iv
Reports
It summarizes data in a format suitable for publishing i.e. to view data on the
screen or to print it on a printer or to publish it on the web. It is also used to present
data in a meaningful and attractive manner and here we can combine data, charts and
images, even audio and video. There are six ways to create reports in Access.
Reports Purpose
Design View Begins with a blank page.
Choice of fields, sort criteria and report layout used.
Report Wizard
Creates tabular or columnar report.
Columnar Auto One or more records displayed vertically. Selected from a
Report single table or query.
Tabular Auto Rows and columns grouped by field values. Selected from
Report a single table or query.
Leads us through creation of a report containing a chart
Chart Wizard
and associated data.
Label Wizard Helps you create mailing labels from data.
10. Give the name of the report and click “Finish” button.
4.6 MAILING LABELS
There is another way to create a report is mailing labels. It is used to create
mailing labels from data. This wizard creates a report format for printing on labels.
Steps to create label wizard:
1. Open the desired database.
2. Create the table or query where the objects data comes from: Table Name
(Employees) and Press OK button.
3. Start a new report with the “New report” toolbar button shown in left.
4. Click on Label wizard and click Ok.
5. First select the kind of label we would like to produce and click Next.
6. In the next dialog box we have to specify font and size of text.
7. As the next step select the prototype label and click Next button
8. Then choose the field name which you want to sort and press Next button.
Select the fields that will appear in our labels and adds text or punctuation