Unit 3: Database Management System

using LibreOffice Base

Chapter 8: Introduction to Database Management

System

Q1. Which of the following can not be considered as an example of a database?

(a) Dictionary
(b) Telephone directory
(c) Marks Register
(d) Newspaper
Ans. (d) Newspaper

Q2. Which of the following is NOT a DBMS?

(a) MS Access
(b) open office base
(c) MS Excel
(d) MySQL
Ans. (c) MS Excel

Question 3:
DBMS stands for __________.
(a) Data and Books Management System
(b) Database Management System
(c) Duplicate Books Management System
(d) Data Management Multi System
Answer: (b) Database Management System

Question 4:
Which of the following data models sets a relation between the two or more
tables?
(a) Relational Data Model
(b) Network Data Model
(c) Hierarchical Data Model
(d) Connection Data Model
Answer: (a) Relational Data Model

Question 5:
The details associated with an entity are called ________.
(a) Table
(b) Attributes
(c) Records
(d) Primary key
Answer: (b) Attributes
Question 6:
A ________ is represented as rows in a table.
(a) field
(b) attribute
(c) record
(d) candidate key
Answer: (c) record

Question 7:
In which of the following forms can a data value be represented?
(a) Numeric
(b) Character
(c) Alphanumeric
(d) All of the above
Answer: (d) All of the above

Question 8:
Which of the following uniquely identifies a row in a table?
(a) Primary key
(b) Alternate key
(c) Foreign key
(d) Candidate key
Answer: (a) Primary key

Question 9:
A ___________is a feature of a database using which we can enter data in a table
in an easy and user friendly manner.
(a) query
(b) report
(c) form
(d) field
Answer: (c ) form

Question 10:
A _______ is a question asked from a database.
(a) query
(b) report
(c) form
(d) field
Answer: (a) query

B. State whether the following statements are True or False.

Question 1:
A database cannot be organised.
Answer: False
Question 2:
Data is the collection of raw facts.
Answer: True
Question 3:
A table can be created without a primary key.
Answer: False
Question 4:
Two tables can be related in a network data model.
Answer: False
Question 5:
MS Access is an example of a database.
Answer: False

C. Fill in the blanks.

Question 1:
The raw facts constitutes ________.
Answer: Data
Question 2:
An ________ is a real world object about which information is to be stored in a
database.
Answer: Entity
Question 3:
The output of a query may be displayed in the form of ________.
Answer: Report
Question 4:
The data values for all the fields related to a person or object is called a ______.
Answer: Record
Question 5:
All the field values that are eligible to be the primary key are the _______ keys for
that table.
Answer: Candidate

D. Answer the following questions.

Question 1:
Define the terms:
(a) Database (b) Data redundancy (c) Report
Answer:
(a) Database: A database is a collection of logically related data items stored in an
organised manner.
(b) Data Redundancy: Duplication of data is called Data Redundancy. Same data is
stored multiple times either in same table or different table is known as Data
Redundancy.
(c) Report: The result of the query which is presented in the proper format, is known as
Report.
A report is a document that presents data in a structured and easily readable format,
often used for summarizing and analyzing data stored in a database.

Question 2:
Give one point of difference between
(a) Data and Information,
(b) Form and Query,
(c) Network and hierarchical data model
Answer: One point of difference between
(a) Data and Information:

(i) Data is an unprocessed data, while information is a processed data.

(ii) Data is the collection of raw facts, figures, and symbols, while information is the
meaningful collection of data.
(b) Form and Query:
A form is a feature of a database using which we can enter data in a table in an easy
and user-friendly manner.

A query is used to retrieve the desired information from the database. In simple terms, it
is a question asked from the database.
(c) Network and hierarchical data model

In the Network model, multiple records are linked to same master file. It is also
considered as an inverted tree.

In the Hierarchical model, the data is organized into a tree like structure.

Question 3:
Give any four advantages of a DBMS.
Answer: Advantages of a DBMS are:-
● Organised Storage: The data in the database is stored in an organised
manner.
● Data Sharing: If the same data set is required for different applications
then the database can be shared with other applications.
● Minimal Data Redundancy: Database reduce the duplication of data, i.e.
data redundancy.
● Data Consistency: By minimising data redundancy, chances of
inconsistent data being stored is reduced. Inconsistent means the mobile
number of one student is changed in one table and not changed in another
table.

