Page 100 - iPro_trackGPT_V5_Class7
P. 100

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 Report Layout Design, Arrange, Format, and Page Setup.






                  Creating a Report

                  To create a report, follow the given steps:

                                             1  Click on the Create tab.













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




                    98    TrackGPT iPRO (V5.0)-VII
   95   96   97   98   99   100   101   102   103   104   105