Page 101 - iPro_trackGPT_V5_Class7
P. 101

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
























                       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.






                     Tech Trivia                                                               Section A (Objective)


                 A.  Tick ( ) the correct option.

                     1.  What does the 'Criteria' row in a query design specify?

                        a. The sorting order of records

                        b. The fields to be displayed

                        c. The condition for filtering records

                        d. The table name

                     2.  Which of the following is NOT a type of form in Microsoft Access?

                        a. Multiple Items                               b. Crosstab

                        c. Datasheet                                    d. Modal dialog

                     3.  In Access, the ...................... command is used to create a new query.

                        a. Form Design                                  b. Report

                        c. Crosstab Query                               d. Query Design



                                                                                               More on Access    99
   96   97   98   99   100   101   102   103   104   105   106