Page 96 - iPlus_Ver_2.0_class_7
P. 96

To Sum Up

                          A collection of programs required to store and retrieve data from a database is called
                         a Database Management System (DBMS).
                          There are mainly two types of database—Flat File Database and Relational Database.

                          Table is a group of related data organised in columns and rows in a database.
                          A set of values for the fields is called a record.
                          Primary key is a unique field by which the records are uniquely identified in a table.
                          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.




                                                            Exercise


                                                        Section A (Objective)
                  A.  Tick (3) the correct option.

                     1.  Name the 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



                    94
                         iPlus (Ver. 2.0)-VII
   91   92   93   94   95   96   97   98   99   100   101