Comprehensive Notes on Create and Edit tables using wizard and SQL commands Class 10

Dear Students, in this article we will discuss bout comprehensive notes on create and edit tables class 10. As per the syllabus of Information Technology class 10, LibreOffice base is preferred for creating tables for the Database Concepts.

Before starting to Create and Edit tables class 10 article I would recommend that We have already covered the basics of DBMS and RDBMS. To read this click here.

So let us start Create and Edit tables class 10. So first you need to understand the parts of OpenOffice/LibreOffice Base. So here we go!

Introduction to LibreOffice Base

LibreOffice base is a free open source Database Management System software. It is one of the application of LibreOffice package.

To download LibreOffice, Click here.

Starting LibreOffice Base

After installing LibreOffice, to open LibreOffice base follow the given steps:

[1] Click on Start > All Apps > LibreOffice 24.2 > LibreOffice Base.

[2] It opens Database Wizard. Database wizard has two main steps

Create and Edit tables using wizard and SQL commands Class 10

In this section you will learn how to create and edit tables using wizard and SQL commands using Open Office and Libre Office.

Create Database using OpenOffice Base

After installation of Open Office 4.1.7, you will get applications like OO Writer, OO calc and OO Base. To work with database open OO Base. Follow these steps to do so:

Step 1: Click on Start Menu.

Step 2: Find Open Office 4.1.7 and click on it.

Step 3: Now select Open Office Base.

Step 4: The database wizard will open to select or create a database.

If you are opening it first time select create a new database option and then follow the wizard instructions.

If you have already created a database select open an existing database file option and follow the wizard instructions.

Now OO Base will open, the interface of OO Base is something like below-given screenshot:

Now in the next section of Create and Edit tables class 10, we will discuss about the parts of OO base window.

Create Database using LibreOffice Base

Open LibreOffics base by following these steps:

[1] Click on Start > LibreOffice X.X.X > LibreOffice Base.

[2] A database wizard will appear.

[3] Click on Select Database option. Choose Create a new database and choose the option HSQLDB Embedded from drop down list and click on Next button.

[4] Now move to the step 2 Save and Proceed. Choose options for register database or not and select option for creating tables or editing database. Click on Finish button.

[5] It will ask to save database. Type the filename and save at database at desired location.

The LibreOffice database is saved with .odb extension.

As the main parts of OO/LO Base window are highlighted with numbers. They are as following:

1. Database Objects selection window
2. Tasks Window
3. Description Window
4. Database Object window
5. Properties window of selected Database objects

Database Objects Selection window

This windows allows to select the database objects and you can do work upon. There are four basic icons available in this window:

1. Tables
2. Queries
3. Forms
4. Reports

All of these we will discuss in upcoming sessions.

Tasks Window

This window allows selecting the specific tasks as per the selected object from the database object selection window. Here you will observe different tasks are available for different objects. But the common task is to create and use wizard.

Description Window

This windows shows the description of the selected task.

Database Object (Tables/Queries/Forms/Reports) Window

It shows the different database objects such as Tables/Queries/Forms/Reports created by user.

Properties window

It displays the information of selected object from database object window.

Now we will discuss, how to create table in OO/LO Base for Create and Edit tables using wizard and SQL commands Class 10.

Create a table

There are 3 ways to create a table in OO\LO Base.

Prepare a table structure on paper before creating a table in OO\LO Base, Because it will asks to select a primary key other constraints, so define a primary key and assign the column otherwise OO\LO base will add one column named ID when you save the table with your confirmation.

If primary key is not there, OO\LO base won’t allow to insert records in the table.

In next section of Create and Edit tables using wizard and SQL commands Class 10, we will see all of these ways in detail.

Create table in Design View

The design view of LibreOffice base is used to create a table by entering and specifying values in the table design. It offers more flexibility to the user for database table operations.

Follow these steps to create a table in design view:

[1] Click on Tables –> Create Table in Design View option from the tasks window.

It will open a design window to view table structure and allows you to write table field names and data types as well as other properties of the field.

Crate table in Design view window is divided into two parts:

1. The upper half consists of a grid structure with three columns:
   • Field Name: Gives a field name to the table
   • Field Type: Specifies data type for the field
   • Description: To give more information about the field. The description is not important part of table creation.
2. The lower half consists of field properties. It shows the various properties of a field assigned by designer. These properties can be changed as per the need to control and validate the data.
3. Some common field properties are as follows:
4. AutoValue : It Yes/No properties, it assigns an automatic value starting with 0.
5. Length: Specifies the no. of digits of character present in the field value.
6. Default Value: If value is not entered or skipped by user, the default value will be accepted in the field.
7. Format Example: Set a specific format for the value

The table design windows looks like as follows:

Type appropriate field names, choose desired field types and type the description if necessary.

Setting Primary key in table design

To set the primary key follow the given steps:

1. Select the field which can be assigned as a primary key for the table.
2. Right click on selected field.
3. Choose primary key option.
4. A key icon will appear in front of the field name.

Save the table

Click on Save As icon in toolbar or Click on File > Save option. It will open Save As dialog box. Type the table name and click on OK.

Now once table is created, it will appear in the objects window. Double click to open it and add records you want by typing them.

Watch this video to understand it properly and comment your views on the video:

In next section of Create and Edit tables class 10 we will see how to create a table using wizard.

Use wizard to create table

The wizard allows to create a table from predefined sample tables with predefined fields. It is just like drag and drop type work where you have to choose the fields and other important things for your table. Follow these steps to create a table through wizard:

[1] Click on Table –> Use wizard to create table option from the tasks window.

A wizard appears with the 4 basic steps:

Select fields:

This option displays two categories business & Personal. Choose the sample table from the Sample Tables dropdown.

Now select the required fields from the list of Available Fields. Now click on Add button available with > sign or Add to all button with >> to select the all the available fields. You can remove the unwanted fields by clicking on remove < or remove all << button.

Click on Finish.

Set types and formats:

Select the field name to set types and formats.

Select appropriate types and formats for your fields and click on next.

Set primary key:

Select a field for a primary key to the table.

Select various options for the primary key.

Click on next.

Create Table:

This allows renaming the table and provides three options to work with the table. These options are – insert data immediately, Modify the table design, and create a form based on this table.

Click on Finish and start your work accordingly!!

The next section is very important for the topic Create and Edit tables using wizard and SQL commands Class 10 because a fixed 2 marks question is coming to create table in board exam.

Create table using SQL commands

OO\LO base also support SQL view to create a table. To work with SQL mode you need to install java jdk for proper command execution.

Steps:

[1] Click on Tool –> SQL command. Execute SQL statement will open.

[2] Write following command to create table and click on Execute:

create table "Students" ("RNO" integer primary key,"Sname" varchar(20), "DOA" date)

In the next section of Create and Edit tables using wizard and SQL commands Class 10 we will see very important points to be remembered while creating tables.

Points to be remembered:

1. Follow these rules for giving names to your fields and table:
   • It must start with an alphabet
   • A special character should not use in names
   • It should not be a default keyword
2. Enclose all the names like table and fields in double-quotes.
3. You can type the command words into capital as most of the books suggesting to type commands in the capital, but it is not necessary.

Watch this video for more details:

So here we conclude our topic Create and Edit tables using wizard and SQL commands Class 10. I hope you enjoyed the learning with this article. Hit the like button. Share this article with your friends and classmates.

Don’t forget to share your views/feedback about the article Create and Edit tables class 10 and always feel free to ask your doubts in comment section.

Follow this link to refer NCERT Solutions Chapter 9 Starting with LibreOffice base.

Follow this link for more important previous year questions: