Page 97 - TP_iPlus_V2.1_Class7
P. 97

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.  Which of the following is an example of Flat File Database.

                        a. Access                                       b. SQL
                        c. Excel                                        d. Oracle


                    2.  Which database object is used to retrieve information from a table on the basis of some criteria.
                        a. Table                                        b. Query

                        c. Form                                         d. Report

                    3.  The long bar present below the Title bar is called ................................ .

                        a. Menu Bar                                     b. Ribbon

                        c. Tabs                                         d. Group

                    4.  Which data type is used to store a large amount of text or combination of text and numbers.
                        a. Number                                       b. OLE

                        c. Short Text                                   d. Long Text


                    5.  By default, Access sets the Lookup fields to the ................................ data type.
                        a. Number                                       b. AutoNumber

                        c. Short text                                   d. Long Text





                                                                                                                  95
                                                                            Database and DBMS—An Introduction
   92   93   94   95   96   97   98   99   100   101   102