Page 107 - Trackpad_ipro 4.1_Class7
P. 107

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

                        a. Structure                                      b. Binding
                        c. Relationship                                   d. None of these


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

                     2.  You cannot insert a picture in the form.                                    ................................
                     3.  Design View is used to change the appearance of the form.                   ................................

                     4.  You can set multiple queries in a form.                                     ................................
                     5.  Select query allows us to retrieve data from a table.                       ................................

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

                                       Hints


                                          Layout view, Title, Run, Foreign key, Logo, Relationship

                     1.  ................................ and ................................ are the commands present in the Header/Footer

                        group on the Design tab.
                     2.  ................................ is used to change the appearance and size of various controls of a form.

                     3.  ................................ is established between two tables based on the common field.

                     4.  After creating the query, we need to run the query by clicking on the ................................
                        button.
                     5.  The field in the first table is called the primary key, and the same field in the second table

                        is called the ................................ .




                  Let's Do            It                                                    Section B (Subjective)



                 A.  Short answer type questions.
                     1.  What is a form in Access?

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

                     2.  Name any two types of query.
                        ...................................................................................................................................................................................

                     3.  Name the three main views in which a form can be displayed.

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

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





                                                                                               More on Access    105
   102   103   104   105   106   107   108   109   110   111   112