Page 108 - iPrime_V2.2_class7
P. 108

4.  An  association  between  two  tables  on  the  basis  of  a  common  field  is  called
                         ................................ .

                         a. Structure                                    c. Relationship
                         b. Binding                                      d. Printing


                  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.  Give any one use of the report object in Access.
                      3.  Name the three main views in which a form can be displayed.

                  B.  Long answer type questions.

                      1.  Differentiate between query and report in Access.

                      2.  Write the steps to create a report.
                      3.  Write the names of any four parameters which are displayed at the bottom of the Query
                         window while creating a query.



                 106     Touchpad iPRIME (Ver. 2.2)–VII
   103   104   105   106   107   108   109   110   111   112   113