Page 427 - TP_IT_V1.0_C10_flipbpookl
P. 427

15.  Create the following table using the ‘Design View’.
                              Reg No.           Name        Date of Submission    Marks Obtained         Grade

                             T/121/15       Anshu Verma          11/07/15               18                 A
                             T/137/15       Anjali Kumari        12/07/15               20                 A+

                             T/145/15       Deepak Kohli         14/07/15               17                 B+

                     •  Name the table as ‘Marks Distribution’.
                     •  Enter atleast 3 records.
                     •  Sort the data on the basis of grades.

                 16.  Create the following table using the ‘Design View’.

                             Roll No.            Name            Date of Birth      Phone No.             Place
                               A001        Manan Gupta           12/09/1987         2354667667     Delhi

                               A002        Ryansh Sharma         09/05/1986         3435555555     Chattisgarh
                               A003        Rahul John            02/05/1990         6565544329     Mumbai


                     •  Sort the data in decreasing order on the basis of Place.
                     •  Set Roll No as the primary key.
                     •  Delete the record no. A002.
                     •  Add another record.
                 17.  Create the following table for the Library Management System.

                             Book ID            Books              Publication            Price          Quantity

                                1         Touchpad            Orange Education             296              10
                                2         Pratibha            Madhuban                     256              20
                                3         Cyber Olympiad      Orange Education             300              20
                                4         Living World        Gurdas                       275              20

                     Create the following table for the Student‘s Details.

                                   Book ID       Student Name              Class             Section
                                      1       Amit Kumar                    7                   C

                                      2       Ria Aggarwal                  8                   A
                                      3       Yash Yadav                    6                   D

                                      4       Ananya Gupta                  8                   B
                     •  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.
                     •  Generate a report of the query created.




                                                                                                       Practical Work  425
   422   423   424   425   426   427   428   429   430   431   432