Kexi/Handbook: Difference between revisions

    From KDE UserBase Wiki
    m (fix tags)
    (Splitting lists into smaller units)
    Line 13: Line 13:


    <!--T:5-->
    <!--T:5-->
    :[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/Kexi Databases|Kexi Databases]]
    :[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/Kexi Databases|Kexi Databases]]</translate>
    :[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/Creating a New Database File|Creating a New Database File]]
    <translate>
    :[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/The Kexi Main Window|The Kexi Main Window]]
    :[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/Creating a New Database File|Creating a New Database File]]</translate>
    ::[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/The Kexi Main Window/Main application elements|Main application elements]]
    <translate>
    :[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/Opening an existing Kexi database file|Opening an existing Kexi database file]]
    :[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/The Kexi Main Window|The Kexi Main Window]]</translate>
    ::[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/Opening an existing Kexi database file/Opening a database file in the Open Existing Project dialog|Opening a database file in the Open Existing Project dialog]]
    <translate>
    ::[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/Opening an existing Kexi database file/Opening an existing Kexi database file by clicking on .kexi file's icon|Opening an existing Kexi database file by clicking on .kexi file's icon]]
    ::[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/The Kexi Main Window/Main application elements|Main application elements]]</translate>
    <translate>
    :[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/Opening an existing Kexi database file|Opening an existing Kexi database file]]</translate>
    <translate>
    ::[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/Opening an existing Kexi database file/Opening a database file in the Open Existing Project dialog|Opening a database file in the Open Existing Project dialog]]</translate>
    <translate>
    ::[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/Opening an existing Kexi database file/Opening an existing Kexi database file by clicking on .kexi file's icon|Opening an existing Kexi database file by clicking on .kexi file's icon]]</translate>
    <translate>
    :[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/Using built-in help|Using built-in help]]
    :[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/Using built-in help|Using built-in help]]


    Line 25: Line 32:


    <!--T:7-->
    <!--T:7-->
    :[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases|Introduction]]
    :[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases|Introduction]]</translate>
    :[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Tables|Designing Database Tables]]
    <translate>
    ::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Tables/The Table Designer window|The Table Designer window]]
    :[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Tables|Designing Database Tables]]</translate>
    :[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Entering Data Into Tables|Entering Data Into Tables]]
    <translate>
    :[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Queries|Designing Database Queries]]
    ::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Tables/The Table Designer window|The Table Designer window]]</translate>
    :[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms|Designing Forms]]
    <translate>
    ::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Most important terms|Most important terms]]
    :[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Entering Data Into Tables|Entering Data Into Tables]]</translate>
    ::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Forms versus tables|Forms versus tables]]
    <translate>
    ::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Working with form design|Working with form design]]
    :[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Queries|Designing Database Queries]]</translate>
    ::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Using the Widgets tab|Using the Widgets tab]]
    <translate>
    ::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Inserting widgets - text fields|Inserting widgets - text fields]]
    :[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms|Designing Forms]]</translate>
    ::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Assigning data sources|Assigning data sources]]
    <translate>
    ::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Inserting text labels|Inserting text labels]]
    ::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Most important terms|Most important terms]]</translate>
    ::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Actions|Actions]]
    <translate>
    ::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Widget layouts|Widget layouts]]
    ::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Forms versus tables|Forms versus tables]]</translate>
    ::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Setting widgets size and position by hand|Setting widgets size and position by hand]]
    <translate>
    ::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Setting the tab order|Setting the tab order]]
    ::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Working with form design|Working with form design]]</translate>
    <translate>
    ::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Using the Widgets tab|Using the Widgets tab]]</translate>
    <translate>
    ::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Inserting widgets - text fields|Inserting widgets - text fields]]</translate>
    <translate>
    ::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Assigning data sources|Assigning data sources]]</translate>
    <translate>
    ::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Inserting text labels|Inserting text labels]]</translate>
    <translate>
    ::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Actions|Actions]]</translate>
    <translate>
    ::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Widget layouts|Widget layouts]]</translate>
    <translate>
    ::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Setting widgets size and position by hand|Setting widgets size and position by hand]]</translate>
    <translate>
    ::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Setting the tab order|Setting the tab order]]</translate>
    <translate>
    :[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Entering Data Using Forms|Entering Data Using Forms]]
    :[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Entering Data Using Forms|Entering Data Using Forms]]


    Line 53: Line 77:


    <!--T:11-->
    <!--T:11-->
    :[[Special:MyLanguage/Kexi/Handbook/Command Reference/The Kexi Tab|The Kexi Tab]]
    :[[Special:MyLanguage/Kexi/Handbook/Command Reference/The Kexi Tab|The Kexi Tab]]</translate>
    :[[Special:MyLanguage/Kexi/Handbook/Command Reference/The Project Tab|The Project Tab]]
    <translate>
    :[[Special:MyLanguage/Kexi/Handbook/Command Reference/The Create Tab|The Create Tab]]
    :[[Special:MyLanguage/Kexi/Handbook/Command Reference/The Project Tab|The Project Tab]]</translate>
    :[[Special:MyLanguage/Kexi/Handbook/Command Reference/The Data Tab|The Data Tab]]
    <translate>
    :[[Special:MyLanguage/Kexi/Handbook/Command Reference/The External Data Tab|The External Data Tab]]
    :[[Special:MyLanguage/Kexi/Handbook/Command Reference/The Create Tab|The Create Tab]]</translate>
    :[[Special:MyLanguage/Kexi/Handbook/Command Reference/The Tools Tab|The Tools Tab]]
    <translate>
    :[[Special:MyLanguage/Kexi/Handbook/Command Reference/The Form Design Tab|The Form Design Tab]]
    :[[Special:MyLanguage/Kexi/Handbook/Command Reference/The Data Tab|The Data Tab]]</translate>
    <translate>
    :[[Special:MyLanguage/Kexi/Handbook/Command Reference/The External Data Tab|The External Data Tab]]</translate>
    <translate>
    :[[Special:MyLanguage/Kexi/Handbook/Command Reference/The Tools Tab|The Tools Tab]]</translate>
    <translate>
    :[[Special:MyLanguage/Kexi/Handbook/Command Reference/The Form Design Tab|The Form Design Tab]]</translate>
    <translate>
    :[[Special:MyLanguage/Kexi/Handbook/Command Reference/The Report Design Tab|The Report Design Tab]]
    :[[Special:MyLanguage/Kexi/Handbook/Command Reference/The Report Design Tab|The Report Design Tab]]
    <!-- NOT PRESENT    The Settings Menu -->
    <!-- NOT PRESENT    The Settings Menu -->
    Line 69: Line 100:


    <!--T:14-->
    <!--T:14-->
    :[[Special:MyLanguage/Kexi/Handbook/Introduction to Databases/What Is a Database?|What Is a Database?]]
    :[[Special:MyLanguage/Kexi/Handbook/Introduction to Databases/What Is a Database?|What Is a Database?]]</translate>
    :[[Special:MyLanguage/Kexi/Handbook/Introduction to Databases/Database and Spreadsheet|Database and Spreadsheet]]
    <translate>
    :[[Special:MyLanguage/Kexi/Handbook/Introduction to Databases/Database Design|Database Design]]
    :[[Special:MyLanguage/Kexi/Handbook/Introduction to Databases/Database and Spreadsheet|Database and Spreadsheet]]</translate>
    :[[Special:MyLanguage/Kexi/Handbook/Introduction to Databases/Who Needs a Database?|Who Needs a Database?]]
    <translate>
    :[[Special:MyLanguage/Kexi/Handbook/Introduction to Databases/Database Design|Database Design]]</translate>
    <translate>
    :[[Special:MyLanguage/Kexi/Handbook/Introduction to Databases/Who Needs a Database?|Who Needs a Database?]]</translate>
    <translate>
    :[[Special:MyLanguage/Kexi/Handbook/Introduction to Databases/Database Creation Software|Database Creation Software]]
    :[[Special:MyLanguage/Kexi/Handbook/Introduction to Databases/Database Creation Software|Database Creation Software]]



    Revision as of 14:17, 27 December 2011

    ← Back

    Information

    This handbook for Kexi 2.x is based on the Kexi Handbook for Kexi 1.1.
    The works are currently assigned to Dimitrios T Tanis, email: dimitrios.tanis at kdemail.net , so please do not start anything but minor corrections without coordinating with maintainer, Jarosław Staniek, email: kexi at kde.org!
    Please use rules from Documentation Tutorial.


    Introduction

    Kexi Basics

    Kexi Databases
    Creating a New Database File
    The Kexi Main Window
    Main application elements
    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

    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


    Tools