Page 61 - ModularV1.1 _c8_flipbook
P. 61

08                                    REPORTS IN


                                                                                             MS ACCESS














                                Your Aim

                                to learn about:

                                   l  Understanding the Structure of the Report   l  Creating a Report
                                    l  Formatting a Report


                 In MS Access, a report is a feature that allows you to view, format and summarise the information
                 in a user-friendly format so that it can be printed. For example, you can create a simple report
                 of phone numbers for all your contacts, or a summary report on the total sales across different
                 regions and time periods.
                 A report is generated by using a table or query. You can format the report according to your
                 requirement. Similar to MS Word, MS Access also provides various formatting tools to format a

                 report.
                     UNDERSTANDING THE STRUCTURE OF THE REPORT

                 A report contains the following sections:

                    Report Header: The information placed
                    in this section appears  at  the  top  of
                    each page of the report.  This section
                    generally contains the logo, title of the
                    report or date and time.

                    Page Header: The text or image that
                    you add to the report header section
                    appears at the top of the report.

                    Detail: This section contains the main
                    matter of the report.                                            Report sections

                    Page Footer: This section contains general information about the report such as the page
                    number and total number of pages. The information added to this is printed at the bottom of
                    every page of the report.

                    Report Footer: This section shows the final result of the report. It appears at the end of the
                    report.


                                                                                           Reports in MS Access   59
   56   57   58   59   60   61   62   63   64   65   66