|
|
|
Amazon.com
|
 |
|
|
|
|
|
|
|
Microsoft Access 2007 Tutorials for beginners |
|
|
Welcome to MS Tips and Tricks |
Welcome to MS Tips and Tricks -
You are at the right place if you need tutorials for beginners - Online Microsoft Access tutorials for beginners, covering the following categories
- Databases, Customization, Table, Forms, Queries, Reports, etc.,
|
Microsoft Access Tips and Tricks for beginners |
|
|
| |
| 16) Drag a field from the List of Fields to the Design area. |
| |
|
| Illustration 14: Drag the desired fields. Click here to view larger image. |
| |
|
| Illustration 15: Fields manipulation. Click here to view larger image. |
| |
| 17) From the Field List, select the related fields from related tables. |
| |
|
| Illustration 16: Add related fields to the report. Click here to view larger image. |
| |
| 18) With the tools of the group Controls in the Format tab, you can add images, logos, title, numbers of pages or the date
and the hour to the report. |
| |
|
| Illustration 17: Additional report Controls. |
| |
| 19) Add a Title to the Report.. |
| |
|
| Illustration 18: Additional Report Controls. Click here to view larger image. |
| |
| 20) Add the date to the form. |
| |
|
| Illustration 19: Additional report Controls. Click here to view larger image. |
| |
| Set up report properties |
| |
| In Access, the report design is divided in sections. You can see the report sections in the Design View. In order to create useful information, you
must understand how each section works. For example, the section in which chose to place a calculated control determines how Access calculates the results.
|
| |
| Report Header: this section is printed once at the beginning of the report. The header is used to offer information that normally
would appear in a cover page, like logotype or a title and a date. |
| |
| Page Header: This section is printed at the beginning of each page. |
| |
| Group Header: This section it is printed at the beginning of each group of records and it is used to print the name of the group. For
example, in a report whose data are grouped by products, the group header is used to print the product name. When a calculated control (like SUME) is used
in the group header, the resulting amount of the sum corresponds to the present group. |
| |
|
|
| |
|
|
|
|
|
|
|
|
|
