Page 248 - Computer - 10(A&B)

Let us Recallus Recall
Let

• Database is an organised collection of logically related data values in such a way that they can be used to generate useful
information which is necessary for the decision making process.
• LibreOffice Base is a part of LibreOffice suite. It is a Relational Database Management System (RDBMS) software.
• Table can be defined as a group of related data organised in the form of rows and columns.
• Fields are the columns in a table which describe the individual aspect of each object in that table.
• Records are the rows in a table which describe all aspects of an individual object in that table.
• A value is a set of characters, text, or number that you put in while adding information to the table.
• The basic table components to design the table structure are Field Name, Data Type, Field Properties, and Primary Key.
• Field name is a label to identify characteristics that field is supposed to represent.
• Data type is data stored in a table and can be of many types like numbers, alphanumeric, date, etc.
• Tables are the basic components of a database management system. Information in a table is stored in the form of columns called
fields or attributes, and different entries of related field values called records or tuples.
• A query is a database component which extracts or retrieves information from one or more tables of the database that satisfy a
specific criteria.
• A form is a database component that acts as a user interface to enter, edit, view, or search the data stored in single or multiple
tables.
• A report is used to present the data stored in tables or queries in a printable format to perform different type of data analysis on
the extracted information.
• There are mainly two ways to create a table: Datasheet view and Design view.
• Once the table structure is defined, we can store data in it.
• Form are the database objects which help not only to enter the data in tables, but also to search or modify the data values stored
in the tables.
• Navigation refers to moving from one record to another.
• Reports can be generated from single or multiple data sources showing information in a systematic and summaried manner.
• Reports are used to display information from tables or queries in a printable form.

Se
Self-Assessmentlf-Assessment

A. Tick () the correct option.
1. Database is an organised collection of information stored in the form of a:
File Table
Query Image

130