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

