Database with Libre Office
SOP 1
Create a table student with fieldnames- rollno, studname, class, div, city, dob etc. Insert minimum 8
records. Create a form based on Student table.
Step 1: Creating a Database
1. Click on start → All Programs → Libre Office → Libre Office Base.
2. Database wizard window appears, select Save and Proceed → Click on Finish button, Select proper
location where you wish to save the database with appropriate name, database will be created.
Step 2: Creating a Table
1. To create a table, click on Create table in design view → Table design window appears, in that window
set fieldname, datatype as follows:
Fieldname DataType Description
Rollno Number[NUMERIC] Roll of student(Primary Key)
Studentname Text[VARCHAR] Name of student
Class Text[VARCHAR] Class of student
Div Text[VARCHAR] Division of student
City Text[VARCHAR] City of student
Dob Date[DATE] Date of birth of student
2. To assign primary key to rollno field, right click on the small button present on the left side of the
fieldname and select Primary Key option.
3. To Save click on save button or press CTRL+S, give name as employee and click on OK button, table
will be saved.
Step 3: Inserting record in a table
For inserting records in a table, double click on the table in which data is to be inserted, a window will appear
on the screen, type data under each field and complete all the records.
Step 4: Creating a Form
1. From left pane click on Form object.
2. From right pane click on Use wizard to create a form, form wizard window appears.
3. Shift fields from Available Fields list to fields in form list by clicking on arrow button then click on
Next button.
4. Click on Next button.
5. Select any one arrangement for main form for placing the controls and click on Next button.
6. Click on Next button.
7. Select style for the form and click on Next button.
8. Type name of the form and click on Finish button.
9. To add new record click on new record icon present on Navigation toolbar, fill record and click on save
record icon. Click on close button to close form window.
Output (Stick on blank side)
SOP 2
Create a table employee with fields names-empid, empname, empdept, empqual, empjoindate, empsal
etc. Insert minimum 8 records. Create queries to display record from the employee table.
1. Where employee qualification is “MBA”.
2. Where employee department is “Accounts”.
3. Where employee salary>70000.
4. Where employee name is “Mr. Suhas Kale”.
Step 1: Creating a Database
1. Click on start → All Programs → Libre Office → Libre Office Base.
2. Database wizard window appears, select Save and Proceed → Click on Finish button, Select proper
location where you wish to save the database with appropriate name, database will be created.
Step 2: Creating a Table
1. To create a table, click on Create table in design view → Table design window appears, in that window
set fieldname, datatype as follows:
Fieldname DataType Description
Empid Number[NUMERIC] Id of Employee(Primary Key)
Empname Text[VARCHAR] Name of Employee
Empdept Text[VARCHAR] Department of Employee
Empqual Text[VARCHAR] Qualification of Employee
Empjoindate Date[DATE] Join Date of Employee
Empsal Number[NUMERIC] Salary of Employee
2. To assign primary key to empid field, right click on the small button present on the left side of the
fieldname and select Primary Key option.
3. To Save click on save button or press CTRL+S, give name as employee and click on OK button, table
will be saved.
Step 3: Inserting record in a table
For inserting records in a table, double click on the table in which data is to be inserted, a window will appear
on the screen, type data under each field and complete all the records.
Step 4: Creating query
1. Click on queries object and in right pane click on Create Query in Design View option.
2. From Add table window, select table and click on Add button and click on Close.
3. Select all the fields one by one by Clicking on field’s columns.
(a) To display record where employee qualification is “MBA”.
In Criterion type “MBA” and click on Run query icon or Press F5 function key.
(b) To display record where employee department is “Accounts”.
In Criterion type “Accounts” and click on Run query icon or Press F5 function key.
(c) To display record where employee salary>70000.
In Criterion type “>70000” and click on Run query icon or Press F5 function key.
(d) To display record where employee name is “Mr. Suhas Kale”.
In Criterion type “Mr. Suhas Kale” and click on Run query icon or Press F5 function key.
Output (Stick on blank side)
