Page 107 - iPrime_V2.2_class7
P. 107

Report created

                 The report will be created for the table that is currently open.
                    Reb            t


                        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 relationship.




                   OneOne Touch           Learn                                             Section A (Objective)



                 A.  Tick ( ) the correct option.
                    1.  To create relationship between two tables, make sure that both tables have a
                       ................................ key.

                       a. Primary Key                                  c. Foreign Key
                       b. Select Query                                 d. None of these

                    2.  ................................ is an organised way of creating, editing and displaying data from the
                       table.

                       a. Report                                       c. Query
                       b. Form                                         d. Table


                    3.  The ................................ parameter displays the data in either descending or ascending order
                       during the run time in the query window.
                       a. Field                                        c. Sort

                       b. Or                                           d. Criteria


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