Application SoftwareApplication Software

Word processors are designed for creating, editing, formatting, and printing text documents. Essential for drafting official correspondence in the High Court.

• Default File Extensions: Modern MS Word uses '.docx' (introduced in Office 2007, based on OpenXML), whereas older versions used '.doc'. Macro-enabled documents use '.docm'.
• Mail Merge: A powerful feature used to create personalized letters, labels, and envelopes by combining a main document with a data source (e.g., Excel sheet or database).
• Clipboard and Formatting: Format Painter copies formatting from one place to another. MS Word clipboard can store up to 24 multiple items copied from various locations.
• Keyboard Shortcuts: Frequently asked shortcuts include Ctrl+Shift+> (Increase font size), Ctrl+[ (Decrease font size), Ctrl+J (Justify alignment), and Ctrl+K (Insert hyperlink).
• Track Changes and Comments: Review tab features allow tracking edits, insertions, and deletions made by multiple users, critical for legal document review.

Spreadsheets organize data in rows and columns, performing mathematical calculations, data analysis, and graphical representation.

• Default File Extensions: MS Excel uses '.xlsx' as the default format since Excel 2007. Binary workbooks use '.xlsb', and macro-enabled workbooks use '.xlsm'.
• Grid Dimensions and Limits: Excel 2016/2019/2021 worksheet contains 1,048,576 rows and 16,384 columns (ending at column XFD).
• Cell Addressing and References: Cell addresses are combination of column letter and row number (e.g., A1). Absolute reference uses dollar signs (e.g., $A$1) to lock rows/columns.
• Core Formulas and Functions: Every formula in Excel must begin with an equals sign ('='). Common functions include VLOOKUP, HLOOKUP, COUNTIF, SUMIF, INDEX, and MATCH.
• Charts and Data Visualization: Excel provides multiple chart types including Column, Bar, Line, Pie, Scatter, and Area charts to visually represent numerical data sets.

Presentation software enables creation of multimedia slide decks for meetings, training sessions, and administrative briefings.

• Default File Extensions: Modern PowerPoint presentations use '.pptx'. Slide shows saved directly open in presentation mode use '.ppsx', and templates use '.potx'.
• Slide Views: Important views include Normal View, Slide Sorter View (displays thumbnail previews of all slides), Reading View, and Slide Show View.
• Animations vs Transitions: Slide Transitions control how the presentation moves from one slide to the next. Animations control individual elements (text, images, shapes) within a single slide.
• Master Slides: Slide Master stores information about the template, including font styles, placeholder sizes, background colors, and logo placements for uniform formatting.
• Presentation Shortcuts: F5 starts the slideshow from the beginning. Shift+F5 starts the slideshow from the current active slide.

Database Management Systems (DBMS) and utility software manage structured records, court case files, and system maintenance.

• MS Access Fundamentals: A relational database management system (RDBMS) where data is stored in Tables, queried via Queries, presented in Forms, and summarized in Reports.
• Access File Extensions: Default database extension for modern Access is '.accdb' (replacing older '.mdb' format used up to Access 2003).
• Desktop Publishing (DTP): Applications like Adobe InDesign, QuarkXPress, and CorelDRAW used for creating high-quality printed materials, gazettes, and formal notices.
• Open Source Office Suites: LibreOffice and Apache OpenOffice provide equivalents to MS Office components: Writer (Word), Calc (Excel), and Impress (PowerPoint).
• Web Browsers as Application Platforms: Modern web browsers (Chrome, Firefox, Edge) run complex web applications (SaaS), acting virtually as application execution environments.