Page 103 - iPro_trackGPT_V5_Class7
P. 103

2.  Identify the purpose of a Select Query in Access.

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

                        ...................................................................................................................................................................................
                     3.  Differentiate between a Primary Key and a Foreign Key.

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

                        ...................................................................................................................................................................................
                 B.  Long answer type questions.

                     1.  Explain  the  different  views  available  for  forms  in  Microsoft  Access  and  describe  the
                        purpose of each view.
                        ...................................................................................................................................................................................

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

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

                     2.  Discuss the different types of queries in Microsoft Access.

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

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

                     3.  Mention the two ways to format a form in MS Access.

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

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

                 C.  Application-based questions.

                     1.  Your teacher has asked you to demonstrate how to link two related tables
                        in Access. Explain the steps you would take and the benefits of creating
                        this relationship.

                     2.  You and your friend have been given a task to design a database for managing a
                        school’s library system. How would you use Forms, Queries, and Reports to ensure
                        efficient data management and user interaction?



                                                                                  #Digital Literacy
                 Higher Order Thinking Skills (HOTS)
                     1.  How can the use of forms in Access improve data entry and management for large
                        databases?
                     2.  How does setting up relationships between tables in a database enhance data integrity
                        and reduce redundancy?





                                                                                               More on Access    101
   98   99   100   101   102   103   104   105   106   107   108