Kexi/Handbook: Difference between revisions

    From KDE UserBase Wiki
    No edit summary
    (Marked this version for translation)
    Line 154: Line 154:
    ==[[Special:MyLanguage/Kexi/Handbook/Appendix C. Reserved words for SQL|Appendix C. Reserved words for SQL]]== <!--T:17-->
    ==[[Special:MyLanguage/Kexi/Handbook/Appendix C. Reserved words for SQL|Appendix C. Reserved words for SQL]]== <!--T:17-->


    ==[[Kexi/Handbook/Appendix D. Supported File Formats|Appendix D. Supported File Formats]]==
    ==[[Kexi/Handbook/Appendix D. Supported File Formats|Appendix D. Supported File Formats]]== <!--T:58-->


    <!--T:59-->
    ----
    ----



    Revision as of 04:58, 11 September 2012

    ← Back

    Information

    This is original Kexi handbook for Kexi 2.x. It is always most up-to-date version. Based on it, HTML version, and PDF version is auto-generated. There is also old Kexi 1.x Handbook. Other calligra handbooks are available at [1].
    The works on this handbook are currently assigned to Dimitrios T Tanis, email: dimitrios.tanis at kdemail.net. Please do not start anything but minor corrections without coordinating with maintainer, Jarosław Staniek, email: staniek at kde.org.
    Please use rules from Documentation Tutorial.


    Introduction

    Kexi Basics

    Kexi Databases
    Creating a New Database File
    The Kexi Main Window
    Opening an existing Kexi database file
    Opening a database file in the Open Existing Project dialog
    Opening an existing Kexi database file by clicking on .kexi file's icon
    Using built-in help

    Building Simple Databases

    Introduction
    Designing Database Tables
    The Table Designer window
    Entering Data Into Tables
    Designing Database Queries
    Designing Forms
    Most important terms
    Forms versus tables
    Working with form design
    Using the Widgets tab
    Inserting widgets - text fields
    Assigning data sources
    Inserting text labels
    Actions
    Widget layouts
    Setting widgets size and position by hand
    Setting the tab order
    Entering Data Using Forms

    Configuring Kexi

    Docking and undocking side panels

    Command Reference

    The Kexi Tab
    The Project Tab
    The Create Tab
    The Data Tab
    The External Data Tab
    The Tools Tab
    The Form Design Tab
    The Report Design Tab

    Where to go next

    Credits and License

    Appendix A. Introduction to Databases

    What Is a Database?
    Database and Spreadsheet
    Database Design
    Who Needs a Database?
    Database Creation Software

    Appendix B. Comparing Kexi to other database applications

    Data types

    Appendix C. Reserved words for SQL

    Appendix D. Supported File Formats


    Tools