Question 4:
Consider the table given below and answer the questions that follow
Table: Library
Book_Id BookName AuthorName Price Publisher
 F001 Pride and Prejudice Jane Austen 550 ABC

S004 Amazing Astronomy E. Shane 1050 ABC

C005 IT and Mankind MHA Diwaan 2500 HYM

(a) Name the fields in the given table.
(b) Which field should be made the primary key?
(c) Is there any alternate key in the table?
(d) How is primary key different from foreign key? Explain with example.
Answer:
(a) Book_Id, BookName, AuthorName, Price, Publisher
(b) Book_Id
(c) BookName
(d) The primary key is a key, which uniquely identifies the record in a table. While the
foreign key is used to make the relationship between two tables. A foreign key is a
non-key, whose value is derived from the primary key of the master table.

Chapter 9: Starting with LibreOffice Base

A. Multiple-choice questions.

Question 1:
Which of the following is NOT a type of text data type?
(a) Memo
(b) Varchar
(c) Float
(d) Char
Answer: (c) Float
Question 2:
A currency data type can only store monetary data that is in dollars.
(a) True
(b) False
(c) Neither a nor b
(d) Both a and b
Answer: (b) False
Question 3:
Which of the following data can a date data type store?
(a) Date
(b) Time
(c) Both date and time
(d) Neither date nor time
Answer: (c) Both date and time
Question 4:
Which of the following is true about LibreOffice Base?
(a) It is a spreadsheet software
(b) It is free and open-source software
(c) It can store only character data
(d) It is a licensed software.
Answer: (b) It is free and open-source software
Question 5:
Which of the following methods can be used to create a table in Base?
(a) Using a table wizard
(b) Design View
(c) Both a and b
(d) Neither a nor b
Answer: (c) Both a and b
Question 6:
The related objects of a database can be seen in ________ pane of the Base
Database window.
(a) Database
(b) Task
(c) Title Bar
(d) Menu Bar
Answer: (a) Database
Question 7:
Which is the shortcut key to open an existing database?
(a) Ctrl+ D
(b) Ctrl+O
(c) Ctrl+E
(d) Ctrl+F
Answer: (b) Ctrl+O
Question 8:
The Design view of the Table Creation window in LibreOffice Base is divided into
__________ sections or panes.
(a) 2
(b) 3
(c) 4
(d) 5
Answer: (a) 2
Question 9:
While entering records in a table, we can move to the next field by pressing the
________ key.
(a) Tab
(b) Ctrl
(c) Enter
(d) Shift
Answer: (a) Tab
Question 10:
Which of the following is true about the primary key of a table?
(a) Every table must have a primary key
(b) The data values in the primary key field cannot be duplicated.
(c) A primary key field cannot be left blank
(d) All of the above
Answer: (d) All of the above

B. State whether the following statements are True or False.

Question 1:
The text data can contain special characters.
Answer: True
Question 2:
Memo data type can be used to store descriptive data.
Answer: True
Question 3:
A Boolean data type can have two or more than two values.
Answer: False
Question 4:
We cannot store audio data in LibreOffice Base.
Answer: False
Question 5:
The properties of a field change according to the data type selected.
Answer: True
Question 6:
Field descriptions may or may not be entered while designing a table.
Answer: True
Question 7:
is pressed to move to the last record.
Answer: False
Question 8:
appears when the record is being edited.
Answer: True
Question 9:
A table once created in a database cannot be edited.
Answer: False
Question 10:
Sort dialog box can only help to sort data in ascending order.
Answer: False

D. Answer the given questions

Q1. Differentiate between:

(a) Memo and Varchar data type

Ans.
 Memo Varchar

It is used to store long alphanumeric data. It is used to store small

for example Summary of a book, review of alphanumeric data. for example
a movie etc. Name, Address etc.

It can store text data up to 64,000 It can store text data up to 255
characters. characters.

