Page 108 - iPlus_Ver_2.0_class_7
P. 108

C.  Competency-based/Application-based questions:
                      1.  Sahil wants to display data stored in a table in a user-friendly manner. Which feature of Access can
                         he use to do so?

                      2.  You want to view the information in two categories at once. Which query will you create to do so?
                      3.  Assertion (A): Anisha wants to compile data from three tables stored in a database using Microsoft
                         Access.

                         Reason (R): She can accomplish this by using the "Relationship" feature in Microsoft Access.
                     (a)  Both Assertion (A) and Reason (R) are true and Reason (R) is a correct explanation of Assertion (A)

                     (b)  Both Assertion (A) and Reason (R) are true and Reason (R) is not a correct explanation of Assertion(A)
                     (c)  Assertion (A) is true and Reason (R) is false
                     (d)  Assertion (A) is false and Reason (R) is true


                                                                                      #Problem Solving & Logical Reasoning
                           Crack The Code                                             #Digital Literacy



                   Solve the crossword on the basis of given clues.                             1
                       Clues:                                                                1 F

                       Across                                                                                  2
                       1.  Query parameter that forms the first row of the design grid.  3      R              R
                                                                                      4
                       3.  The key that uniquely identifies the records in a table.

                       5.  The form view that gives a detailed view of the structure
                                                                               5      E         G
                          of the form.
                       6.  The feature of Access that searches and displays data
                          from more than one table.                    6              R

                       Down
                       1.  The key that matches the primary key.
                       2.  It is an association between two tables on the basis of
                          a common field.

                       4.  The feature  of Access that  organises and  presents
                          data in a user-friendly format for printing.







                                                                                      #Experiential Learning
                     Let’s Explore



                            Surf the Internet and find out about more uses of Access. Discuss with your teacher.






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