Page 109 - Trackpad_ipro 4.1_Class7
P. 109

6.  The feature of Access that searches and                                1
                        displays data from more than one table                               1  F

                     Down                                                                                      2
                                                                                         3      R              R
                     1.  The key that matches the primary key
                                                                                      4
                     2.  It is an association between two tables on
                        the basis of a common field                            5      E         G

                     4.  The feature of Access that organises and
                        presents data in a user-friendly format for
                        printing                                       6              R













                                                                                  #Digital Literacy
                                                                                  #Creativity & Innovativeness




                       Create a table for the Students Details.
























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

                          Richa Sinha               6         A
                       c.   Write a query to find the Book Name, Publication, Student Name, Class, and Price from
                          both the Students Details table and Library Management System tables.
                       d.  Generate a report of the query created.





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