SimonMash.com | Kerala Plus One & Plus Two Study Notes, Question Papers, Answer Keys, Resources

Chapter 6: Database Management System (LibreOffice Base) 📌 Chapter 6 – Important Topics: Database – Definition, Need, Advantages DBMS – Definition, Components LibreOffice Base – Introduction Key Terms – Table, Field, Record, Entity, Attribute, Primary Key, Foreign Key, Relationship, Query, Form, Report Steps to Create a Database Creating Tables (Design View, Data Types, Primary Key) Defining Relationships Creating Forms (Wizard, Design View, Controls, Subforms) Creating Queries (Wizard, Design View, Criteria, Computational Fields) Creating Reports (Wizard, Static vs Dynamic) Advanced Example – Ledger Creation & Voucher Entry Form Previous Year Exam Questions (2018–2024) 1. What is a Database? A database is a collection of related data that is organised so that you can easily view, access, manage and update the data. Simple Explanation: Think of a database as a smart digital filing cabinet. Instead of paper files, you store ...

Chapter 3: Use of Spreadsheet in Business Applications 📌 Chapter 3 – Important Topics: Payroll Accounting – Components, Gross Pay, Net Pay, Template Design Asset Accounting – Depreciation, SLN (Straight Line), DB (Written Down Value) Loan Repayment Schedule – EMI, PMT Function, Loan Amortisation Previous Year Exam Questions (2018–2024) Introduction Spreadsheet can be used for a number of purposes in business, some of them are Payroll Accounting, Asset Management and Loan Repayment Schedule. Simple Explanation: Spreadsheets help businesses automate repetitive calculations – salary, asset value, loan instalments – saving time and avoiding manual errors. 📌 Live Example 1 – Payroll: A company with 200 employees calculates DA, HRA, PF and TDS for each person every month. Using formulas, the whole payroll is ready in seconds. 📌 Live Example 2 – Asset: A transport firm owns 50 vehicles. It uses SLN function to compute yearly depreciation and know the...