Page 423 - IT 402 v2.0 class 10
P. 423

Book ID      Student Name              Class             Section         Click to Add
                        1       Amit Kumar                    7                  C

                        2       Ria Aggarwal                  8                  A
                        3       Yash Yadav                    6                  D
                        4        nanya  upta                  8                  B
                        5       Praveen Seni                  7                  C

                •  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.
                   yan Shanker

                  Richa Sinha            6      A

                •    rite a  uery to find the  ook Name   ublication  Student s Name   lass and  rice from both the
                  Student s  etails table and  ibrary Management System tables.
                •   enerate a report of the  uery created.



                                     Function                                      Output
                   =ABS(-541)
                   =SQRT(625)
                     O N    .
                    S M                 5
                     O       5
                      O              5

                    MO




































                                                                                           Practical Work      421
   418   419   420   421   422   423   424   425   426   427   428