Unit 3 Relational Database Management System (Basic) Class 10 Info Tech 402 (IT) NCERT Solution

/ Class 10 Info Tech NCERT Solution / By /
Unit 3 – Relational Database Management Systems (Basic)
Class 10 Info Tech 402 NCERT Book exercise Solution

SESSION 5: CREATE FORMS AND REPORTS USING WIZARD

ASSESSMENT

Fill in the blanks:

1. To create a form you need to select FORMS option available under Database section.

2. A FORMS is helps to collect specific information from the pool of data in the database.

3. REPORTS is used to display the display the summary of data.

4. FORMS are the interfaces with which the user interacts.

5. Data from multiple tables can be stored in Query.

Short Answer Questions:

1. Why there is a need to create Forms?

Answer: Forms allows to collect the information in a specific layout as well as through forms you can view, enter and change the data directly in database objects..

2. What is the purpose of creating Reports?

Answer: The main purpose of Forms to collect the data in systematic way. It provides an interface which allow to enter data, view data, modify data as well as delete data directly in database objects like table.

3. What are the prerequisites to create a Form and Reports?

Answer: To create a forms in OpenOffice.org Base, first of all you need to create a Database. After that you need to create table according to the requirements i.e. on the basis of data you want to collect.

To create reports, you must have at least one table with records under your database. Because Report helps to display the data in a summarized manner.

4. Differentiate between Forms and Reports.

Answer: Forms is an interface, which provide a facility to enter records, view records, modify records, and delete records.

Reports help to display the data/records in specific manner or format i.e. summary of data.

5. Can a form displays data from queries?

Answer: Yes

6. In how many ways Forms and Reports can be created in a database?

Answer: Forms can be created in two ways : -(i) Create Form in (ii) Use Wizard to create form.

Reports can be created in one way :- (a) Use Wizard to create report

Class 10 Info Tech 402 NCERT Book Exercise Solution

Unit 3 : RDBMS (Basic) Question Answer and MCQ’s

Unit 4: Web Applications and Security Question Answer and MCQ’s

Pages: 1 2 3

Related Posts

You cannot copy content of this page

Scroll to Top