Page 106 - iPlus_Ver_2.0_class_7
P. 106

#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 is used to adjust the design of your form?
                         a. Form view                                    b. Design view


                         c. Layout view                                  d. None of these
                      2.  What is an organised way of creating, editing, and displaying data from a table called?

                         a. Report                                       b. Form

                         c. Query                                        d. Relationship

                      3.  Which parameter displays the data in either descending or ascending order during the run time
                         in the query window?

                         a. Field                                        b. Or

                         c. Sort                                         d. Criteria





                   104
                         iPlus (Ver. 2.0)-VII
   101   102   103   104   105   106   107   108   109   110   111