Page 106 - TP_iPlus_V2.1_Class7
P. 106

The parameters of the design grid in the bottom part of the Query window are:
                  •  Field: It is the first row of the design grid that displays the selected field names from the table.

                  •  Table: It displays the names of the existing tables in the relationship window.
                  •  Sort: It displays the data in either descending or ascending order during the run time.
                  •  Show: This means that the field with the checkmark will be displayed in the output, and the
                     fields with an uncheck mark will not be displayed when the query runs.

                  •  Criteria: This displays the condition on the basis of which the records will be filtered and
                     displayed in the query output.
                  •  Or: It is used to set multiple conditions in a query.

                  After creating the query, we need to run the query by
                  clicking on the Run button       . The related records

                  of the query will be displayed in the Datasheet view.

                   i +  REPORTS IN ACCESS

                  A report in Access is a feature that allows you to organise
                  and present your data in a user-friendly format so that
                  it can be printed. The four new tabs that appear on the
                  ribbon of the Report window are Design, Arrange, Format, and Page Setup.

                  Creating a Report

                  To create a report, follow the given steps:


                                  1  Click on the
                                 Create tab.




                                                                                          3  Click on the
                         2  Open the desired                                             Report command
                        table for which you                                              on the Reports
                        want to create a report.                                         group.








                  The report will be created for the table that is currently open.

















                   104
                         iPlus (Ver. 2.1)-VII
   101   102   103   104   105   106   107   108   109   110   111