(b) Number and Decimal data type

Ans.
Number Decimal

It is used to store integers of any length. It is used to store decimal values.

for example 457, 342 for example 23.56, 458.29

(c) Design View and Datasheet view of a table

Ans.
Design View Datasheet View

This view is used to design the This view is used to enter the values
structure of the table. in the table.

In this view, we can add or delete the In this view, we can add or delete the
fields rows
Q2. Name the menu items present on the Base User Interface.
Ans. Menu items present on the Base User Interface are:
1. File
2. Edit
3. View
4. Insert
5. Tools
6. Window
7. Help
Q3. Label the components – Title Bar, Database Pane, Tasks Pane, Status Bar of
the LibreOffice Base User Interface.
Ans.
Q4. How can we define a primary key in a table?
Ans. A Primary key is a field which is unique for each and every record in a table. To
make a particular field as the primary key, place the mouse pointer before the field
name, and right click. A pop up menu appears and Select the Primary Key option. A key
icon appears before the field name indicating that it is a primary key.

Q5. Write steps to sort the table in descending order of primary key.
Ans. Steps to sort the table in descending order of primary key are:
1. Open the table in datasheet view and select the primary key on which you
want to sort.
2. From the tool bar click Sort Descending icon to sort in descending order.
3. The table will be sorted in descending order of primary key.
Q6. What is the use of navigation box with respect to tables in a database?
Ans. Navigation box is used to navigate (move) through various records of the table.
The various components of Navigation Box are as follows:
Record Selector Box – This is the text box where the currently active record number is
displayed. We may enter the record number that we want to see in this text box.

Navigation Buttons – These are used to scroll vertically in the table.

● Press |◄ button to move to the first record.
● Press ► and ◄ to move to the next and previous records respectively.
● Press ►| button to move to the last record.
 Chapter 10: Working with Multiple Tables

A. Multiple-choice questions.

Question 1:
Which of the following actions can be performed once the tables are created in a
database?
(a) Add a field in a table
(b) Rename a table
(c) Delete a table
(d) All of the above
Answer: (d) All of the above

Question 2:
Which of the following is checked by a DBMS?
(a) Redundancy
(b) Inconsistency
(c) Both (a) and (b)
(d) Neither (a) nor (b)
Answer: (c) Both (a) and (b)

Question 3:
Which of the following is required to set a relationship
between the two tables?
(a) Both the tables must be in different databases
(b) Both the tables must have a common field
(c) Both the tables must have the same name
(d) Both tables must be stored in the documents folder only.
Answer: (b) Both the tables must have a common field

Question 4:
If a record is added in a master table, which of the following is NOT true for the
transaction table
(a) The record in the master table is called the master record
(b) The corresponding record in the transaction table can only be entered once.
(c) The record in the transaction table is called the transaction record.
(d) It is possible to add a record in the master table
Answer: (b) The corresponding record in the transaction table can only be
entered once.

Question 5:
Which type of relationship exists between a student and the subjects studied by
him/her?
(a) One-to-one
(b) One-to-many
(c) Many-to-many
(d) All of the above
Answer: (b) One-to-many

Question 6:
Consider the following tables. Which type of relationship can be established
between the two tables?

(a) One-to-one
(b) One-to-many
(c) Many-to-many
(d) None of the above
Answer: (b) One-to-many

Question 7:
Which of the following menus contains the Relationship option?
(a) Edit
(b) File
(c) Tools
(d) View
Answer: (c) Tools

Question 8:
The list of tables to be added is displayed in the _____ dialog box in the
Relationship Screen.
(a) Add Tables
(b) Add Databases
(c) Both (a) and (b)
(a) Neither (a) nor (b)
Answer: (a) Add Tables

Question 9:
In the relationship design screen, the relationship between the two tables is done
using _________ operation.
(a) Click
(b) Double Click
(c) Drag and Drop
(d) Right click
Answer: (c) Drag and Drop
Question 10:
Which of the following is NOT an option that can be used to maintain referential
integrity in a database?
(a) No Action
(b) Set NULL
(c) Set Default
(d) Set Value
Answer: (d) Set Value

