Std XII - Experiment No. 11 – SOP1: Database Concepts using LibreOffice Base

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

A Complete Blog to Share with Class XII IT Students

In this blog, we will explore Experiment No. 11: SOP1 – 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 given below the box into your journal.)

Experiment No. 11

SOP1-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 Student 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
Rollno	Text
Studname	Text
class	Text
div	Text
city	Text
dob	Date

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

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

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

3. Steps to create Form:

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

2. Click on ‘Use wizard to create form…’ in the task section.

3. Select your Table on ‘Form Wizard’ Dialog box, select all the fields and click on the next button.

4. click on the next button on the “set up a subform” tab.

5. select appropriate arrangement style for controls on form and click on next button.

6. click on the next button on the “set data entry” tab.

7. Select the appropriate style for form and click on the next button.

8. specify form name and click on Finish button.