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

