Page 48 - Touchpad_Plus_V3.2_Class 8
P. 48

3.  Which of the following is used to display the data in either descending or ascending order during the
                        runtime in the query window?

                        a.  Field                                        b.  Or

                        c.  Sort                                          d.  Criterion

                     4.  Which of the following are the links that associate a field in one table with the same field in another
                        table?

                        a.  Structures                                   b.  Bindings

                        c.  Relationships                                d.  Printings

                  B.  Fill in the blanks using the words given below:

                                               Hints


                                                 Select query, Edit, Design, Relationship, Layout

                     1.  ......................... and ......................... are the two views in which a form can be displayed.

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

                     3.  ......................... 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 ......................... → Run Query.

                  C.  Write ‘T’ for true and ‘F’ for false.

                     1.  You can run the query only once.                                                   ......................

                     2.  Navigation Bar is on the right of Form window.                                     ......................

                     3.  A foreign key is a column in one table that must match primary key of the
                        other table.                                                                        ......................


                     4.  Design view is used to change the appearance of the form.                          ......................

                     5.  The data can be displayed in either descending or ascending during the run time.   ......................
                  D.  Match the columns.

                           Column A                                      Column B

                      1.   Layout View                               a.  Navigation Bar


                      2.   Last Record                               b.  Query



                      3.   Foreign Key                               c.  Form


                      4.   Crosstab                                  d.  Relationship



               46       Plus (Ver. 3.2)-VIII
   43   44   45   46   47   48   49   50   51   52   53