Page 51 - Touchpad_Plus_V3.2_Class 8
P. 51
Lab Session Century #Technology Literacy
21 st
Skills
Create a table for the Library Management System with the following data:
Create a table for the Book Issue Record with the following data:
Perform the following tasks on the created tables:
a. Show the relationship between the two tables based upon the common field.
b. Create a form for the Book Issue Record table. Enter the following records through the form:
i. 1236542 Gyan 8 B
ii. 1003650 Richa 6 A
c. Write a query to find the Book Name, Price, Student Name, Class and Section from both the tables.
d. Generate the report to the query created.
Teacher's Note
1. Make the concepts of Query, Form and Report clear and the difference between these to the students.
2. Demonstrate how forms and reports can be customised.
3. Explain different types of queries to the students.
More on LibreOffice Base 49

