Kexi/Handbook: Difference between revisions

From KDE UserBase Wiki
No edit summary
m (synchronise wording of links and headings)
 
(54 intermediate revisions by 6 users not shown)
Line 1: Line 1:
[[Kexi|← Back]]
<languages />
<translate>
<!--T:1-->
[[Special:MyLanguage/Kexi|&larr; Back]]


{{Construction}}
<!--T:2-->
{{Info|This handbook for Kexi 2.2 is meant to be based on the Kexi Handbook [http://docs.kde.org/stable/en/koffice/kexi/index.html for Kexi 1.1].<br/>Please coordinate any effort with Jarosław Staniek, email: kexi at kde.org}}
{{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].}}
__NOTOC__
__NOTOC__


==Introduction==
==[[Special:MyLanguage/Kexi/Handbook/Introduction|Introduction]]== <!--T:3-->
:[[Kexi/Handbook/Introduction|Introduction]]


==Kexi Basics==
==[[Special:MyLanguage/Kexi/Handbook/Kexi Basics|Kexi Basics]]== <!--T:4-->
Kexi Basics
    Kexi Databases
    Creating a New Database File
    The Kexi Main Window


        Main application elements  
<!--T:5-->
:[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/Kexi Databases|Kexi Databases]]</translate>
<translate>
<!--T:22-->
:[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/Creating a New Database File|Creating a New Database File]]</translate>
<translate>
<!--T:23-->
:[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/The Kexi Main Window|The Kexi Main Window]]</translate>
<!-- <translate>
<!--T:24-->
::[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/The Kexi Main Window/Main application elements|Main Application Elements]]</translate> -->
<translate>
<!--T:25-->
:[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/Opening an existing Kexi database file|Opening an Existing Kexi Database File]]</translate>
<translate>
<!--T:26-->
::[[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>
<!--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>
<translate>
<!--T:28-->
:[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/Using built-in help|Using Built-In Help]]


    Opening an existing Kexi database file
==[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases|Building Simple Databases]]== <!--T:6-->


        Opening a database file in the Open Existing Project dialog
<!--T:7-->
        Opening an existing Kexi database file by clicking on .kexi file's icon
