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

