Page 61 - TP_Prime_V2.2_Class8
P. 61

21 st
                            In the Lab                                                       Century   #Technology Literacy
                                                                                               Skills

                    •  Create a table for the Library Management System.





















                                                                                                                          59  MORE ON ACCESS
                    •  Create a table for the Student‘s Details.





















                        1.  Show the relationship between the two tables based upon the common field.

                        2.   Create a form for the Student’s Details table. Enter the following records through
                            the form:

                            Gyan Shanker              8      B
                            Richa Sinha               6      A

                        3.   Write a query to find the Book Name, Publication, Student’s Name, Class and Price
                            from both the Student’s Details table and Library Management System tables.

                        4.  Generate a report of the query created.
   56   57   58   59   60   61   62   63   64   65   66