B. State whether the following statements are True or False.

Question 1:
Redundancy is preferred in a database.
Answer: False

Question 2:
In a table, a record for a particular entity should not be repeated.
Answer: True

Question 3:
A single field should always have only one data value.
Answer: False

Question 4:
If a table is edited, the records already entered in it are deleted.
Answer: False

Question 5:
The record in the master table should be entered before the corresponding record
is entered in the transaction table.
Answer: True

Question 6:
In one-to-many relationship, one specific record of the master table has more
than one corresponding records in the related transaction table.
Answer: True

Question 7:
The Relationship option is present in the Widows menu.
Answer: False

Question 8:
In a database, the referential integrity is maintained by the user.
Answer: False
Question 9:
A relationship is always set between the tables based on a common field.
Answer: True

Question 10:
If the master record is deleted, the transaction records will always be deleted.
Answer: False

C. Fill in the blanks.

Question 1:
A table to be edited is displayed in __________ view.
Answer: Design

Question 2:
The most important prerequisite for setting a relationship between the two tables
is that there must be a ________ between them.
Answer: common field

Question 3:
In ________________ relationship, one specific record of a master table has one
and only one corresponding record in the transaction table.
Answer: one-to-one

Question 4:
_______________ is one of the most common types of relationship between the
tables in a database.
Answer: one-to-many

Question 5:
A record being entered in a ________ table must always exist in a ________ table.
Answer: transaction, master

Question 6:
The principle of _______________ helps prevent missing data by keeping deleted
data from getting out of synch.
Answer: referential integrity

Question 7:
Creating __________ between tables restricts the user from entering invalid data
in the referenced fields.
Answer: relationship

Question 8:
Data integrity is maintained by ____________.
Answer: DBMS
Question 9:
A relationship between customers and products is an example of __________
relationship.
Answer: Many-to-many

Question 10:
The ______ window is used to set relationships between the tables.
Answer: 10

D. Answer the following questions

Q1. Give any two advantages of relating a table in a database.

Ans. Two advantages of relating a table in a database are:
1. A relationship can help prevent data redundancy.
2. Creating relationships between tables restricts the user from entering
invalid data in the referenced fields.
3. Any updation in the master table is automatically reflected in the
transaction tables.
Q2. How is redundancy or inconsistency controlled in a database? Explain with
an example.
Ans. Redundancy or inconsistency is controlled in a database by setting the relationship
between tables which help in checking that neither the records are duplicated nor there
is variable data value for a particular field in two or more tables. After creating
relationship between table, then adding or updating a record in one table reflect the
changes in all the related tables.

Q3. Define referential integrity. Who maintains referential integrity in a database?

Ans. Referential integrity refers to the relationship between tables. Referential integrity
is used to maintain accuracy and consistency of data in a relationship. LibreOffice Base
will allow only that corresponding record to be entered in the transaction table which
already exists in the master table.
DBMS maintains referential integrity in a database.

Q4. Differentiate between one to one relationship and one to many relationship.
Give suitable examples to explain your answer.
Ans. One-to-One relationship : In this type of relationship, one specific record of a
master table has one and only one corresponding record in the transaction table.
One-to-One Relationship
One-to-Many relationship: In this type of relationship, one specific record of the master
table has more than one corresponding records in the related transaction table. For
example

One-to-Many Relationship

Q5. Explain many to many relationship with an example.

Ans. Many-to-Many relationship: In this type of relationship, there will be multiple
records in the master table that correspond to multiple records in the transaction table
as well.
For example, a teacher in a school may hold multiple responsibilities such as class
teacher, an activity incharge
or examination in-charge. For each responsibility the teacher might be attached with
multiple students.

Chapter 11: Queries in Base

A. Multiple choice questions

Q1. Which of the following is refer to asking questions from the database?
(a) Report
(b) Table
(c) Query
(d) Database

Ans. (c) Query

Q2. Which of the following are the ways to design a query?

(a) Wizard
(b) Design View
(c) SQL
(d) All of the above
Ans. (d) All of the above
Q3. Which is a flexible way to create a query?
(a) Wizard
(b) Design View
(c) Both (a) and (b)
(d) Neither (a) nor (b)
Ans. (b) Design View