:[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases|Introduction]]</translate>
<translate>
<!--T:29-->
:[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Tables|Designing Database Tables]]</translate>
<translate>
<!--T:30-->
::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Tables/The Table Designer window|The Table Designer window]]</translate>
<translate>
<!--T:31-->
:[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Entering Data Into Tables|Entering Data Into Tables]]</translate>
<translate>
<!--T:32-->
:[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Queries|Designing Database Queries]]</translate>
<translate>
<!--T:33-->
:[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms|Designing Forms]]</translate>
<translate>
<!--T:34-->
::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Important terms|Important terms]]</translate>
<translate>
<!--T:35-->
::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Forms versus tables|Forms versus tables]]</translate>
<translate>
<!--T:36-->
::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Working with form design|Working with form design]]</translate>
<translate>
<!--T:37-->
::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Using the Widgets tab|Using the Widgets tab]]</translate>
<translate>
<!--T:38-->
::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Inserting widgets - text fields|Inserting widgets - text fields]]</translate>
<translate>
<!--T:39-->
::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Assigning data sources|Assigning data sources]]</translate>
<translate>
<!--T:40-->
::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Inserting text labels|Inserting text labels]]</translate>
<translate>
<!--T:41-->
::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Actions|Actions]]</translate>
<translate>
<!--T:42-->
::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Widget layouts|Widget layouts]]</translate>
<translate>
<!--T:43-->
::[[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>
<!--T:44-->
::[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Setting the tab order|Setting the tab order]]</translate>
<translate>
<!--T:45-->
:[[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]]


    Using built-in help
==[[Special:MyLanguage/Kexi/Handbook/Configuring Kexi|Configuring Kexi]]== <!--T:8-->


3. Building Simple Databases
<!--T:9-->
<!-- UNIMPLEMENTED: :[[Special:MyLanguage/Kexi/Handbook/Configuring Kexi/Docking and Undocking Windows|Docking and Undocking Windows]]-->
:[[Special:MyLanguage/Kexi/Handbook/Configuring Kexi/Docking and undocking side panels|Docking and undocking side panels]]


    Introduction
==[[Special:MyLanguage/Kexi/Handbook/Where to go next|Where to Go Next?]]== <!--T:57-->
    Designing Database Tables


        The Table Designer window
==[[Special:MyLanguage/Kexi/Handbook/Glossary|Appendix A. Glossary]]== <!--T:60-->


    Entering Data Into Tables
==[[Special:MyLanguage/Kexi/Handbook/Introduction to Databases|Appendix B. Introduction to Databases]]== <!--T:13-->
    Designing Database Queries
    Designing Forms


        Most important terms
<!--T:14-->
        Forms versus tables
:[[Special:MyLanguage/Kexi/Handbook/Introduction to Databases/What Is a Database?|What Is a Database?]]</translate>
        Working with form design
<translate>
        Using the Widgets tab
<!--T:53-->
        Inserting widgets - text fields
:[[Special:MyLanguage/Kexi/Handbook/Introduction to Databases/Database and Spreadsheet|Database and Spreadsheet]]</translate>
        Assigning data sources
<translate>
        Inserting text labels
<!--T:54-->
        Actions
:[[Special:MyLanguage/Kexi/Handbook/Introduction to Databases/Database Design|Database Design]]</translate>
        Widget layouts
<translate>
        Setting widgets size and position by hand
<!--T:55-->
        Setting the tab order
:[[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>


    Entering Data Using Forms
==[[Special:MyLanguage/Kexi/Handbook/References|Appendix C. References]]== <!--T:61-->


4. Configuring Kexi
<!--T:11-->
:[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands|Menu Commands]]
::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The Kexi Tab|The Kexi Tab]]</translate>
<translate>
<!--T:47-->
::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The Create Tab|The Create Tab]]</translate>
<translate>
<!--T:48-->
::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The Data Tab|The Data Tab]]</translate>
<translate>
<!--T:49-->
::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The External Data Tab|The External Data Tab]]</translate>
<translate>
<!--T:50-->
::[[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>
<!--T:51-->
::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The Form Design Tab|The Form Design Tab]]</translate>
<translate>
<!--T:52-->
::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The Report Design Tab|The Report Design Tab]]</translate>
<translate>
<!--T:67-->
:[[Special:MyLanguage/Kexi/Handbook/References/Keyboard Shortcuts|Keyboard Shortcuts]]</translate>
<translate>
<!--T:68-->
<!-- Table Design related references -->
:[[Special:MyLanguage/Kexi/Handbook/References/Data Types|Data Types]]</translate>
<translate>
<!--T:69-->
<!-- Query Design related references -->
:[[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>
<!--T:77-->
<!-- Use 'kexi --help' -->
:[[Special:MyLanguage/Kexi/Handbook/References/Supported File Formats|Supported File Formats]]</translate>
<translate>
<!--T:78-->
::[[Special:MyLanguage/Kexi/Handbook/References/Supported File Formats/Microsoft Access File Formats|Microsoft Access File Formats]]</translate>
<translate>
<!--T:79-->
::[[Special:MyLanguage/Kexi/Handbook/References/Supported File Formats/Comma-separated Values Format|Comma-separated Values Format (CSV)]]</translate>
<translate>
<!--T:80-->
:[[Special:MyLanguage/Kexi/Handbook/References/Kexi Specifications|Kexi Specifications]]


    Window Layout
==[[Special:MyLanguage/Kexi/Handbook/Kexi and Other Database Applications|Appendix D. Kexi and Other Database Applications]]== <!--T:15-->


        IDEAl mode
<!--T:16-->
        Childframe mode
:[[Special:MyLanguage/Kexi/Handbook/Kexi and Other Database Applications/Data Types|Data Types]]


    Docking and Undocking Windows
==[[Special:MyLanguage/Kexi/Handbook/Technical Support|Technical Support]]== <!--T:62-->


        Docking and undocking side panels
==[[Special:MyLanguage/Kexi/Handbook/Contributing to the Kexi Project|Contributing to the Kexi Project]]== <!--T:63-->
        Docking and undocking child windows


5. Command Reference
<!--T:64-->
:[[Special:MyLanguage/Kexi/Handbook/Reporting Bugs or Wishes|Reporting Bugs or Wishes]]


    The File Menu
==[[Special:MyLanguage/Kexi/Handbook/Bibliography|Bibliography]]== <!--T:65-->
    The Edit Menu
    The View Menu
    The Insert Menu
    The Format Menu
    The Data Menu
    The Tools Menu
    The Window Menu
    The Settings Menu
    The Help Menu


6. Credits and License
==[[Special:MyLanguage/Kexi/Handbook/Index|Index]]== <!--T:66-->
A. Introduction to Databases


    What Is a Database?
==[[Special:MyLanguage/Kexi/Handbook/Credits and License|Credits and License]]== <!--T:12-->
    Database and Spreadsheet


        How Is a Database Different From a Spreadsheet?
==Tools== <!--T:19-->


    Database Design
<!--T:20-->
    Who Needs a Database?
*[[Kexi/Handbook/_Template|Page Template]]
    Database Creation Software
 
B. Comparing Kexi to other database applications
 
    Data types


==Tools==
<!--T:21-->
*[[Kexi/Handbook/_Template|Page Template]]
[[Category:Kexi]]
[[Category:Tutorials]]
[[Category:Office]]
</translate>

Latest revision as of 19:28, 15 May 2015

Other languages:

← 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

Retrieved from "https://userbase.kde.org/index.php?title=Kexi/Handbook&oldid=346584"