MS Access 2007 Step By Step - Asim Abbasi

Chapter 4: MS Access Reports & Forms

Page #: 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9

The reporting feature in MS Access provides the ability to its users to present the data queried from any data source in well-presentable format. Difference between report and query is that in case of reports the queried data is presented in a cosmetic fashion with header, footer, high-lighted text etc. where as in case of query there is no such formatting.

We will learn in detail regarding designing and implementation of MS Access reports in this section of the book.

Step 1: Creating Reports Using Report Wizard

Figure 4-1: Report Wizard lies under the “Create” command.
________________________________________

1. To design new report, the first thing you have to do is to click the “Create” command on the menu bar as shown in the Figure 4-1 with label 1.

2. Click the “Report Wizard” command on the ribbon.

Step 2: Select Table/Query & Fields for Report

1. Select the Table or Query from the drop down menu as shown in Figure 4-2 with label 1. This table or query will be the data source for our report.

2. The ‘Available Fields’ section will get populated with the fields available in your table or query you selected in the point 1. Out of the fields mentioned in the ‘Available Fields’ section, select the one you would like to show on your report using the ‘>’ button as depicted in the screenshot above.

3. Finally click the <Next> button.

In case you want to select all the fields then simply click the ‘>>’ button.

Figure 4-2: Report Wizard
________________________________________

Chapter 4: MS Access Reports & Forms

Page #: 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9

Share with others:

products

books

FREE VB, ASP Projects

MS Access 2007 Step By Step - Asim Abbasi