MS Access 2007 Step By Step - Asim Abbasi

CH1: Overview | CH2:  MS Access Local & Linked Tables | CH3:  MS Access Queries | CH4: MS Access Reports & Forms | CH5: MS Access Modules & Macros | CH6: MS Access Data Import/Export Feature | CH7: MS Access Built-In Functions

Chapter 4: MS Access Reports & Forms

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


Report’s Design View


Figure 4-16: Report Design View.
________________________________________

 

1. Once you are in the Design View of the report you can always go back to the Run view by clicking the “View” command on the ribbon as shown in Figure 4-16 with label 1.

2. The ‘Report Header’ as shown in Figure 4-17 with label 2, contains the title of the report or anything you would like to shown on the report header.

3. Under report header we have ‘Page Header’. Anything that goes in this block will get repeated as a header/title on each page.

4. Details block contains the data fields of a table/query. In the Run time view, this will represent the records of the table/query.

5. ‘Page Footer’ as shown in Figure 4-17 with label 5, as the name says contains the information that appears on the bottom of very page of your report.

6. The ‘Field List’ window as shown in Figure 4-18 with label 6, contains the data source field names. If you would like to add more fields to your report simple drag them from this window and drop it on your report where you want them to appear.

As a beginner whenever you make some change in your report in the design time, make sure the run-time view is reflecting the same change. MS Access is very user friendly and many things you can learn and master as we play more with this wonderful tool.

 


Figure 4-17: Close-up of Figure 4-16 Left-Hand-Side.
________________________________________

 


Figure 4-18: Close-up of Figure 4-16 Right-Hand-Side.
________________________________________

 

Chapter 4: MS Access Reports & Forms

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

CH1: Overview | CH2:  MS Access Local & Linked Tables | CH3:  MS Access Queries | CH4: MS Access Reports & Forms | CH5: MS Access Modules & Macros | CH6: MS Access Data Import/Export Feature | CH7: MS Access Built-In Functions

Share with others: