Kexi/Handbook: Difference between revisions

From KDE UserBase Wiki
(correct link to moved page)
Tag: Manual revert
 
(11 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 the newest version.''' Based on it, a [https://docs.kde.org/trunk5/en/kexi/kexi/index.html HTML version], and [https://docs.kde.org/stable5/en/kexi/kexi/kexi.pdf PDF version] is auto-generated. Translation to other languages may be available (select your language on the left hand at [https://docs.kde.org/index.php?application&#x3d;kexi]).<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].}}
Please do not make any major change without coordinating with the maintainer, Jarosław Staniek, email: staniek @ kde.org.<br />Please follow rules from the [https://l10n.kde.org/docs/doc-primer/ Documentation Guide].}}
__NOTOC__
__NOTOC__


Line 29: Line 29:
<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-->
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 101: Line 102:
==[[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/Glossary|Appendix A. Glossary]]==
==[[Special:MyLanguage/Kexi/Handbook/Glossary|Appendix A. Glossary]]== <!--T:60-->


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


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


<!--T:11-->
:[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands|Menu Commands]]
:[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands|Menu Commands]]
<!--T:11-->
::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The KEXI Menu|The KEXI Menu]]</translate>
::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The Kexi Tab|The Kexi Tab]]</translate>
<translate>
<translate>
<!--T:47-->
<!--T:47-->
Line 145: Line 146:
<translate>
<translate>
<!--T:52-->
<!--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 Report Design Tab|The Report Design Tab]]</translate>
:[[Special:MyLanguage/Kexi/Handbook/References/Keyboard Shortcuts|Keyboard Shortcuts]]
<translate>
<!--T:67-->
:[[Special:MyLanguage/Kexi/Handbook/References/Keyboard Shortcuts|Keyboard Shortcuts]]</translate>
<translate>
<!--T:68-->
<!-- Table Design related references -->
<!-- Table Design related references -->
:[[Special:MyLanguage/Kexi/Handbook/References/Data Types|Data Types]]
:[[Special:MyLanguage/Kexi/Handbook/References/Data Types|Data Types]]</translate>
<translate>
<!--T:69-->
<!-- Query Design related references -->
<!-- Query Design related references -->
:[[Special:MyLanguage/Kexi/Handbook/References/SQL Reference|SQL Reference]]
:[[Special:MyLanguage/Kexi/Handbook/References/SQL Reference|SQL Reference]]</translate>
::[[Special:MyLanguage/Kexi/Handbook/References/SQL Reference/SQL Reserved Words|SQL Reserved Words]]
<translate>
<!--T:70-->
::[[Special:MyLanguage/Kexi/Handbook/References/SQL Reference/SQL Reserved Words|SQL Reserved Words]]</translate>
<translate>
<!--T:71-->
<!-- Form Design related references -->
<!-- Form Design related references -->
:[[Special:MyLanguage/Kexi/Handbook/References/Form Widgets|Form Widgets]]
:[[Special:MyLanguage/Kexi/Handbook/References/Form Widgets|Form Widgets]]</translate>
<translate>
<!--T:72-->
<!-- Report Design related references -->
<!-- Report Design related references -->
:[[Special:MyLanguage/Kexi/Handbook/References/Report Elements|Report Elements]]
:[[Special:MyLanguage/Kexi/Handbook/References/Report Elements|Report Elements]]</translate>
<translate>
<!--T:73-->
<!-- Macro Design related references -->
<!-- Macro Design related references -->
<!-- UNIMPLEMENTED: :[[Special:MyLanguage/Kexi/Handbook/References/Macro Commands|Macro Commands]] -->
<!-- UNIMPLEMENTED: :[[Special:MyLanguage/Kexi/Handbook/References/Macro Commands|Macro Commands]] --></translate>
<translate>
<!--T:74-->
<!-- Script Design related references -->
<!-- Script Design related references -->
<!-- UNIMPLEMENTED: :[[Special:MyLanguage/Kexi/Handbook/References/Scripting Object Model|Scripting Object Model]] -->
<!-- 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/Plugins|Plugins]] -->
<!-- UNIMPLEMENTED: :[[Special:MyLanguage/Kexi/Handbook/References/Configuration Options|Configuration Options]] -->
<!-- UNIMPLEMENTED: :[[Special:MyLanguage/Kexi/Handbook/References/Configuration Options|Configuration Options]] --></translate>
:[[Special:MyLanguage/Kexi/Handbook/References/Command-Line Options|Command-Line Options]] <!-- Use 'kexi --help' -->
<translate>
:[[Special:MyLanguage/Kexi/Handbook/References/Supported File Formats|Supported File Formats]]
<!--T:76-->
::[[Special:MyLanguage/Kexi/Handbook/References/Supported File Formats/Microsoft Access File Formats|Microsoft Access File Formats]]
:[[Special:MyLanguage/Kexi/Handbook/References/Command-Line Options|Command-Line Options]] </translate>
::[[Special:MyLanguage/Kexi/Handbook/References/Supported File Formats/Comma-separated Values Format|Comma-separated Values Format (CSV)]]
<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]]
:[[Special:MyLanguage/Kexi/Handbook/References/Kexi Specifications|Kexi Specifications]]


Line 173: Line 203:
:[[Special:MyLanguage/Kexi/Handbook/Kexi and 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]]==
==[[Special:MyLanguage/Kexi/Handbook/Technical Support|Technical Support]]== <!--T:62-->


==[[Special:MyLanguage/Kexi/Handbook/Contributing to the Kexi Project|Contributing to the Kexi Project]]==  
==[[Special:MyLanguage/Kexi/Handbook/Contributing to the Kexi Project|Contributing to the Kexi Project]]== <!--T:63-->


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


==[[Special:MyLanguage/Kexi/Handbook/Bibliography|Bibliography]]==
==[[Special:MyLanguage/Kexi/Handbook/Bibliography|Bibliography]]== <!--T:65-->


==[[Special:MyLanguage/Kexi/Handbook/Index|Index]]==
==[[Special:MyLanguage/Kexi/Handbook/Index|Index]]== <!--T:66-->


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

Latest revision as of 13:21, 22 December 2024

Other languages:

← Back

Information

This is original Kexi handbook for Kexi 2.x. It is always the newest version. Based on it, a HTML version, and PDF version is auto-generated. Translation to other languages may be available (select your language on the left hand at [1]).
Please do not make any major change without coordinating with the maintainer, Jarosław Staniek, email: staniek @ kde.org.
Please follow rules from the Documentation Guide.


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 Menu
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=497634"