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

