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

