Page 108 - TP_iPlus_V2.1_Class7
P. 108

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

                                              Hints: Criteria, Action, Layout, Primary key


                      1.  ................................ query creates a new table or alters your data by adding, deleting, updating, and
                         appending data from it.

                      2.  To create a relationship between two tables, we first need to create a ................................ in both
                         tables.

                      3.  ................................ parameter of Query window is used to display the condition on the basis of which
                         the records will be filtered.
                      4.  The Form Design window appears with the first record of the table in the ................................ view.

                  C.  Write ‘T’ for true and ‘F’ for false.
                      1.  By default, the form contains first three field labels from the table and their
                         corresponding text boxes.                                                        ...........................

                      2.  The appearance of the form can be changed by using the various options
                         available on the Design and Format tabs.                                         ...........................
                      3.  The Query Design command is present under the Queries group on the Query tab. ...........................

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

                      5.  The key that uniquely identifies the records in a table is called Primary key.   ...........................
                  D.  Match the following columns correctly:

                         Column A                               Column B

                      1. Multiple Items                      a.  Query
                      2. Parameter                           b. Descending or Ascending order

                      3. Background Image to Form            c. Form

                      4. Sort                                d. Format Tab


                                                        Section B (Subjective)
                  A.  Short answer type questions:
                      1.  Name the three main views in which a form can be displayed.

                      2.  Name the four new tabs that appear on the ribbon of the Report window.
                      3.  Define reports.

                  B.  Long answer type questions:
                      1.  Explain the types of queries in Access.
                      2.  How can you set up relationship between two tables.
                      3.  Explain the types of basic forms available in Access.






                   106
                         iPlus (Ver. 2.1)-VII
   103   104   105   106   107   108   109   110   111   112   113