Page 92 - iPro_trackGPT_V5_Class7
P. 92

2.  Primary key plays a very important role in a database. Justify the statement.

                         ...................................................................................................................................................................................


                         ...................................................................................................................................................................................

                         ...................................................................................................................................................................................

                      3.  Discuss the key components of Microsoft Access 2021 window and their functions.

                         ...................................................................................................................................................................................

                         ...................................................................................................................................................................................


                         ...................................................................................................................................................................................

                  C.  Application-based questions.

                      1.  Your teacher wants a database of students' marks with automatic calculations of total
                         and percentage. How can you set this up in Access?

                      2.  You are working on an inventory system for a store. How would you prevent
                         duplicate entries in the product database?



                                                                                   #Problem Solving & Logical Reasoning
                  Higher Order Thinking Skills (HOTS)
                      1.  An organisation loses access to its database. What problems could arise, and how can
                         these issues be prevented?
                      2.  Can a database help in detecting fraud or anomalies in financial transactions? How?






                      Code Clues                                                   #Experiential Learning
                                                                                   #Digital Literacy


                  Locate eight terms related to operating systems in the following grid:

                                               W P     P  L   A   C  C   E   S  S M B
                                                T  R D    K   P  U   R   V G H      I  R
                                               D   I   H  P   T   E M P      L  A   T  E

                                               B M K M A          L  U   R N D      T  P
                                               D A     T  A   B   A  S   E  O   E   B O
                                               D R W L        L   P Q C     X   Z M R
                                               G   Y   H  S   E   T  V O     S  H N    T

                                               D   K   S M L      Y Q R     Z   H U N
                                               H   E   J  F   I   E  L   D  P   L M G
                                               K   Y   I  Y Q W C        X   I  N G    T



                    90    TrackGPT iPRO (V5.0)-VII
   87   88   89   90   91   92   93   94   95   96   97