Page 52 - ModularV1.1 _c8_flipbook
P. 52

Recap


                           A query is the most  important  object provided by MS Access  that can give you
                         information that you might not be able to find by looking at the table directly.
                           An  association  between  two  tables  on  the  basis  of  a  common  field  is  called
                         relationship.



                                                         Exercise



                           ü
                  A.  Tick ( ) the correct option.
                     1.   The feature in MS Access that allows us to retrieve data from a table is called ......................... .
                       a. Primary Key                       b. Foreign Key                c. Select Query


                     2.   The ......................... parameter displays the data in either descending or ascending order during the
                        run time in the query window.

                       a. Field                             b. Sort                       c. Or

                     3.  In which group of the Create tab is the Query Design command present?

                       a. Queries                           b. Tables                     c. Templates

                     4.  What is an association between two tables on the basis of a common field called?

                       a. Structure                         b. Relationship               c. Binding

                  B.  Write ‘T’ for true and ‘F’ for false.
                     1.  You can run the query only once.                                                 ...........................


                     2.  You can set multiple criteria in a query.                                        ...........................

                     3.   The data can be displayed in either descending or ascending order during
                        the run time.                                                                     ...........................

                     4.  Relation command is used to make relationship between tables.                    ...........................

                  C.  Fill in the blanks using the words given below.


                                                       select query, field, run, relationship


                     1.  The ........................... parameter forms the first row of the design grid in the Query window.

                     2.  ........................... retrieves data from one or more tables.


                     3.  A ........................... is established between two tables based on the Primary Key.
                     4.  After creating the query, we need to run the query by clicking on the ........................... button.



                  50      Modular (Ver. 1.1)-VIII
   47   48   49   50   51   52   53   54   55   56   57