Page 95 - Trackpad_ipro 4.1_Class7
P. 95

Query  allows you to retrieve  information from a table based on some criteria  or
                       condition.
                         The final result of the manipulated data that comes from tables or queries in a DBMS
                       is known as the report.
                         A form is a database object used to create a user interface to enter or update a record
                       in a table that is connected to it.




                   OneOne Touch          Learn                                              Section A (Objective)



                 A.  Tick (3) the correct option.

                     1.  What name is given to a group of related data organised in columns and rows in a database?
                        a. Query                                         b. Sorting

                        c. Report                                        d. Table

                     2.  Which of the following is a unique field in a table?
                        a. Primary key                                   b. Secondary key

                        c. Name field                                    d. None of these

                     3.  Which of the following is a database object used to display data from a table in a formatted
                        way?
                        a. Query                                         b. Report

                        c. Form                                          d. Wizard

                     4.  Which data type automatically stores a sequential number for every record in a table?
                        a. Serial                                        b. Autofill

                        c. AutoNumber                                    d. Time/date

                     5.  Which of the following options can be used to create a table?
                        a. Design View                                   b. Templates

                        c. Datasheet View                                d. All of these

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

                                               Hints


                                                  fields, sorting, form, primary, navigation


                     1.  ................................ allows us to view all the records from the table one by one.
                     2.  The columns in a table represent ................................ .

                     3.  The ................................ key is defined in order to show the uniqueness of the data.



                                                                           Database and DBMS—An Introduction     93
   90   91   92   93   94   95   96   97   98   99   100