Page 107 - TP_iPlus_V2.1_Class7
P. 107

#Digital Literacy
                       Let’s CatCh Up


                   Define the following terms:
                   1.  Field                  _____________________________________________________________________

                   2.  Sort                   _____________________________________________________________________
                   3.  Table                  _____________________________________________________________________
                   4.  Or                     _____________________________________________________________________





                    To Sum Up


                         A form is a database object used to create, edit, and display data stored in tables in a
                         user-friendly manner.
                         A query is the most important object provided by Access that can give you information
                         that you might not be able to find by looking at the table directly.
                         A report in Access is a feature which allows you to organise and present your data in
                         a user-friendly format so that it can be printed.
                         An association between two tables on the basis of a common field is called a relationship.



                                                           Exercise


                                                       Section A (Objective)

                 A.  Tick (3) the correct option.
                     1.  Which view allows you to enter, edit, and view data in a form?
                        a. Design View                                  b. Layout View

                        c. Form View                                    d. Datasheet View

                     2.  To place the image of the company/ organisation, choose the ................................ option.
                        a. Logo                                         b. Title

                        c. Image                                        d. Picture

                     3.  Which type of form should be used when you want to show form in two sections.

                        a. Multiple Items                               b. Datasheet

                        c. Split form                                   d. Modal Dialog

                     4.  What type of query prompts you for input before it runs and uses the input as criteria that controls
                        the result?
                        a. Select Query                                 b. Crosstab Query

                        c. Action Query                                 d. Parameter Query



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