Page 28 - Code Craft Computer-8
P. 28

3.   _________  lets  you  find  and  work  on  the  data  from  one  or
                          multiple tables according to the specified conditions.
                          a. Queries                      b. Forms

                          c. Tables                       d. Reports                           3.   a   b    c    d
                     4.   Data _________ means that the data is accurate and consistent
                          in the database.                                                     4.   a   b    c    d

                          a. Integrity                    b. Consistency
                          c. Both a and b                 d. None of these
                                                                                               5.   a   b    c    d
                     5.  The extension of MS Access 2021 is _____________.
                          a. .accd                        b. .accdb

                          c. .acc                         d. .acsb

              B.     Gap-fill exercise.

                     1.   Data __________ helps in organising data into various types so that a relation can be set
                          for accessing the information.
                     2.   Data __________ is ensured in a database because there is no data redundancy.

                     3.   Databases in MS Access 2021 are composed of __________ main objects.
                     4.   __________ are the building blocks of a database.

                     5.   If forms are the input, then reports are for __________.

              C.     True and False assessment.
                     1.   Facts related to any object in consideration are collectively known as data.

                     2.   Value is the data item which is the smallest unit in a database.

                     3.   Data  retrieval  helps  in  insertion,  modification  and  deletion  of  the  data  in  the
                          database.
                     4.   In a database, users can share the data amongst themselves.

                     5.   Navigation pane is the area to the left of the window, and it displays your database
                          objects.


              D.     Give appropriate responses to the questions.
                     1.   What do you understand by the term DBMS?

                     2.   Explain RDBMS.
                     3.   Explain any two advantages of a database.

                     4.   Define the term table.
                     5.   What do you mean by the term 'queries'?









                                                                 28
   23   24   25   26   27   28   29   30   31   32   33