SESSION 5: CREATE FORMS AND REPORTS USING WIZARD

 

Unit – 3 DBMS

SESSION 5: CREATE FORMS AND REPORTS USING WIZARD

 

Q1. What is Form in OpenOffice Base?

Ans. A form provides the user a systematic way of storing information into the database.

 

Q2. Name the interface which lets users to view, enter, and change data directly in database.

Ans. Form

 

Q3. Write two ways of creating form in Open Office Base.

Ans. Two ways of creating form in Open Office Base are :

a. Create form in design view

b. Use Wizard to create form

 

Q4. Can we enter the data in table using forms?

Ans. Yes

Q5. What do you mean by Report in Open Office Base?

Ans. A report helps to display the data in a summarized manner. It is used to generate the overall work outcome in a clear format.

 

Q6. Differentiate between Forms and Report.

Ans.

Form

1. It is a way of storing data into a database

2. Values entered in the form can be modified

Report

It is a way to display data in a printed form.

Values in the report can not be modified.

 

Q7. Name the two types of report created in OpenOffice Base.

Ans. Two types of report created in OpenOffice Base are:

a. Static Report

b. Dynamic Report

Q8. What do you mean by static report?

Ans. A report which do not show any change if we make any changes in the data of the table.

 

Q9. What do you mean by dynamic report?

Ans. A report which shows the corresponding changes which we make in the data of the table.

 

Q10. Can we enter records by report?

Ans. No

 

Comments

Post a Comment

Popular posts from this blog

SESSION 2 : CREATE AND EDIT TABLES USING WIZARD AND SQL COMMANDS

  Unit – 3 DBMS SESSION 2 : CREATE AND EDIT TABLES USING WIZARD AND SQL COMMANDS   Q1. What do you mean by RDBMS? Ans. RDBMS stands for Relational Database Management System. It is a database management system which is based on relational model.   Q2. Define the following terms : 1 Table 2. Fields 3. Records Ans. Table : A table is a set of data elements that is organized in vertical columns and horizontal rows. Fields : A field is a set of data values of a particular simple type, one for each row of the table. Records : A row also called a Record or Tuple represents a single, data item in a table.   Q3. What are the two ways of creating table in OpenOffice Base. Ans. Two ways of creating table in OpenOffice Base are : a. Create table in design view b. Use Wizard to create table.   Q4. What do you mean by Data type? Give example of two data type used in OpenOffice Base. Ans. Datatypes are used to identify ...
Read more

SESSION 3: PERFORM OPERATIONS ON TABLE

  Unit – 3 DBMS SESSION 3: PERFORM OPERATIONS ON TABLE   Q1. What do you mean by Datasheet View? Ans. A view in which new data can be inserted and inserted data can be modified or removed in a table is called datasheet view   Q2. What do you mean by design view? Ans. A view in which we can change the structure of the table is called design view.   Q3. Write steps to open table in design view. Ans. Steps to open table in design view are : Open the Open Office Base Right click on the table which we need to open. Select option Edit from popup menu. Required table will open in design view   Q4. What do you mean by Field Property in Base? Ans. Those properties which determine the characteristics and behavior of fields are called field property.   Q5. Name two properties of Numeric type data. Ans. Two properties of Numeric type data are : Auto Value Length   Q6. Name two properties of Character type ...
Read more