Page 96 - iPrime_V2.2_class7
P. 96

Let's Do           It                                                    Section B (Subjective)



                  A.  Write a short note on the following:

                      1.  Primary key     .................................................................................................................................
                      2.  Report          .................................................................................................................................

                      3.  Query           .................................................................................................................................
                      4.  Form            .................................................................................................................................

                  B.  Short answer type questions.

                      1.  What is the process of adding and deleting the records from the database?
                      2.  Write the names of any four data types in Access.

                  C.  Long answer type questions.
                      1.  What are the advantages of the Database Management System?

                      2.  Explain the types of views in a database.

                      3.  What are the naming conventions for writing a field name in a database?

                  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?


                                                                                                      Interdisciplinary
                  Higher Order Thinking Skills (HOTS)

                      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 2016 table, where within the Access
                         window should the student information be typed?













                  94     Touchpad iPRIME (Ver. 2.2)–VII
   91   92   93   94   95   96   97   98   99   100   101