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

