Page 48 - TP_Prime_V2.2_Class8
P. 48

b.  The columns in a table represent _______________.

                      c.  _______________ is used to define the type of data that can be entered in that field.
                      d.   _______________ is used to enter the name of the field to be displayed as a column

                          heading in the table.

                      e.  _______________ buttons are used to navigate through the records.
                    2.  Short answer type questions.
           Prime (Ver. 2.2)-VIII      3.  Long answer type questions.

                      a.  What is the process of adding and deleting the records from the database?

                      b.  Write the names of any four data types of Access.






                       a.  What are the advantages of the Database Management System?
                      b.  Explain the types of views in a database.
                      c.  What are the naming conventions for writing a field name in a database?
          46
                                                                                                   21 st
                  4.  Competency-based/Application-based questions.                              Century   #Information Literacy
                                                                                                  Skills
                      a.   Ranjeet is working on a school database. He wants to view all the records in sequential

                          order, either in ascending or descending order. Suggest a feature of Access that can help
                          him do this.
                      b.   Neha is inputting data for a customer management database. What data types

                          should she use for fields like customer name, phone number, and registration
                          date?

                      Activity Time                                                                 Century   #Critical Thinking
                                                                                                      21 st
                                                                                                      Skills
                  Find six terms related to Access 2016 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
   43   44   45   46   47   48   49   50   51   52   53