Starting with LibreOffice Base
Exercise Answers — tap any question to reveal the answer and explanation.
A. Multiple Choice Questions 10 questions
Which of the following is NOT a type of text data type?
Answer: (c) Float
Explanation: Memo, Varchar and Char are text data types, whereas Float is a numeric data type.
A currency data type can only store monetary data that is in dollars.
Answer: (b) False
Explanation: Currency data type can store monetary values in currencies of various countries, such as dollars, pounds and rupees.
Which of the following data can a date data type store?
Answer: (c) Both date and time
Explanation: Date data type is used to indicate dates and time.
Which of the following is true about LibreOffice Base?
Answer: (b) It is free and open source software.
Explanation: LibreOffice Base is a free and open-source database component of the LibreOffice suite.
Which of the following methods can be used to create a table in Base?
Answer: (c) Both a and b
Explanation: A table in LibreOffice Base can be created using a wizard or Design View.
The related objects of a database can be seen in __________ pane of the Base Database window.
Answer: (a) Database
Explanation: The Database Pane contains related database objects such as Tables, Forms, Queries and Reports.
Which is the shortcut key to open an existing database?
Answer: (b) Ctrl + O
Explanation: Ctrl + O is used to open an existing database.
The Design View of Table Creation window in LibreOffice Base is divided into ______ sections or panes.
Answer: (a) 2
Explanation: The Table Design window is divided into two sections or horizontal panes.
While entering records in a table, we can move to the next field by pressing the ___________ key.
Answer: (a) Tab
Explanation: The Tab key is used to move to the next field while entering data.
Which of the following is true about primary key of a table?
Answer: (d) All of the above
Explanation: A primary key uniquely identifies a record; its values cannot be duplicated and the primary key field cannot be left blank.
B. State whether True or False 10 questions
Answer: True
Explanation: Text data is a combination of letters, numbers or special characters.
Answer: True
Explanation: Memo data type is used to store descriptive data having more than 255 characters.
Answer: False
Explanation: A Boolean data type has only two possible values.
Answer: False
Explanation: LibreOffice Base provides a Binary data type for storing digitized data.
Answer: True
Explanation: The field properties displayed depend on the selected data type.
Answer: True
Explanation: Field description is optional.
Answer: False
Explanation: The exercise answer key marks this statement False; the navigation buttons include a separate Last Record button.
Answer: True
Explanation: The Edit icon appears before the record being edited.
Answer: False
Explanation: A table can be edited after it has been created; fields and their properties can be changed.
Answer: False
Explanation: The Sort Order dialog box allows sorting in both ascending and descending order.
C. Fill in the Blanks 10 questions
Answer: Data type
Answer: Text
Answer: Text
Answer: Binary
Answer: Ctrl + S
Answer: Tasks Pane
Answer: Key
Answer: Datasheet
Answer: Record pointer
Answer: Sorting
D. Answer the Given Questions 6 questions
| Memo | Varchar |
|---|---|
| It is used to store long alphanumeric data. | It is used to store small length alphanumeric data. |
| It can store up to 64000 characters. | It can store up to 255 characters. |
| Number | Decimal |
|---|---|
| Data type: NUMERIC. | Data type: DECIMAL. |
| It is used to store integers of any length. | It is used to store decimal values. |
| For example: 7892, 100000 | For example: 1023.45 |
| Design View | Datasheet View |
|---|---|
| Used to create and design the structure of a table. | Used to enter data/records into a table. |
| Allows Field Name, Field Type, Description and field properties to be specified. | Displays field names and allows data values to be entered into records. |
| A primary key can be defined in this view. | Records can be entered and viewed in this view. |
Answer: The seven menu items are: File, Edit, View, Insert, Tools, Window and Help.
Answer:
- Title Bar — located at the top of the window and displays the database/application name.
- Database Pane — located on the left side and contains database objects such as Tables, Forms, Queries and Reports.
- Tasks Pane — displays tasks/options related to the selected database object.
- Status Bar — located at the bottom and displays information about the type of view of the selected database object.
Answer:
- Open the table in Design View.
- Place the mouse pointer before the field name that is to be made the primary key.
- Right-click on the field name.
- Select the Primary Key option from the pop-up menu.
- A key icon appears before the field name, indicating that it is the primary key.
Answer:
- Open the table in Datasheet View.
- Select the primary key field.
- Click the Sort Descending icon on the toolbar.
- The records will be arranged in descending order of the selected primary key field.
Answer: The Navigation Box is used to navigate through the records of a table. It indicates the current record of the table.
- Record Selector Box — displays the number of the currently active record. A record number can be entered to directly view that record.
- Navigation Buttons — allow movement through the records, including first, previous, next and last record.
- Press I◄ to move to the first record
- Press ► and ◄ to move to the next and previous records respectively
- Press ►I to move to the last record