MS-Access Database Important Question Answer Class 10 Computer Science  

1.       What is data?

Ans: Data is any raw facts or figures collected from different sources like reports, quires or questionnaires.

 

2.       What is an information?

Ans: The processed data that gives meaning is called an information.

 

3.       What is a database?

Ans: A database is an organized collection of data related to a particular subject in a systematic manner.    

 

4.       What is database management system?

Ans: The system or a software that helps to create, manage, and modify the database is called database management system.  

 

5.       What is RDBMS? Give example.

Ans: RDBMS (Relational Database Management System) is the software that uses tables to store the data of the database system. Example: MS-Access, Oracle, etc.

 

6.       What is MS-Access?

Ans: MS-Access is a RDBMS software that creates and manages the database.

 

7.       What are the objects of MS-Access?

Ans: The objects of MS-Access are listed below:

a.       Table

b.       Query

c.       Form

d.       Report

e.       Macros  

 

8.       List any four data types of MS-Access.

Ans: The four data types of MS-Access are listed below:

a.       Text

b.       Memo

c.       Autonumber

d.       Date/Time

 

9.       What is a primary key? List its uses.

Ans: Primary key is the field in a database table that uniquely identifies each record of the table.

        Its uses are as follows:

a.       To identify each record uniquely.

b.       To prevent data redundancy.

c.       To create relationship between tables.

 

10.   What is a foreign key?

Ans: A foreign key is a field in a child table that refers to the primary key of a master table.

 

11.   What is a table in MS-Access?

Ans: A table is an object of MS-Access that stores that data of the database.

 

12.   What is form in MS-Access?

Ans: Form is an object of MS-Access that helps to add, view, edit and delete the records of a database.

 

13.   What is Query?

Ans: Query is an object of MS-Access that helps to retrieve the required record of the database.

 

14.   What is a report?

Ans: A report is an important object of MS-Access that helps to print the record of the database.

 

15.   Why is a table called primary building block of database?

Ans: A table is called a primary building block of a database because all the records of the database are stored in a table.

 

16.   What is a validation rule?

Ans: Validation rule is a field property that helps to store the specified data in a particular field of the database table.

 

17.   What is input mask?

Ans: Input mask is a field property that allows to specify a specific pattern for all the data to be entered in a field of a database table.

 

18.   What is indexing?

Ans: Indexing is the property of a field that helps to speed up the searching and sorting of the database records based on key values.

 

19.   What is sorting?

Ans: Sorting refers to arranging the database records either in ascending or descending order.

 

20.   What is filtering?

Ans: Filtering is the process of retrieving and viewing the required record from the database based on certain criteria.   

 

21.   What is a field in a table?

Ans: A field is a column of a database table.

 

22.   What is a record?

Ans: A record is a row of a database table. It is also called as tuple.