Q4. Into how many parts is the query design window divided?
(a) One
(b) Two
(c) Three
(d) Four
Ans. (b) Two

Q5. Which of the following is NOT true about queries?

(a) It can be created using multiple tables
(b) Multiple queries can be created in a database
(c) A query can run multiple times
(d) A query once created cannot be edited
Ans. (d) A query once created cannot be edited

Q6. Which of the following is the shortcut key to run the query?
(a) F3
(b) F4
(c) F5
(d) F6
Ans. (c) F5

Q7. Which of the following functions can be performed on numerical data while
designing a query?
(a) Sum
(b) Minimum
(c) Maximum
(d) All of the above
Ans. (d) All of the above

Q8. In a Query Design wizard, which of the following buttons is clicked to move a field
from ‘Available fields’ list box to ‘Fields in the query‘ list box?
(a) >
(b) <
(c) ∨
(d) ∧
Ans. (a) >

Q9. Which of the following relational operators can be applied to set the criterion while
designing a query in LibreOffice Base?
(a) >
(b) =
(c) !=
(d) All of the above
Ans. (d) All of the above

Q10. Which of the following dialog box is present when the Query Design window is
opened for the first time to design a query?
(a) Add Table
(b) Add Query
(c) Add Table or Query
(d) None of the above
Ans. (c) Add Table or Query

Q11. Which of the following step is not performed if there is no numerical data to be
worked upon in a query?
(a) Selection of fields
(b) Giving Aliases
(c) Summarizing
(d) Selection of tables
Ans. (c) Summarizing

B. State whether the following statements are True or False

1. You can run a query only once

Ans. 1. You can run a query only once. False

2. A query cannot be created from multiple tables

Ans. 2. A query cannot be created from multiple tables. False

3. The shortcut key to run a query is F5.

Ans. 3. The shortcut key to run a query is F5. True

4. LibreOffice Base provides us with two ways to create a query.

Ans. 4. LibreOffice Base provides us with two ways to create a query. False

5. A query with numerical data cannot be saved.

Ans. 5. A query with numerical data cannot be saved. False
6. By default the query result is not sorted.
Ans. 6. By default the query result is not sorted. True

7. A query can be used to display the average value of a numerical field.

Ans. 7. A query can be used to display the average value of a numerical field.
True

8. While designing a query, the criterion can be set on only one field.
Ans. 8. While designing a query, the criterion can be set on only one field. False
9. Alias is an alternative name for a field in a query.
Ans. 9. Alias is an alternative name for a field in a query. True

10. In query Design window, the visible check box is selected by default.
Ans. 10. In query Design window, the visible check box is selected by default.
True

11. A query once created using a wizard can only be edited in the Design view.
Ans. 11. A query once created using a wizard can only be edited in the Design
view. True

C. Fill in the blanks.

1. A _______________ is a sort of question asked from a database.

Ans. 1. A query is a sort of question asked from a database.

2. The result of the query is displayed in _______________ form with field names
in columns
Ans. 2. The result of the query is displayed in report form with field names in
columns

3. A query can be created in ________ways.

Ans. 3. A query can be created in three ways.

4. The Query Design window is divided into ________________ sections.

Ans. 4. The Query Design window is divided into two sections.

5. The shortcut key to run the query is _____________.

Ans. 5. The shortcut key to run the query is F5.

6. The conditions to filter the records are set in the ___________ row.
Ans. 6. The conditions to filter the records are set in the criterion row.

7. When a table is selected in a Query wizard, the corresponding fields are

displayed in the ________________ list box.
Ans. 7. When a table is selected in a Query wizard, the corresponding fields are
displayed in the Available fields list box.

8. The result of the query can be displayed in ________ or ________ order of any
particular field of the table.
Ans. 8. The result of the query can be displayed in ascending or descending
order of any particular field of the table.

9. At the most ___________ search conditions can be given in the query wizard.
Ans. 9. At the most three search conditions can be given in the query wizard.
10. The last step of the Query wizard displays the entire _________ of the query.
Ans. 10. The last step of the Query wizard displays the entire overview of the
query.

