Page 59 - TP_Prime_V2.2_Class8
P. 59

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

                        (i)  Field                                            (ii)  Sort

                        (iii)  Or                                             (iv)  Criteria

                     d.  When you create a form in Access, by default it appears in which view?

                        (i)  Design View                                      (ii)  Datasheet View

                        (iii)  Layout View                                    (iv)  Form View

                 2.  Write ‘T’ for true and ‘F’ for false.                                                                  MORE ON ACCESS

                     a.  You can run the query only once.                                             ___________

                     b.  You cannot insert a picture in the form.                                     ___________

                     c.  By using query, you are able to view the exact data that you want.           ___________
                                                                                                                          57
                     d.  You can set the multiple query in a form.                                    ___________

                     e.   Design View is used to adjust the design of your form.                      ___________


                   Evaluation Time


                 1.  Fill in the blanks using the hints given below:

                                       Action query,   Title,   Run,   Logo,   Primary key

                     a.   _________ and _________ are the commands present in the Header/Footer group on the
                        Design tab.

                     b.   _________  creates  a  new  table  or  alters  your  data  by  adding,  deleting,  updating  and
                        appending data from it.

                     c.  The field in the first table is called the______________.

                     d.  After creating the query, we need to run the query by clicking on the _________ button.

                 2.  Short answer type questions.

                     a.  What is a form in Access?

                     b.  Give any one use of the report object in Access.

                     c.  Name the three main views in which a form can be displayed.

                 3.  Long answer type questions.

                     a.  Differentiate between query and report.

                     b.  Write the steps to create a report.
   54   55   56   57   58   59   60   61   62   63   64