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

How to create Database in Open Office Base?

Database is a software which is used to store large amount of records in an organized manner in a form of tables.

These are the steps to create a Database:

1)  Click start button of your operating system.

2)  Select Open Office.

 

Open Office Base

 3)  Select Database option, and Database wizard window opens up.

Create Database In Open Office Base

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

 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)
  

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

 4)  Select create new Database option.

Create Database In Open Office Base

5)  Click ‘Yes register Database for me’ and ‘Open Database for editing’ options. After that click finish button.

Save Database In Open Office Base

 6)  Give Database name and press save button.

(Note: .ODB is the file extension of Open Office Base)

Database In Open Office Base

What is File Extension in software file?

File Extension is the last name of a file. It helps OS (operating system) to know what type of file it is. The first name of a file is given by a user, but the last name (Extension) is always given by the software itself.

 

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

 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

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

What are the main components of a Database in Open Office Base?

Database has four components which help to create table, access records, edit tables, and create report to take hard copy of records.

These are the four components of a Database:

 

Components in Database

 1)  Tables component is used to create a table. A table can be designed in two ways.

       I)  Create Table in Design View
      II) Use Wizard to Create Table

2) Queries component is used to get record from a table. A query can be designed in two ways.

       I)  Create Query in Design View
      II)  Use Wizard to Create Query

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

MCQs of All Chapters 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

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

3)  Forms component is used to enter data in a table in directly. A form can be designed in two ways.

      I)  Create a Form in Design View
     II)  Use Wizard to Create Form

4) Reports component is used to take print out of the records saved in a table. Report can be designed in one way.

      I)  Use Wizard to Create Report.

 

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

Sample Paper of Class 10

• English Sample Paper 2022 - 23
  
• Hindi A Sample Paper 2022 - 23
• Maths (Standard) Sample Paper 2022 - 23
• Maths (Basic) Sample Paper 2022 - 23
• Science Sample Paper 2022 - 23  
• Social Science Sample Paper 2022 - 23

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

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

Sample Paper of Class 10 IT 402

• Sample Paper 2020 - 21
  
• Sample Paper 2021 - 22
• Sample Paper 2021 - 22
• Sample Paper 2022 - 23
• Sample Paper 2022 - 23 
  

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