Class 10 IT | Chapter- Database Management System | Topic- Update Table in Open Office Base

How can we change table design in Open Office Base?

In Open Office Base we can change table design after creating a table. We can add new column, delete column, and change column definition.

Change Table Design in Open Office Base

Add New column in a Table:
These are the steps to add new column in a table.
1) Select table in table component in a database.
2) Click mouse right button and select Edit option.
3) Add new column in Table Design Window.
4) Press Save button.

--------------------------------------------------

 Other Topics of this Chapter

• Database
• Primary key / Foreign Key
• Create Database in Open Office Base
• Create Table in Open Office Base
• Update Table in Open Office Base
  
• Create Query in Open Office Base
• Creating Form in Open Office Base
• Report in Open Office Base
  
• DDL (Data Definition Language)
• DML (Data Manipulation Language)
  

-------------------------------------------------

Delete Column in a Table:
These are the steps to delete column in a table.
1) Select table in table component in a database.
2) Click mouse right button and select Edit option.
3) Press Delete option.
4) Press Save button.

Change Table Definition:
These are the steps to change table definition.
1) Select table in table component in a database.
2) Click mouse right button and select Edit option.
3) Change column name, data type in Table Design Window.
4) Press Save button.

--------------------------------------------------

 Chapters of Class 10 IT (402) 

Part - A

Chapter 1 – Communication Skills

Chapter 2 –Self - Management Skills

Chapter 3– ICT Skills

Chapter 4 - Entrepreneurship

Chapter 5 –Green Skills

 

Part - B 

Chapter 1 – Digital Documentation
Chapter 2– Electronic Spreadsheet
Chapter 3 – Database Management System
Chapter 4 –Web Application

--------------------------------------------------

How to update data in a table in Open Office Base?

In Open Office Base we can update data after data entered in table. We can enter record, delete record, and change record in a table.

Update Data in a Table:
These are the steps to update data in a table.
1) Select table in table component in a database.
2) Click mouse right button and select Open option.
3) Change record in Table.
4) Press Save button.

Delete Data in a Table:
These are the steps to delete data in a table.
1) Select table in table component in a database.
2) Select row in a table
3) Press mouse right button.
3) Select Delete Rows option
4) Press Save button.

How to hide and unhide column in Open Office Base?

In Open Office we can hide and unhide columns in a table due to security reasons.

Hide or Unhide in Open Office Base

To Hide Column in a Table:
These are the steps to hide column in a table.
1) Select table in table component in a database.
2) Select column in a table
3) Press mouse right button.
3) Select Hide option.
4) Press Save button.

To Unhide Column in a Table:
These are the steps to unhide column in a table.
1) Select table in table component in a database.
2) Select column in a table
3) Press mouse right button.
3) Select ‘Show Columns’ option.
4) Press All option.
5) Click Save button.

How to sort data in a table in Open Office Base?

In Open Office records in a table can be arranged in ascending or descending order which helps to organize data in a table.

Sorting in Ascending Order:
1) Open table to sort records.
2) Mouse right clicks on field to select a column.
3) Click Sort Ascending icon near standard menu.

Sorting in Descending Order:
1) Open table to sort records.
2) Mouse right clicks on field to select a column.
3) Click Sort Descending icon near standard menu.

Multiple Sort in Open Office Base

Sorting With Multiple Sort Criteria:
Sometime a table has duplicate records in a columns, so multiple sort criteria is used to sort data.
1) Click the Sort Icon near standard menu.
2) In Sort Order dialog box select fields and order.
3) Press Ok Button.

What is Data validation in Database Management System?

Data validation checks that data entered by user is valid and correct, so it helps users to enter correct data. Data validation applies many restrictions like entry required, length, and default value.

1) Entry Required Validation: Entry Required validation confirms that user hasn’t left any field blank in a table.

2) Length Validation: Length validation limits the number of character a user can enter in a field in a table.

3) Default Value Validation: Default value confirms that if a user doesn’t enter a record in a field then default values save automatically in a table.