Page 97 - iPlus_Ver_2.0_class_7
P. 97
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. ................................ are represented by the columns in a table.
3. ................................ key is defined in order to show the uniqueness of the data.
4. ................................ is used to sort the data either in ascending or descending order.
5. ................................ buttons are used to navigate through the records.
C. Write ‘T’ for true and ‘F’ for false.
1. Flat file database and relational database are the two types of databases. ................................
2. Navigation Pane is present on the right side of the Access window. ................................
3. The maximum size of the Number data type is 32 bytes. ................................
4. Field names can begin with an underscore ( _ ). ................................
Section B (Subjective)
A. Short answer type questions:
1. What is the process of adding and deleting the records from the database?
2. Write the names of any four data types in Access.
3. Write a short note on the following:
a. Primary Key
b. Report
c. Query
d. Form
B. Long answer type questions:
1. What are the advantages of the Database Management System?
2. Explain the types of views in a database.
3. What are the rules for writing a field name in a database?
C. Competency-based/Application-based question:
Ranjeet is working on a database for a school. He wants to view all the records in a sequential
manner, either in ascending or descending order. Suggest a feature of Access that can help him do
this.
95
Database and DBMS—An Introduction

