Kexi/Handbook/Building Simple Databases: Difference between revisions
Appearance
Splitting lists into smaller units |
Marked this version for translation |
||
Line 6: | Line 6: | ||
*[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases|Introduction]] | *[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases|Introduction]] | ||
<!--T:10--> | |||
*[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Tables|Designing Database Tables]]</translate> | *[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Tables|Designing Database Tables]]</translate> | ||
<translate> | <translate> | ||
<!--T:11--> | |||
**[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Tables/The Table Designer window|The Table Designer window]]</translate> | **[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Tables/The Table Designer window|The Table Designer window]]</translate> | ||
<translate> | <translate> | ||
<!--T:12--> | |||
*[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Entering Data Into Tables|Entering Data Into Tables]] | *[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Entering Data Into Tables|Entering Data Into Tables]] | ||
<!--T:13--> | |||
*[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Queries|Designing Database Queries]] | *[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Queries|Designing Database Queries]] | ||
<!--T:14--> | |||
*[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms|Designing Forms]]</translate> | *[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms|Designing Forms]]</translate> | ||
<translate> | <translate> | ||
<!--T:15--> | |||
**[[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/Most important terms|Most important terms]]</translate> | ||
<translate> | <translate> | ||
<!--T:16--> | |||
**[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Forms versus tables|Forms versus tables]]</translate> | **[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Forms versus tables|Forms versus tables]]</translate> | ||
<translate> | <translate> | ||
<!--T:17--> | |||
**[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Working with form design|Working with form design]]</translate> | **[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Working with form design|Working with form design]]</translate> | ||
<translate> | <translate> | ||
<!--T:18--> | |||
**[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Using the Widgets tab|Using the Widgets tab]]</translate> | **[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Using the Widgets tab|Using the Widgets tab]]</translate> | ||
<translate> | <translate> | ||
<!--T:19--> | |||
**[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Inserting widgets - text fields|Inserting widgets - text fields]]</translate> | **[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Inserting widgets - text fields|Inserting widgets - text fields]]</translate> | ||
<translate> | <translate> | ||
<!--T:20--> | |||
**[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Assigning data sources|Assigning data sources]]</translate> | **[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Assigning data sources|Assigning data sources]]</translate> | ||
<translate> | <translate> | ||
<!--T:21--> | |||
**[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Inserting text labels|Inserting text labels]]</translate> | **[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Inserting text labels|Inserting text labels]]</translate> | ||
<translate> | <translate> | ||
<!--T:22--> | |||
**[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Actions|Actions]]</translate> | **[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Actions|Actions]]</translate> | ||
<translate> | <translate> | ||
<!--T:23--> | |||
**[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Widget layouts|Widget layouts]]</translate> | **[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Widget layouts|Widget layouts]]</translate> | ||
<translate> | <translate> | ||
<!--T:24--> | |||
**[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Setting widgets size and position by hand|Setting widgets size and position by hand]]</translate> | **[[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> | <translate> | ||
<!--T:25--> | |||
**[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Setting the tab order|Setting the tab order]] | **[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Setting the tab order|Setting the tab order]] | ||
<!--T:26--> | |||
*[[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]] | ||
Line 54: | Line 71: | ||
# Design database tables. Read the section called [[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Tables|Designing Database Tables]].</translate> | # Design database tables. Read the section called [[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Tables|Designing Database Tables]].</translate> | ||
<translate> | <translate> | ||
<!--T:27--> | |||
# Enter data into tables. Read the section called [[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Entering Data Into Tables|Entering Data Into Tables]].</translate> | # Enter data into tables. Read the section called [[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Entering Data Into Tables|Entering Data Into Tables]].</translate> | ||
<translate> | <translate> | ||
<!--T:28--> | |||
# Design database queries. Read the section called [[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Queries|Designing Database Queries]].</translate> | # Design database queries. Read the section called [[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Queries|Designing Database Queries]].</translate> | ||
<translate> | <translate> | ||
<!--T:29--> | |||
# Design forms. Read the section called [[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms|Designing Forms]].</translate> | # Design forms. Read the section called [[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms|Designing Forms]].</translate> | ||
<translate> | <translate> | ||
<!--T:30--> | |||
# Use forms to enter data. Read the section called [[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Entering Data Using Forms|Entering Data Using Forms]]. | # Use forms to enter data. Read the section called [[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Entering Data Using Forms|Entering Data Using Forms]]. | ||
Revision as of 12:01, 18 December 2011
Building Simple Databases
Introduction
To learn the basics of Kexi, you could build a simple database utilizing most elementary Kexi's features. To make things simpler, advanced database design topics will not be covered here.
Start by creating a new empty Phone Book.
Having a new empty database project, perform the following steps:
- Design database tables. Read the section called Designing Database Tables.
- Enter data into tables. Read the section called Entering Data Into Tables.
- Design database queries. Read the section called Designing Database Queries.
- Design forms. Read the section called Designing Forms.
- Use forms to enter data. Read the section called Entering Data Using Forms.