Kexi/Handbook: Difference between revisions

From KDE UserBase Wiki
(indices)
(add more placeholders for appendices/references, moved menu reference to references)
Line 98: Line 98:
<!-- UNIMPLEMENTED: :[[Special:MyLanguage/Kexi/Handbook/Configuring Kexi/Docking and Undocking Windows|Docking and Undocking Windows]]-->
<!-- 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]]
:[[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-->
<!--T:11-->
:[[Special:MyLanguage/Kexi/Handbook/Command Reference/The Kexi Tab|The Kexi Tab]]</translate>
<translate>
<!--T:46-->
:[[Special:MyLanguage/Kexi/Handbook/Command Reference/The Project Tab|The Project Tab]]</translate>
<translate>
<!--T:47-->
:[[Special:MyLanguage/Kexi/Handbook/Command Reference/The Create Tab|The Create Tab]]</translate>
<translate>
<!--T:48-->
:[[Special:MyLanguage/Kexi/Handbook/Command Reference/The Data Tab|The Data Tab]]</translate>
<translate>
<!--T:49-->
:[[Special:MyLanguage/Kexi/Handbook/Command Reference/The External Data Tab|The External Data Tab]]</translate>
<translate>
<!--T:50-->
:[[Special:MyLanguage/Kexi/Handbook/Command Reference/The Tools Tab|The Tools Tab]]</translate>
<translate>
<!--T:51-->
:[[Special:MyLanguage/Kexi/Handbook/Command Reference/The Form Design Tab|The Form Design Tab]]</translate>
<translate>
<!--T:52-->
:[[Special:MyLanguage/Kexi/Handbook/Command Reference/The Report Design Tab|The Report Design Tab]]
<!-- NOT PRESENT    The Settings Menu -->
<!-- NOT PRESENT    The Help Menu -->


==[[Special:MyLanguage/Kexi/Handbook/Where to go next|Where to go next]]== <!--T:57-->
==[[Special:MyLanguage/Kexi/Handbook/Where to go next|Where to go next]]== <!--T:57-->


==[[Special:MyLanguage/Kexi/Handbook/Credits and License|Credits and License]]== <!--T:12-->
==[[Special:MyLanguage/Kexi/Handbook/Appendix A. Glossary|Appendix A. Glossary]]==


==[[Special:MyLanguage/Kexi/Handbook/Appendix A. Introduction to Databases|Appendix A. Introduction to Databases]]== <!--T:13-->
==[[Special:MyLanguage/Kexi/Handbook/Appendix B. Introduction to Databases|Appendix B. Introduction to Databases]]== <!--T:13-->


<!--T:14-->
<!--T:14-->
Line 147: Line 119:
<!--T:56-->
<!--T:56-->
:[[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]]
</translate>
<translate>


==[[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/Appendix C. References|Appendix C. References]]==
 
:[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands|Menu Commands]]
 
<!--T:11-->
::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The Kexi Tab|The Kexi Tab]]</translate>
<translate>
<!--T:46-->
::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The Project Tab|The Project 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>
<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]]
::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The Help Menu|The Help Menu]]
 
:[[Special:MyLanguage/Kexi/Handbook/References/Keyboard Shortcuts|Keyboard Shortcuts]]
<!-- Table Design related references -->
:[[Special:MyLanguage/Kexi/Handbook/References/Data Types|Data Types]]
<!-- Query Design related references -->
:[[Special:MyLanguage/Kexi/Handbook/References/SQL Reference|SQL Reference]]
::[[Special:MyLanguage/Kexi/Handbook/References/SQL Reserved Words|SQL Reserved Words]]
<!-- Form Design related references -->
:[[Special:MyLanguage/Kexi/Handbook/References/Form Widgets|Form Widgets]]
<!-- Report Design related references -->
:[[Special:MyLanguage/Kexi/Handbook/References/Report Elements|Report Elements]]
<!-- Macro Design related references -->
<!-- UNIMPLEMENTED: :[[Special:MyLanguage/Kexi/Handbook/References/Macro Commands|Macro Commands]] -->
<!-- Script Design related references -->
<!-- UNIMPLEMENTED: :[[Special:MyLanguage/Kexi/Handbook/References/Scripting Object Model|Scripting Object Model]] -->
<!-- UNIMPLEMENTED: :[[Special:MyLanguage/Kexi/Handbook/References/Plugins|Plugins]] -->
<!-- UNIMPLEMENTED: :[[Special:MyLanguage/Kexi/Handbook/References/Configuration Options|Configuration Options]] -->
:[[Special:MyLanguage/Kexi/Handbook/References/Command-Line Options|Command-Line Options]] <!-- Use 'kexi --help' -->
:[[Special:MyLanguage/Kexi/Handbook/References/Supported File Formats|Supported File Formats]]
::[[Special:MyLanguage/Kexi/Handbook/References/Supported File Formats/Microsoft Access File Formats (MDB)|Microsoft Access File Formats]]
::[[Special:MyLanguage/Kexi/Handbook/References/Supported File Formats/Comma-separated Values Format (CSV)|Comma-separated Values Format (CSV)]]
 
==[[Special:MyLanguage/Kexi/Handbook/Appendix D. 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/Appendix C. Reserved words for SQL|Appendix C. Reserved words for SQL]]== <!--T:17-->
==[[Special:MyLanguage/Kexi/Handbook/Technical Support|Technical Support]]==


==[[Special:MyLanguage/Kexi/Handbook/Appendix D. Supported File Formats|Appendix D. Supported File Formats]]== <!--T:58-->
==[[Special:MyLanguage/Kexi/Handbook/Contributing to the Kexi Project|Contributing to the Kexi Project]]==  


<!--T:59-->
:[[Special:MyLanguage/Kexi/Handbook/Reporting Bugs or Wishes|Reporting Bugs or Wishes]]
----


==[[Special:MyLanguage/Kexi/Handbook/Appendix E. Reporting Bugs or Wishes|Appendix E. Reporting Bugs or Wishes]]==  
==[[Special:MyLanguage/Kexi/Handbook/Bibliography|Bibliography]]==


==[[Special:MyLanguage/Kexi/Handbook/Appendix E. Indexes|Appendix E. Indexes]]==
==[[Special:MyLanguage/Kexi/Handbook/Index|Index]]==


===[[Special:MyLanguage/Kexi/Handbook/E.1. Concept Index|E.1. Concept Index]]===
==[[Special:MyLanguage/Kexi/Handbook/Credits and License|Credits and License]]== <!--T:12-->
===[[Special:MyLanguage/Kexi/Handbook/E.2. Index of Commands|E.1. Index of Commands]]===
===[[Special:MyLanguage/Kexi/Handbook/E.3. Index of Command-Line Options|E.2. Index of Command-Line Options]]===
===[[Special:MyLanguage/Kexi/Handbook/E.4. Index of Supported File Formats|E.4. Index of Supported File Formats]]===


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

Revision as of 20:30, 27 August 2014

Other languages:

← 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. 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 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

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 Project Tab
The Create Tab
The Data Tab
The External Data Tab
The Tools Tab
The Form Design Tab
The Report Design Tab
The Help Menu
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)

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=337483"