Scribd
Upload
606 views

Chapter 5 Database Concepts Using LibreOffice - SOP

Uploaded by

yadavsushant1502
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
606 views

Chapter 5 Database Concepts Using LibreOffice - SOP

Uploaded by

yadavsushant1502
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 4

Chapter 5 SOP

Database concepts using LibreOffice Base


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.
Answer :
1. Step to create database:
a. Select LibreOffice - Base
b. Save the file with proper name
2. Steps to create a table:
a. Select table
b. Design view
c. Type the following field with appropriate datatype

Rollno Number
Studname Text[VARCHAR]
Class Text[VARCHAR]
Div Text[VARCHAR]
City Text[VARCHAR]
Dob Date[DATE]

3. Step for inserting records in table


a. Save the table
b. Double click on it
c. Insert 8 records
d. Save it again
4. Steps to create form:
a. From left pane click on Form
b. Select wizard to create form
c. Select all fields
d. Click on next button
e. Select style for the form
f. Type the name of the form
g. Click on finish
Chapter 5 SOP
Database concepts using LibreOffice Base
SOP 2. Create a table employee with fields names- empid, empname, empdept, empqual,
empjoindate, empsal etc. Insert minimum 8 records.
Create queries to display records 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
Answer:
1. Steps to create a database
a. Select LibreOffice - Base
b. Save the file with proper name
2. Steps to create a table:
a. Select table
b. Design view
c. Type the following field with appropriate datatype

Empid Number
Empname Text[VARCHAR]
Empdept Text[VARCHAR]
Empqual Text[VARCHAR]
Empjoindate Date[DATE]
Empsal Number

3. Step for inserting records in table


a. Save the table
b. Double click on it
c. Insert 8 records
d. Save it again
4. Steps to create query:
a. Click on queries in left pane
b. Create query with design view
c. From add table select table that you saved
d. Click on add button and close
e. Select all fields one by one
f. To display employee MBA - in Criterion type – MBA and run the query
g. To display employee department Accounts - in Criterion type – Accounts and
run the query
h. To display employee salary>70000 - in Criterion type – “>70000” and run the
query
i. To display employee name “Mr. Suhas Kale” - in Criterion type – “Mr. Suhas
Kale” and run the query

Chapter 5 SOP
Database concepts using LibreOffice Base
SOP 3. Create table product with fieldnanmes prodid, proname, qty, rate, modelyear with
appropriate data type. Insert minimum 8 records.
1. Generate report to display records in ascending order of prodname.
2. Generate report to display records in descending order of product rate.
3. Generate report to display modelyear wise product list.
4. Build a query to display amount
5. Generate a bill report with appropriate titles and calculate amount for each record.
Answer:
1. Steps to create a database
a. Select LibreOffice - Base
b. Save the file with proper name
2. Steps to create a table:
a. Select table
b. Design view
c. Type
d. the following field with appropriate datatype

Prodid Number
Prodname Text[VARCHAR]
Qty Number
Rate Number
Modelyear Date[DATE]

3. Step for inserting records in table


a. Save the table
b. Double click on it
c. Insert 8 records
d. Save it again
4. Steps to create report:
a. Click on report in left pane
b. Create report with wizard
c. From add table select table that you saved
d. Click on add button and close
e. Select all fields one by one
5. To Generate report to display records in ascending order of prodname.
a. To create a report ascending – select name of table and select field
b. Select podname to sort the data in ascending order and click on next
6. Generate report to display records in descending order of product rate.
a. To create a report descending – select name of table and select field
b. Select product rate to sort the data in descending order and click on next
7. Generate report to display modelyear wise product list.
a. To create a report modelyear wise – select name of table and select field
b. Select modelyear wise
c. Choose the layout and orientation and click on next
8. Build a query to display amount
a. Click on query in left pane
b. Create query in design view
c. From add table select table that you saved
d. Click on add button and close
e. Add a formula in column name “qty”*”rate” and in alis coumn type total
amount and run the query.
9. Generate a bill report with appropriate titles and calculate amount for each record.
a. To create a bill report – select name of table
b. click on next and print.

You might also like