Written by Ravi Prakash
|
|
Friday, 22 June 2007
Category MS Access 2007 - Reports.
|
| |
| General Information |
| |
 |
| |
Data source
Create a form that shows several records
Create a report with the wizard
Create a report from blank template
Set up report properties
|
| |
|
| |
|
Reports summarize and present data stored on tables. A report can be executed at any time and it will always reflect the updated data of the data base. The
information usually has a format that allows printing, but it's possible to be consulted in the screen, to be exported to another program or also to be sent
by electronic mail. You can create a wide variety of reports in Microsoft Office Access 2007, from simplest to most complex. |
| |
|
Later to choose the record's data source, a report wizard will assist you creating reports. |
| |
| Data source |
| |
|
A report consists on extracted information of a table or consults, as well as of the information stored in the design of the report, as labels, header and
graphics. The table or query that provides the underlying data is knows as report's data source.. |
| |
| Create a report |
| |
| 1) In the exploration panel, clicks in the table or query that contains the data that wish to see in the report. |
| |
|
| Illustration 1: Select the Files tables. |
| |
| 2) In the Create tab, in the group Reports, clicks in Report. |
| |
|
| Illustration 2: Select the Report command. |
| |
| 3) Access creates the form and shows it in the Presentation View. Inside this view, changes of form's design can be made while it shows data. |
| |
|
| Illustration 3: Report in presentation view. Click here to view larger image. |
| |
| Create a report with the wizard |
| |
| In order to select with better criteria the fields that are going to appear in a report, you can use the report's Wizard instead of the previously mentioned tool. |
| |
| 4) In the exploration panel, clicks in the table or query that contains the data that wish to see in the form. |
| |
| 5) In the Create, in the group Reports, clicks in Report Wizard. |
| |
|
| Illustration 4: Report Wizard tool. Click here to view larger image. |
| |
|
