Page 107 - iPlus_Ver_2.0_class_7
P. 107

#Digital Literacy     4.  What is an association between two tables on the basis of a common field called?
 Let’s CatCh Up         a. Structure                                    b. Binding


 Define the following terms:     c. Relationship                        d. None of these

 1.  Field    _____________________________________________________________________  B.  Fill in the blanks using the words given below.
 2.  Sort     _____________________________________________________________________  Hints: Select query, Title, Run, Logo, Relationship

 3.  Table     _____________________________________________________________________
                     1.  ................................ and ................................ are the commands present in the Header/Footer group on
 4.  Or     _____________________________________________________________________
                        the Design tab.
                     2.  ................................ retrieves data from one or more tables.

                     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.

                 C.  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.  The data can be displayed in either descending or ascending
                        order during the run time.                                                    ................................

                 D.  Match the following columns correctly:
                        Column A                               Column B

                     1. Layout View                         a.  Header/Footer

                     2. Logo                                b. Query
                     3. Foreign Key                         c. Form

                     4. Crosstab                            d. Relationship

                                                       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.
                 B.  Long answer type questions:
                     1.  Differentiate between query and report in Access.

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





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