Page 98 - TP_iPlus_V2.1_Class7
P. 98

B.  Fill in the blanks using the words given below.

                                        Hints: Record, Design, Datasheet, Yes/No, Database1

                     1.  The default view of the table is ................................ view.

                     2.  The ................................ data type is used for the fields with Boolean values.
                     3.  A set of values for the fields is called a ................................ .
                     4.  The default file name of Access file is ................................ .

                     5.  The records are not visible in ................................ view.

                  C.  Write ‘T’ for true and ‘F’ for false.
                     1.  Embed datatype is used to embed an object created in another application, such as
                         Word, Excel or PowerPoint.                                                    ................................

                     2.  Templates are built-in database formats designed for specific tasks.          ................................
                     3.  There can be multiple primary keys in a table.                                ................................

                     4.  RDBMS minimizes the duplication of data.                                      ................................
                     5.  Table is also knowns as Relation.                                             ................................


                                                        Section B (Subjective)
                  A.  Short answer type questions:
                     1.  Which database object is specially designed to display or print the data in a formatted way?

                     2.  What is the name given to the first field in Access?
                     3.  How can you switch between the two views of Access?

                  B.  Long answer type questions:

                     1.  Write the steps of sorting the records in a table.
                     2.  Write the steps of creating a table using design view.

                     3.  Write steps to add a record in a table.
                  C.  Competency-based/Application-based questions:

                     1.   Sonal is creating a table to store the student details. What criteria should she
                         should keep in mind while choosing the Primary key?

                     2.   Maria needs to extract specific information from a table based on certain conditions, such as
                         finding students who scored above 90 in their exams. Which database object should she use to
                         accomplish this.

                  Higher Order Thinking Skills (HOTS)                                      #Digital Literacy
                  1.   Neha wants to manage student records for her school using a modern approach than traditional
                     methods. She is looking for software that allows her to add, edit, search and delete data. What software
                     would you recommend.
                  2.   Categorise the valid field names and invalid field names in Microsoft Access from the following set of
                     field names:
                      (i) Student_Name    (ii) grade.7     (iii) phone#     (iv) First name    (v) Last “Name”


                    96
                         iPlus (Ver. 2.1)-VII
   93   94   95   96   97   98   99   100   101   102   103