Page 97 - Trackpad_ipro 4.1_Class7
P. 97

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

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

                 D.  Application-based questions.
                       1.   Ranjeet  is  working  on  a  database  of  a  school.  He  wants  to  view  all  the  records  in  a
                        sequential manner either in ascending or descending order. Suggest a feature of Access
                        that can help him do this.
                     2.   Jennifer is a student who wants to keep track of her monthly expenses. She
                        decides to use a computer program that allows her to create a database with
                        columns like 'Date', 'Item', 'Amount', and 'Category'. Which type of database
                        is Sarah most likely to use track her monthly expenses, and can you name an
                        example of this type of database?

                 Higher Order Thinking Skills (HOTS)                                      #Interdisciplinary

                     1.   To  determine  which  students  scored  above  90%  on  their  last  computer  test,  which
                        database object should be used to retrieve this information?

                     2.   When entering details about new students into an Access 2019 table, where within the
                        Access window should the student information be typed?



                   Crack The            Code                                              #Experiential Learning


                 Find six terms related to Access 2019 in the following grid:

                                              P  A   B   E   A  U   T   B   D   E  Z   L

                                              R   S  N   L   S  O   M   E   M  N   D   O
                                              I  M   O   O   Z  N   L   A   D   F  A   R
                                             M    T  Q   U   E   R  Y   L   M   L  T   Q
                                              A   L  M   S   F   E  T   O   M  Q   A   B
                                              R  Z   Y   U   L   P  M   T   A  Q   B   F
                                              Y  X   L   N  M   O   S   A   L   A  A   M

                                              K   S  U   V   P   R  T   B   M   R  S   Z
                                              E   L  L   O   P   T  S   L   N   F  E   A
                                              Y  M   N   F   O   R  M   E   L   Z  Y   B

                           SDG Activity




                    Create a database in Access to track and analyse waste management in
                    your school. Input data on daily waste generated, recycled, and disposed
                    of, then generate reports to identify patterns and suggest ways to reduce
                    waste, promoting responsible consumption and production. Discuss your
                    findings with your class to propose sustainable practices.





                                                                           Database and DBMS—An Introduction     95
   92   93   94   95   96   97   98   99   100   101   102