Page 246 - IT_V1.0_Class10
P. 246

Step 4:  Select the table that you use for creating a query from the Add Table or Query window. In our case,
                       we have selected the Student table.

              Step 5:  Click on the Add button.
                       The selected table appears in the Query Design window.

                       Similarly, you can add more tables for the query.
              Step 6:  Click on the Close button in the Add Table or Query dialog box.








                 3

                 4










                 5








                                                           6






                       The query design view has two sections—upper action has tables to be used to design a query. The
                       lower section is the design query parameters where you specify:

                           Fields: It displays the selected fields in the output of the given query.
                           Alias: It gives another name to the field in the output window.

                           Table: It specifies the table from which the field is to be selected.

                           Sort: It specifies the sorting order in which the field is to be arranged
                           Visible: If selected the field will be displayed in the output window.

                           Criterion: The condition for the rows to be displayed.
              Step 7:  Click on the drop-down arrow key in front of the Field option. A drop-down list appears.

              Step 8:  Select the desired field from the drop-down list. In this case, we have selected the STUD_ID field.
                       Similarly, you can add more fields.

              Step 9:  Specify the criteria in the Criterion option based on which the query retrieves the data. In our case,
                       we have specified 10 in the CLASS field.





                244     Information Technology Play (Ver 1.0)-X
   241   242   243   244   245   246   247   248   249   250   251