CBSE Class 10/Overview
Curriculum 2026–27
Practice
All Revision Notes
Information TechnologyCh-17 14 min comprehensive revision
CBSE Class 10 IT (402) — Part B: Unit 3 (Database Management System)

Forms & Reports in LibreOffice Base

Creating user-friendly data entry Forms using Form Wizard, Form Controls toolbar (Text Box, Label, List Box, Combo Box, Push Button), modifying forms, and creating formatted printable Reports using Report Wizard.

Quick Key Takeaways:
Forms: Interactive graphical interface for viewing, entering, and editing records one row at a time with user validation.
Reports: Formatted, printable, non-editable output summaries generated from tables or queries for presentation and decision-making.
Jump to Concept:1. Creating & Customizing Forms2. Designing & Printing Reports
1

Creating & Customizing Forms

User Interface

Forms provide an intuitive front-end for database users, protecting raw table structures from direct tampering.

• Creating Form via Wizard
In Database pane, click Forms → Use Wizard to Create Form... → Step 1: Select Table and Fields; Step 2: Set up Subform (optional); Step 3: Arrange controls (Columnar, Tabular, Block); Step 4: Set data entry mode; Step 5: Apply styles & background color; Step 6: Set name and click Finish.
• Form Controls Toolbar
Enable via View → Toolbars → Form Controls. Insert text fields, labels, option buttons (radio buttons), check boxes, list boxes (drop-down), combo boxes, and push buttons.
• Data Navigation in Forms
Use bottom Form Navigation bar to navigate First (|<), Previous (<), Next (>), Last (>|), and New Record (>*) buttons.
2

Designing & Printing Reports

Print Output

Generating professionally structured executive summaries.

• Creating Report via Wizard
Click Reports → Use Wizard to Create Report... → Step 1: Select Field Selection (from Table or Query); Step 2: Labeling fields; Step 3: Grouping levels; Step 4: Sort options; Step 5: Choose layout (Tabular/Columnar, Portrait/Landscape); Step 6: Create report.
• Report Features
Reports support calculation summaries (Sum, Average), page headers, page footers, dynamic page numbers (Page 1 of 10), and system date/time insertion.
Authentic Board Question (3 Marks)Topic: Forms & Reports in LibreOffice Base RDBMS Architecture & SQL Syntax
Explain the relational database concepts and write the precise SQL commands required for "Forms & Reports in LibreOffice Base".

Official CBSE Step-by-Step Marking Breakdown:

Step 1: Database Concept & Constraint: Define Primary Key, Foreign Key, Table, Record, Field, or Data Integrity constraint.
1 Mark
Step 2: Standard SQL Statement Syntax: Write grammatically valid SQL syntax (CREATE TABLE, SELECT ... WHERE, INSERT INTO, UPDATE).
1 Mark
Step 3: Execution Output & Semicolon Rule: Demonstrate query execution result and terminate statements with a semicolon (;).
1 Mark
Model Student Answer (Target: Full 3/3 Marks):
For full marks in CBSE IT (402) Database Management on "Forms & Reports in LibreOffice Base":

1. RDBMS Structural Rule: Define how tables store normalized records and why Primary Keys enforce entity integrity.
2. Valid SQL Query:
``sql SELECT ColumnName1, ColumnName2 FROM TableName WHERE Condition ORDER BY ColumnName ASC; ``
3. Query Execution Result: Explain how the filtering condition processes rows and returns the resultant recordset.
Examiner Mark Deduction Traps:
•Always end every SQL query with a semicolon (;). Missing semicolons cost marks.
•Write SQL keywords (SELECT, FROM, WHERE, ORDER BY, GROUP BY) in uppercase for clarity.

High-Frequency Conceptual Doubts & FAQs

Curated answers to the most common questions asked by Class 10 students.
This chapter establishes the foundational principles, definitions, and operational workflows required for Class 10 board mastery.

Next Learning Steps & Active Practice

You have completed the revision notes. Now apply, test, and evaluate your understanding.
Notes Completed