Page 331 - TP_IT_V1.0_C10_flipbpookl
P. 331

Step 6:  Click on drop-down arrow key in front of the Field option. A drop-down list appears.
                 Step 7:   Select the desired field from the respective tables in the drop-down list. In this case, we have selected the
                         Adm No. field of the STUDENT column, as shown below:
































                 Step 8:  Repeat step 7 and 8 to add more fields. In this case, we have added the following fields:
                         Name field of the STUDENT column
                         Total Marks field of the Marks column
                         Grade field of the Marks column

                         Percentage field of the Marks column
                 Step 9:   When you click on the column beside the Table then the column fills automatically based on the selected
                         fields.































                 Step 10: Select the File → Save As option from the Menu bar to save the query.




                                                                        Database Management System using LibreOffice Base  329
   326   327   328   329   330   331   332   333   334   335   336