Scribd
Upload
7 views1 page

Practical File Base

The document outlines practical file questions for Class X Information Technology, focusing on creating databases using Libre Office Base. It includes tasks such as creating tables, setting field properties, entering records, and generating queries, forms, and reports for various scenarios. Specific examples include managing employee information, student details, and maintenance dues for a housing society.

Uploaded by

atharv.goyal.1928
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
7 views1 page

Practical File Base

The document outlines practical file questions for Class X Information Technology, focusing on creating databases using Libre Office Base. It includes tasks such as creating tables, setting field properties, entering records, and generating queries, forms, and reports for various scenarios. Specific examples include managing employee information, student details, and maintenance dues for a housing society.

Uploaded by

atharv.goyal.1928
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

Class X Information Technology

Libre Office Base Practical File Questions


Q1) Create a database ‘XYZ Ltd’ and create a table ‘Employee Info’ with the following
fields.
Empno, Empname,Designation,Department, Salary
Set the following field properties
a) Empno as Primary Key
b) Set the default value 10000 in Salary field
c) Set Empno, Empname as Required field
d) Enter 10 records
e) Create a query to display the employees in ‘Sales ‘ department.
f) Create a query to display employees having salary more than 40000.
g) Create a Form
h) Create a Report
Q2) Create a database Student Info having a table Student with following fields:
Scholar_No, Roll_NO , Stu_Name, Gender, Class, Section ,
a) Apply proper validation in all fields. (Entry required, Default Value etc)
b) Create Another table ‘Parents’ to store parents details with fields
c) ‘Scholar_NO, Fathername, Mother name.
d) Set Scholar_ID as primary key in student table.
e) Add at least 10 records in both the tables.
f) Set relationship between the tables.
g) Create a query to display the students who are in class 10.
h) Create a form to display the records
i) Create a report
Q3) Prateek lives in Happy Home Society. He wants to create a database so as to store and
manage the maintenance dues received from flat owners of the society. Create the
following tables for his database.

a) Relate the two tables and thereafter enter minimum five records in both the tables.
b) Create a query to display the following information
Flat No,Owner name, Receipt Id,r Date , Amount
c) Create a form and Report
For all the above questions, paste screenshots of table, query, form and
report.

You might also like