Page 102 - iPro_trackGPT_V5_Class7
P. 102

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

                         a. Report                                       b. Query

                         c. Relationship                                 d. Form

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


                                             Form Design, Modal Dialog, Action query, Primary Key



                      1.  To create a relationship between two tables, you need to drag and drop the ......................
                         field from one table to the corresponding field in the other table.
                      2.  ...................... window appears with the first record of the table in Layout view.

                      3.  ...................... is useful in creating navigation menus or alert messages.
                      4.  ...................... creates a new table or alters your data by adding, deleting, updating, and
                         appending data from it.

                  C.  Match the following terms:

                      Column A                                  Column B
                      1.  Form View                             a.  Prompts for input before running

                      2.  Multiple Items Form                   b.  Field used to connect tables through relationships
                      3.  Parameter Query                       c.  Create, edit, and display data

                      4.  Foreign key                           d.  Organise and present data for printing
                      5.  Reports                               e.  Displays multiple records at once

                  D.  Write ‘T’ for true and ‘F’ for false.
                      1.  A form in Access can be used to add, edit, and display data in a
                         user-friendly manner.                                                        ................................

                      2.  The Layout View in a form is used to adjust the design and structure
                         of the form, including headers and footers.                                  ................................
                      3.  A Crosstab Query displays data in a single-column format, similar
                         to a form.                                                                   ................................
                      4.  The Logo command in the Design tab allows you to change the
                         form's background color.                                                     ................................

                      5.  The Query Design command is found under the Create tab in Access.           ................................



                      Answer Arcade                                                             Section B (Subjective)


                  A.  Short answer type questions.

                      1.  What is a Split Form in Access?
                         ...................................................................................................................................................................................



                   100    TrackGPT iPRO (V5.0)-VII
   97   98   99   100   101   102   103   104   105   106   107