Page 109 - iPlus_Ver_2.0_class_7
P. 109

#Digital Literacy
                                                                                           #Creativity & Innovativeness

                        Practical Time


                     Create a table for the Library Management System.

















                     Create a table for the Student‘s Details.

















                       •  Show the relationship between the two tables based upon the common field.
                       •   Create a form for the Student’s Details table. Enter the following records through the form:
                         Gyan Shanker           8      B

                         Richa Sinha            6      A
                       •   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.




                     Teacher’s Corner


                 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.














                                                                                                                 107
                                                                                                More on Access
   104   105   106   107   108   109   110   111   112   113   114