11. The _________ view is a more flexible method to create a query.

Ans. 11. The design view is a more flexible method to create a query.

12. To edit any query, right click on the ____________ icon of the query that has to
be edited.
Ans. 12. To edit any query, right click on the query icon of the query that has to be
edited.

13. In the _____________ row of the Query Design grid, we can type the column
heading that will be displayed instead of field name when we run the query.
Ans. 13. In the alias row of the Query Design grid, we can type the column
heading that will be displayed instead of field name when we run the query.

D. Answer the given questions

Q1. Define a query? What is the need of creating a query in a database?

Ans. A query is used to collect specific information from the pool of data. A query helps
us to join information from different tables and filter that information.
Queries are required to retrieve the desired data easily and accurately from database.

Q2. Rearrange the steps given below so as to create a query using a wizard.
1. Give Alias
2. Select the fields
3. Set the criterion
4. Set the sorting order
5. Give table name

Ans
1. Give table name
2. Select the fields
3. Set the sorting order
4. Set the criterion
5. Give Alias

Q3. What all information is seen in the overview (last step) of the Query wizard?

Ans. Last Step of Query Wizard includes the following (Query Wizard Overview)
Name of the Query – By default, the name of the query is Query_Table1.
The action to be performed after the wizard finishes – By default Display Query option
will be selected. Click and select the Modify Query radio button if the query has to be
edited in the Design view.
Complete detail of the query – This section contains a summary about the query that
has been created.

Q4. What is the use of Alias row in the Design grid of the Query Design window?

Ans. Some times field names are not user friendly so Alias can be used to display
meaningful names of the fields in the output.

Q5. Name any four mathematical functions that can be applied to numerical data
in a query.

Ans. Four mathematical functions that can be applied to numerical data in a query are:
1. Sum
2. Average
3. Minimum
4. Maximum

Q6. Name the three ways of creating a query in LibreOffice Base?

Ans. Three ways of creating a query in LibreOffice Base are:

1. Design View
2. Use Wizard
3. SQL view.

Chapter 12: Forms and Reports

A. Multiple choice questions

Q1. Which of the following toolbars contains the Label tool?
(a) Standard Toolbar
(b) Forms Controls Toolbar
(c) Records toolbar
(d) Formatting toolbarHide Answer
Ans. (b) Forms Controls Toolbar
Q2. The Record toolbar has the buttons to move to the
(a) first record
(b) second record
(c) last record
(d) all records
Ans. (d) all records
Q3. Which of the following is NOT true about forms?
(a) It is the front end for data entry
(b) It can contain only text fields
(c) Graphics can be inserted on the form
(d) It can contain only fixed number of records
Ans. (b) It can contain only text fields
Q4. Which of the following keys is pressed to select only textbox on the form?
(a) Alt
(b) Shift
(c) Ctrl
(d) Tab
Ans. (c) Ctrl
Q5. Which of the following properties in the Properties: Label Field text box is
used to insert a tool-tip on the form?
(a) Tool Text
(b) Help Text
(c) Tool Tip
(d) Help Tip
Ans. (b) Help Text
Q6. Which of the following objects of LibreOffice Base is used to display data
retrieved from one or more tables in a presentable manner?
(a) Query
(b) Form
(c) Report
(d) Panel
Ans. (c) Report
Q7. Which of the following values of Date Format property is selected to view a
calendar on the form?
(a) Standard (short)
(b) Standard (long)
(c) Default
(d) Standard (Medium)
Ans. (b) Standard (long)
Q8. Which of the following commands on the Forms Control toolbar is used to
toggle between Design View and Form view?
(a) Design Mode
(b) Toggle Mode
(c) View Mode
(d) Print mode
Ans. (a) Design Mode
Q9. Using which of the following objects in a database, can a report be
generated?
(a) Tables
(b) Queries
(c) Both a and b
(d) Neither a nor b
Ans. (c) Both a and b
Q10. Which of the following components open along with the Report Wizard?
(a) Report Builder
(b) Add Fields dialog box
(c) Both (a) and (b)
(d) Neither (a) nor (b)
Ans. (c) Both (a) and (b)

