Std. XII Experiment No. 12 – SOP2: Database Concepts using LibreOffice Base

📘 Experiment No. 11 – SOP1: Database Concepts using LibreOffice Base

In this blog, we will explore Experiment No. 12: SOP2 – Database Concepts using LibreOffice Base, exactly as prescribed in the Class XII Practical Journal.
A copy-paste ready journal section is also provided at the end for students.

---

---

✂️ COPY & PASTE THIS IN YOUR PRACTICAL JOURNAL

(Students can directly copy everything below into their journal.)

 

Experiment No. 12 

SOP2-Database concepts using LibreOffice Base

1. Steps to create database in LibreOffice Base:

1. Click on start button -> All Programs -> LibreOffice -> LibreOffice Base.

2. Click on the Finish button on the Database Wizard window.

3. Specify location and Database name on ‘Save As’ dialog box.

4. Click on Save Button.

2. Steps to create Employee Table :

1. Click on Tables in the Database section on the left side of the screen.

2. Click on ‘Create Table in Design view…’ in task section.

3. create following fields:

Field Name	Field Type
Empid	Text
Empname	Text
Empdept	Text
Empqual	Text
Empjoindate	Date
Empsal	Number

4. Right click and mark the empid field as Primary Key field.

5. Click on the file menu and select the save option.

6. Specify Table name as ‘Employee’ and click on Ok button on Save as Dialog box.

3. Steps to create Queries:

1. Click on Queries in the Database section on the left side of the screen.

2. Click on ‘Create Query in Design view…’ in task section.

3. Select your Table on ‘Add Table or Query’ Dialog box, click on add button and close it.

4. Double click on the fields you want in your query.

5. Specify given condition in ‘criterion’ under particular field column.

6. Click on the ‘Run Query’ option at the Toolbar.