Jump to content

Kexi/Handbook: Difference between revisions

From KDE UserBase Wiki
Jstaniek (talk | contribs)
No edit summary
Claus chr (talk | contribs)
Marked this version for translation
 
(One intermediate revision by one other user not shown)
Line 5: Line 5:


<!--T:2-->
<!--T:2-->
{{Info|'''This is a handbook for KEXI 3.3, work in progress based on version 2.4. 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/>
{{Info|'''This is a handbook for KEXI 3.3, work in progress based on version 2.4. 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 generated (note: outdated for now). 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/>
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].}}
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 28: Line 28:
:[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/Opening an Existing KEXI Project|Opening an Existing KEXI Project]]</translate>
:[[Special:MyLanguage/Kexi/Handbook/Kexi Basics/Opening an Existing KEXI Project|Opening an Existing KEXI Project]]</translate>
<translate>
<translate>
<!--T:81-->
::[[Special:MyLanguage/Kexi/Handbook/Kexi_Basics/Opening an Existing KEXI Project/Opening Recent Project from Welcome Screen|Opening Recent Project from Welcome Screen]]</translate>
::[[Special:MyLanguage/Kexi/Handbook/Kexi_Basics/Opening an Existing KEXI Project/Opening Recent Project from Welcome Screen|Opening Recent Project from Welcome Screen]]</translate>
<translate>
<translate>
Line 101: Line 102:
==[[Special:MyLanguage/Kexi/Handbook/Configuring Kexi|Configuring Kexi]]== <!--T:8-->
==[[Special:MyLanguage/Kexi/Handbook/Configuring Kexi|Configuring Kexi]]== <!--T:8-->


<!--T:82-->
<!-- 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]]-->
<!-- UNIMPLEMENTED::[[Special:MyLanguage/Kexi/Handbook/Configuring Kexi/Docking and undocking side panels|Docking and undocking side panels]]-->
<!-- UNIMPLEMENTED::[[Special:MyLanguage/Kexi/Handbook/Configuring Kexi/Docking and undocking side panels|Docking and undocking side panels]]-->
Line 133: Line 135:
::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The KEXI Menu|The KEXI Menu]]</translate>
::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The KEXI Menu|The KEXI Menu]]</translate>
<translate>
<translate>
<!--T:83-->
::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The File Menu|The File Menu]]</translate>
::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The File Menu|The File Menu]]</translate>
<translate>
<translate>
<!--T:84-->
::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The Edit Menu|The Edit Menu]]</translate>
::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The Edit Menu|The Edit Menu]]</translate>
<translate>
<translate>
<!--T:85-->
::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The Data Menu|The Data Menu]]</translate>
::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The Data Menu|The Data Menu]]</translate>
<translate>
<translate>
<!--T:86-->
::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The Tools Menu|The Tools Menu]]</translate>
::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The Tools Menu|The Tools Menu]]</translate>
<translate>
<translate>
<!--T:87-->
::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The Settings Menu|The Settings Menu]]</translate>
::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The Settings Menu|The Settings Menu]]</translate>
<translate>
<translate>
<!--T:88-->
::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The Window Menu|The Window Menu]]</translate>
::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The Window Menu|The Window Menu]]</translate>
<translate>
<translate>
<!--T:89-->
::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The Help Menu|The Help Menu]]</translate>
::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/The Help Menu|The Help Menu]]</translate>
<translate>
<translate>
<!--T:90-->
::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/Context Menus in the Project Navigator|Context Menus in the Project Navigator]]</translate>
::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/Context Menus in the Project Navigator|Context Menus in the Project Navigator]]</translate>
<translate>
<translate>
<!--T:91-->
::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/Context Menu in the Object Tab|Context Menu in the Object Tab]]</translate>
::[[Special:MyLanguage/Kexi/Handbook/References/Menu Commands/Context Menu in the Object Tab|Context Menu in the Object Tab]]</translate>
<translate>
<translate>
<!--T:92-->
:[[Special:MyLanguage/Kexi/Handbook/References/Toolbar Commands|Toolbar Commands]]</translate>
:[[Special:MyLanguage/Kexi/Handbook/References/Toolbar Commands|Toolbar Commands]]</translate>
<translate>
<translate>


<!--T:93-->
::[[Special:MyLanguage/Kexi/Handbook/References/Toolbar Commands/The Create Toolbar|The Create Toolbar]]</translate>
::[[Special:MyLanguage/Kexi/Handbook/References/Toolbar Commands/The Create Toolbar|The Create Toolbar]]</translate>
<translate>
<translate>


<!--T:94-->
::[[Special:MyLanguage/Kexi/Handbook/References/Toolbar Commands/The Form Design Toolbar|The Form Design Toolbar]]</translate>
::[[Special:MyLanguage/Kexi/Handbook/References/Toolbar Commands/The Form Design Toolbar|The Form Design Toolbar]]</translate>
<translate>
<translate>


<!--T:95-->
::[[Special:MyLanguage/Kexi/Handbook/References/Toolbar Commands/The Report Design Toolbar|The Report Design Toolbar]]</translate>
::[[Special:MyLanguage/Kexi/Handbook/References/Toolbar Commands/The Report Design Toolbar|The Report Design Toolbar]]</translate>



Latest revision as of 16:13, 26 December 2024

← Back

Information

This is a handbook for KEXI 3.3, work in progress based on version 2.4. It is always the newest version. Based on it, a HTML version, and PDF version is generated (note: outdated for now). 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 Project
Opening Recent Project from Welcome Screen
Selecting a Project from the Open Project Screen
Opening an Existing KEXI Project by Clicking on a .kexi File
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
Entering Data Using Forms
Designing Reports

Configuring Kexi

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 File Menu
The Edit Menu
The Data Menu
The Tools Menu
The Settings Menu
The Window Menu
The Help Menu
Context Menus in the Project Navigator
Context Menu in the Object Tab
Toolbar Commands
The Create Toolbar
The Form Design Toolbar
The Report Design Toolbar
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