B. State whether the following statements are True or False

1. Report is an object of a database but form is not.

Ans. 1. Report is an object of a database but form is not. False

2. We can choose the layout of the form.

Ans. 2. We can choose the layout of the form. True

3. We have to add all fields of the table on the form.

Ans. 3. We have to add all fields of the table on the form. False

4. There are two ways in which a form can be created.

Ans. 4. There are two ways in which a form can be created. True

5. A report is generated in a separate window.

Ans. 5. A report is generated in a separate window. True

6. Once a control is added on to the form, it cannot be repositioned.

Ans. 6. Once a control is added on to the form, it cannot be repositioned. False

7. The Record toolbar has the button to add a new record.

Ans. 7. The Record toolbar has the button to add a new record. True

8. We can create a report only using a table.

Ans. 8. We can create a report only using a table. False

9. By default, the records in a report are sorted in descending order.

Ans. 9. By default, the records in a report are sorted in descending order. False

10. We can group data based on a particular field in a report.

Ans. 10. We can group data based on a particular field in a report. True

11. A report can have data only in row and column format.
Ans. 11. A report can have data only in row and column format. False

12. We can insert both date and time of generation of report.

Ans. 12. We can insert both date and time of generation of report. True

13. A report once created cannot be edited.

Ans. 13. A report once created cannot be edited. False

C. Fill in the blanks

1. A form can be used for ____________ and _____________.
Ans. 1. A form can be used for enter and view data.

2. Each field control consists of a _____________ and ________________

Ans. 2. Each field control consists of a label and field value

3. A ____ is a piece of text that specifies the data that should be entered in the
field value text box.
Ans. 3. A label is a piece of text that specifies the data that should be entered in
the field value text box.

4. By default the border of the field text value is displayed in _____________.

Ans. 4. By default the border of the field text value is displayed in 3D.

5. A ______________ is a small piece of text that is displayed when the mouse

pointer is placed on a particular control on the form.
Ans. 5. A Tool tip is a small piece of text that is displayed when the mouse pointer
is placed on a particular control on the form.

6. The default orientation option for a report is _______________________.

Ans. 6. The default orientation option for a report is Landscape.

7. A _______________ is the manner in which the labels, field values, titles etc.
will be displayed in the report.
Ans. 7. A Layout is the manner in which the labels, field values, titles etc. will
displayed in the report.

8. The option to insert date and time in the report is present in ______________
menu.
Ans. 8. The option to insert date and time in the report is present in insert menu.

9. A Report Wizard contains __________________ steps.

Ans. 9. A Report Wizard contains Six steps.

10. A _______________ type of report changes automatically as the field values in

the base table or query change.
Ans. 10. A Dynamic type of report changes automatically as the field values in the
base table or query change.

D. Answer the following questions

Q1. Give one difference between a form and a report.

Ans.
Form Report
 A form provides an interface that allows Reports are used to present data in a
users to format
enter, change and view the data in a table. that can be printed.

Q2. What is a field control with respect to forms?

Ans. A field control consists of a label and the field value text box. A label is a piece of
text that specifies the data that should be entered in the field value text box. A field
value text box is linked to the respective field in the table.

Q3. Which tool on the Forms Record toolbar is used to insert text on the form?
Ans. Text box

Q4. Name the two ways to create a form in LibreOffice Base.

Ans. Two ways to create a form in LibreOffice Base are:
1. Using a wizard
2. Using the Design View
Q5. What is the difference between a static and a dynamic report?
Ans. Difference between a static and a dynamic report are:
Dynamic Report Static Report

This report changes when ever there is a change in This report does not change.
the
values of table or query.

This is not by default

This is by default selected. selected.

Q6. Write the function of Forms Controls toolbar and Records toolbar.
Ans. Form Control Toolbar: This toolbar contains various controls that can be added to
the form. for example Label, Text field, Radio button etc.
Record Toolbar: The Records toolbar contains the navigation control buttons. With the
help of these buttons we can move from one record to another record.