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
   46   47   48   49   50   51   52   53   54   55   56