Kexi/Handbook: Difference between revisions

    From KDE UserBase Wiki
    No edit summary
    m (synchronise wording of links and headings)
     
    (21 intermediate revisions by 3 users not shown)
    Line 5: Line 5:


    <!--T:2-->
    <!--T:2-->
    {{Info|'''This is original Kexi handbook for Kexi 2.x. It is always most up-to-date version.''' Based on it, [http://docs.kde.org/stable/en/calligra/kexi/index.html HTML version], and [http://docs.kde.org/stable/en/calligra/kexi/kexi.pdf PDF version] is auto-generated. Translation to other languages may be available (select your language and click on ''calligra'' link at http://docs.kde.org). You can find handbooks for other calligra  apps there too.<br/>
    {{Info|'''This is original Kexi handbook for Kexi 2.x. It is always most up-to-date version.''' Based on it, [http://docs.kde.org/development/en/calligra/kexi/index.html on docs.kde.org HTML version], and [http://docs.kde.org/stable/en/calligra/kexi/kexi.pdf PDF version] is auto-generated. Translation to other languages may be available (select your language and click on ''calligra'' link at http://docs.kde.org). You can find handbooks for other calligra  apps there too.<br/>
    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.<br />Please use rules from [http://edu.kde.org/development/document.php Documentation Tutorial].}}
    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.<br />Please use rules from [http://edu.kde.org/development/document.php Documentation Tutorial].}}
    __NOTOC__
    __NOTOC__
    Line 23: Line 23:
    <!-- <translate>
    <!-- <translate>
    <!--T:24-->
    <!--T:24-->
    ::[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/The Kexi Main Window/Main application elements|Main application elements]]</translate> -->
    ::[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/The Kexi Main Window/Main application elements|Main Application Elements]]</translate> -->
    <translate>
    <translate>
    <!--T:25-->
    <!--T:25-->
    :[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/Opening an existing Kexi database file|Opening an existing Kexi database file]]</translate>
    :[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/Opening an existing Kexi database file|Opening an Existing Kexi Database File]]</translate>
    <translate>
    <translate>
    <!--T:26-->
    <!--T:26-->
    ::[[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 database file in the Open Project dialog|Opening an Existing Database File in the Open Project Dialog]]</translate>
    <translate>
    <translate>
    <!--T:27-->
    <!--T:27-->
    ::[[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>
    ::[[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>
    <translate>
    <!--T:28-->
    <!--T:28-->
    :[[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]]


    ==[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases|Building Simple Databases]]== <!--T:6-->
    ==[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases|Building Simple Databases]]== <!--T:6-->
    Line 58: Line 58:
    <translate>
    <translate>
    <!--T:34-->
    <!--T:34-->
    ::[[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/Important terms|Important terms]]</translate>
    <translate>
    <translate>
    <!--T:35-->
    <!--T:35-->
    Line 92: Line 92:
    <!--T:45-->
    <!--T:45-->
    :[[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]]
    :[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Reports|Designing Reports]]


    ==[[Special:MyLanguage/Kexi/Handbook/Configuring Kexi|Configuring Kexi]]== <!--T:8-->
    ==[[Special:MyLanguage/Kexi/Handbook/Configuring Kexi|Configuring Kexi]]== <!--T:8-->
    Line 99: Line 100:
    :[[Special:MyLanguage/Kexi/Handbook/Configuring Kexi/Docking and undocking side panels|Docking and undocking side panels]]
    :[[Special:MyLanguage/Kexi/Handbook/Configuring Kexi/Docking and undocking side panels|Docking and undocking side panels]]


    ==[[Special:MyLanguage/Kexi/Handbook/Command Reference|Command Reference]]== <!--T:10-->
    ==[[Special:MyLanguage/Kexi/Handbook/Where to go next|Where to Go Next?]]== <!--T:57-->
     
    ==[[Special:MyLanguage/Kexi/Handbook/Glossary|Appendix A. Glossary]]== <!--T:60-->
     
    ==[[Special:MyLanguage/Kexi/Handbook/Introduction to Databases|Appendix B. Introduction to Databases]]== <!--T:13-->
     
    <!--T:14-->
    :[[Special:MyLanguage/Kexi/Handbook/Introduction to Databases/What Is a Database?|What Is a Database?]]</translate>
    <translate>
    <!--T:53-->
    :[[Special:MyLanguage/Kexi/Handbook/Introduction to Databases/Database and Spreadsheet|Database and Spreadsheet]]</translate>
    <translate>
    <!--T:54-->
    :[[Special:MyLanguage/Kexi/Handbook/Introduction to Databases/Database Design|Database Design]]</translate>
    <translate>
    <!--T:55-->
    :[[Special:MyLanguage/Kexi/Handbook/Introduction to Databases/Who Needs a Database?|Who Needs a Database?]]</translate>
    <translate>
    <!--T:56-->
    :[[Special:MyLanguage/Kexi/Handbook/Introduction to Databases/Database Creation Software|Database Creation Software]]
    </translate>
    <translate>
     
    ==[[Special:MyLanguage/Kexi/Handbook/References|Appendix C. References]]== <!--T:61-->


    <!--T:11-->
    <!--T:11-->
    :[[Special:MyLanguage/Kexi/Handbook/Command Reference/The Kexi Tab|The Kexi Tab]]</translate>
    :[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands|Menu Commands]]
    <translate>
    ::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The Kexi Tab|The Kexi Tab]]</translate>
    <!--T:46-->
    :[[Special:MyLanguage/Kexi/Handbook/Command Reference/The Project Tab|The Project Tab]]</translate>
    <translate>
    <translate>
    <!--T:47-->
    <!--T:47-->
    :[[Special:MyLanguage/Kexi/Handbook/Command Reference/The Create Tab|The Create Tab]]</translate>
    ::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The Create Tab|The Create Tab]]</translate>
    <translate>
    <translate>
    <!--T:48-->
    <!--T:48-->
    :[[Special:MyLanguage/Kexi/Handbook/Command Reference/The Data Tab|The Data Tab]]</translate>
    ::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The Data Tab|The Data Tab]]</translate>
    <translate>
    <translate>
    <!--T:49-->
    <!--T:49-->
    :[[Special:MyLanguage/Kexi/Handbook/Command Reference/The External Data Tab|The External Data Tab]]</translate>
    ::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The External Data Tab|The External Data Tab]]</translate>
    <translate>
    <translate>
    <!--T:50-->
    <!--T:50-->
    :[[Special:MyLanguage/Kexi/Handbook/Command Reference/The Tools Tab|The Tools Tab]]</translate>
    ::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The Tools Tab|The Tools Tab]]</translate>
    ::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The Help Menu|The Help Menu]]
    <translate>
    <translate>
    <!--T:51-->
    <!--T:51-->
    :[[Special:MyLanguage/Kexi/Handbook/Command Reference/The Form Design Tab|The Form Design Tab]]</translate>
    ::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The Form Design Tab|The Form Design Tab]]</translate>
    <translate>
    <translate>
    <!--T:52-->
    <!--T:52-->
    :[[Special:MyLanguage/Kexi/Handbook/Command Reference/The Report Design Tab|The Report Design Tab]]
    ::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The Report Design Tab|The Report Design Tab]]</translate>
    <!-- NOT PRESENT    The Settings Menu -->
    <translate>
    <!-- NOT PRESENT    The Help Menu -->
    <!--T:67-->
     
    :[[Special:MyLanguage/Kexi/Handbook/References/Keyboard Shortcuts|Keyboard Shortcuts]]</translate>
    ==[[Special:MyLanguage/Kexi/Handbook/Where to go next|Where to go next]]== <!--T:57-->
    <translate>
     
    <!--T:68-->
    ==[[Special:MyLanguage/Kexi/Handbook/Credits and License|Credits and License]]== <!--T:12-->
    <!-- Table Design related references -->
     
    :[[Special:MyLanguage/Kexi/Handbook/References/Data Types|Data Types]]</translate>
    ==[[Special:MyLanguage/Kexi/Handbook/Appendix A. Introduction to Databases|Appendix A. Introduction to Databases]]== <!--T:13-->
    <translate>
     
    <!--T:69-->
    <!--T:14-->
    <!-- Query Design related references -->
    :[[Special:MyLanguage/Kexi/Handbook/Introduction to Databases/What Is a Database?|What Is a Database?]]</translate>
    :[[Special:MyLanguage/Kexi/Handbook/References/SQL Reference|SQL Reference]]</translate>
    <translate>
    <!--T:70-->
    ::[[Special:MyLanguage/Kexi/Handbook/References/SQL Reference/SQL Reserved Words|SQL Reserved Words]]</translate>
    <translate>
    <!--T:71-->
    <!-- Form Design related references -->
    :[[Special:MyLanguage/Kexi/Handbook/References/Form Widgets|Form Widgets]]</translate>
    <translate>
    <!--T:72-->
    <!-- Report Design related references -->
    :[[Special:MyLanguage/Kexi/Handbook/References/Report Elements|Report Elements]]</translate>
    <translate>
    <!--T:73-->
    <!-- Macro Design related references -->
    <!-- UNIMPLEMENTED: :[[Special:MyLanguage/Kexi/Handbook/References/Macro Commands|Macro Commands]] --></translate>
    <translate>
    <!--T:74-->
    <!-- Script Design related references -->
    <!-- UNIMPLEMENTED: :[[Special:MyLanguage/Kexi/Handbook/References/Scripting Object Model|Scripting Object Model]] --></translate>
    <translate>
    <!--T:75-->
    <!-- UNIMPLEMENTED: :[[Special:MyLanguage/Kexi/Handbook/References/Plugins|Plugins]] -->
    <!-- UNIMPLEMENTED: :[[Special:MyLanguage/Kexi/Handbook/References/Configuration Options|Configuration Options]] --></translate>
    <translate>
    <!--T:76-->
    :[[Special:MyLanguage/Kexi/Handbook/References/Command-Line Options|Command-Line Options]] </translate>
    <translate>
    <translate>
    <!--T:53-->
    <!--T:77-->
    :[[Special:MyLanguage/Kexi/Handbook/Introduction to Databases/Database and Spreadsheet|Database and Spreadsheet]]</translate>
    <!-- Use 'kexi --help' -->
    :[[Special:MyLanguage/Kexi/Handbook/References/Supported File Formats|Supported File Formats]]</translate>
    <translate>
    <translate>
    <!--T:54-->
    <!--T:78-->
    :[[Special:MyLanguage/Kexi/Handbook/Introduction to Databases/Database Design|Database Design]]</translate>
    ::[[Special:MyLanguage/Kexi/Handbook/References/Supported File Formats/Microsoft Access File Formats|Microsoft Access File Formats]]</translate>
    <translate>
    <translate>
    <!--T:55-->
    <!--T:79-->
    :[[Special:MyLanguage/Kexi/Handbook/Introduction to Databases/Who Needs a Database?|Who Needs a Database?]]</translate>
    ::[[Special:MyLanguage/Kexi/Handbook/References/Supported File Formats/Comma-separated Values Format|Comma-separated Values Format (CSV)]]</translate>
    <translate>
    <translate>
    <!--T:56-->
    <!--T:80-->
    :[[Special:MyLanguage/Kexi/Handbook/Introduction to Databases/Database Creation Software|Database Creation Software]]
    :[[Special:MyLanguage/Kexi/Handbook/References/Kexi Specifications|Kexi Specifications]]


    ==[[Special:MyLanguage/Kexi/Handbook/Appendix B. Comparing Kexi to other database applications|Appendix B. Comparing Kexi to other database applications]]== <!--T:15-->
    ==[[Special:MyLanguage/Kexi/Handbook/Kexi and Other Database Applications|Appendix D. Kexi and Other Database Applications]]== <!--T:15-->


    <!--T:16-->
    <!--T:16-->
    :[[Special:MyLanguage/Kexi/Handbook/Comparing Kexi to other database applications/Data types|Data types]]
    :[[Special:MyLanguage/Kexi/Handbook/Kexi and Other Database Applications/Data Types|Data Types]]
     
    ==[[Special:MyLanguage/Kexi/Handbook/Technical Support|Technical Support]]== <!--T:62-->
     
    ==[[Special:MyLanguage/Kexi/Handbook/Contributing to the Kexi Project|Contributing to the Kexi Project]]== <!--T:63-->


    ==[[Special:MyLanguage/Kexi/Handbook/Appendix C. Reserved words for SQL|Appendix C. Reserved words for SQL]]== <!--T:17-->
    <!--T:64-->
    :[[Special:MyLanguage/Kexi/Handbook/Reporting Bugs or Wishes|Reporting Bugs or Wishes]]


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


    <!--T:59-->
    ==[[Special:MyLanguage/Kexi/Handbook/Index|Index]]== <!--T:66-->
    ----
     
    ==[[Special:MyLanguage/Kexi/Handbook/Credits and License|Credits and License]]== <!--T:12-->


    ==Tools== <!--T:19-->
    ==Tools== <!--T:19-->

    Latest revision as of 19:28, 15 May 2015

    ← Back

    Information

    This is original Kexi handbook for Kexi 2.x. It is always most up-to-date version. Based on it, on docs.kde.org HTML version, and PDF version is auto-generated. Translation to other languages may be available (select your language and click on calligra link at http://docs.kde.org). You can find handbooks for other calligra apps there too.
    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 an Existing Database File in the Open 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
    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
    Designing Reports

    Configuring Kexi

    Docking and undocking side panels

    Where to Go Next?

    Appendix A. Glossary

    Appendix B. Introduction to Databases

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

    Appendix C. References

    Menu Commands
    The Kexi Tab
    The Create Tab
    The Data Tab
    The External Data Tab
    The Tools Tab
    The Help Menu
    The Form Design Tab
    The Report Design Tab
    Keyboard Shortcuts
    Data Types
    SQL Reference
    SQL Reserved Words
    Form Widgets
    Report Elements
    Command-Line Options
    Supported File Formats
    Microsoft Access File Formats
    Comma-separated Values Format (CSV)
    Kexi Specifications

    Appendix D. Kexi and Other Database Applications

    Data Types

    Technical Support

    Contributing to the Kexi Project

    Reporting Bugs or Wishes

    Bibliography

    Index

    Credits and License

    Tools