Page 105 - Trackpad_ipro 4.1_Class7
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.















                     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:


                          2  Click on the
                          Create tab.






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








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