Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 126 - CoreGPT(Podar)_Flipbook_C8
P. 126

    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.

                    124     Premium Edition-VIII

| 121 122 123 124 125 126 127 128 129 130 131 |