Page 53 - ModularV1.1 _c8_flipbook
P. 53

D.  Short answer type questions.

                    1.  What is a query?
                      ................................................................................................................................................................................

                    2.  What is relationship?

                      ................................................................................................................................................................................

                    3.  Write the names of any two parameters of the design grid.

                      ................................................................................................................................................................................
                 E.  Long answer type questions.

                    1.  Write the steps to create a query.

                    2.  What is a Crosstab Query?


                                                   In the lab                                         Subject Enrichment



                       Create a table for Library Management System.

                         Book ID  Book Name                 Publication          Price         Quantity
                          10001     Gulliver’s Travels      Paper Back            180              5
                          10002     The Time Machine        Rupa                  200              4

                          10003     Oliver Twist            Macmillan             210             10
                          10004     Diary of a Wimpy Kid    Penguin               150              5

                       Create a table for Student‘s Details.

                         Book ID  Student Name                   Class          Section       Issue Date
                          10001     Niharika                       8               C          20-10-2020

                          10003     Deepak                         7               A          10-11-2020
                          10004     Nisha                          8               B          09-10-2020

                       Set Book ID as the Primary key in both the tables.

                       Create the relationship between both the tables.
                       After creating both the tables, make the following queries:

                     l Display the Book ID, Book Name, Student Name and Class where Book ID is 10001.
                     l Display the Book Name, Student Name and Section where Section is A.







                 1.  Explain the concept of query.
                 2.  Explain different types of queries to the students.



                                                                                           Queries in MS Access   51
   48   49   50   51   52   53   54   55   56   57   58