Kexi/Handbook

From KDE UserBase Wiki
Revision as of 01:06, 30 November 2024 by Jstaniek (talk | contribs)

← Back

Information

{{{1}}}


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