Page 105 - iPlus_Ver_2.0_class_7
P. 105

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 result, 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
                       want to create a report.








                 The report of the table, which is open, will be created.

















                                                                                                                 103
                                                                                                More on Access
   100   101   102   103   104   105   106   107   108   109   110