Kexi/Handbook/Building Simple Databases: Difference between revisions
Marked this version for translation |
No edit summary |
||
| (9 intermediate revisions by 3 users not shown) | |||
| Line 4: | Line 4: | ||
<!--T:2--> | <!--T:2--> | ||
*[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases|Introduction]] | *[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases#Introduction|Introduction]] | ||
*[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Tables|Designing Database Tables]] | |||
**[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Tables/The Table Designer window|The Table Designer window]] | <!--T:10--> | ||
*[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Tables|Designing Database Tables]]</translate> | |||
<translate> | |||
<!--T:11--> | |||
**[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Tables/The Table Designer window|The Table Designer window]]</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]] | ||
*[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms|Designing Forms]] | |||
**[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Most important terms|Most important terms]] | <!--T:14--> | ||
**[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Forms versus tables|Forms versus tables]] | *[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms|Designing Forms]]</translate> | ||
**[[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/Using the Widgets tab|Using the Widgets tab]] | <!--T:15--> | ||
**[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Inserting widgets - text fields|Inserting widgets - text fields]] | **[[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/Assigning data sources|Assigning data sources]] | <translate> | ||
**[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Inserting text labels|Inserting text labels]] | <!--T:16--> | ||
**[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Actions|Actions]] | **[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Forms versus tables|Forms versus tables]]</translate> | ||
<translate> | |||
**[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Setting widgets size and position by hand|Setting widgets size and position by hand]] | <!--T:17--> | ||
**[[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/Working with form design|Working with form design]]</translate> | ||
<translate> | |||
<!--T:18--> | |||
**[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Using the Widgets tab|Using the Widgets tab]]</translate> | |||
<translate> | |||
<!--T:19--> | |||
**[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Inserting widgets - text fields|Inserting widgets - text fields]]</translate> | |||
<translate> | |||
<!--T:20--> | |||
**[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Assigning data sources|Assigning data sources]]</translate> | |||
<translate> | |||
<!--T:21--> | |||
**[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Inserting text labels|Inserting text labels]]</translate> | |||
<translate> | |||
<!--T:22--> | |||
**[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Actions|Actions]]</translate> | |||
<translate> | |||
<!--T:24--> | |||
<!--FIXME not implemented in kexi 2.4 | |||
**[[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> | |||
<!--T:25--> | |||
<!--FIXME not implemented in kexi 2.4 | |||
**[[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 26: | Line 59: | ||
<!--T:4--> | <!--T:4--> | ||
To learn the basics of ''' | To learn the basics of '''KEXI''' we will build a simple database utilizing most of the elementary features of '''KEXI'''. To make things simpler, advanced database design topics will not be covered here. | ||
<!--T:5--> | <!--T:5--> | ||
We start by creating a new empty Phone Book. | |||
<!--T:6--> | <!--T:6--> | ||
| Line 35: | Line 68: | ||
<!--T:7--> | <!--T:7--> | ||
# Design database tables. Read the section called [[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Tables|Designing Database Tables]]. | # Design database tables. Read the following section called [[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Tables|Designing Database 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> | ||
# Design database queries. Read the section called [[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Queries|Designing Database Queries]]. | <!--T:27--> | ||
# Design forms. Read the section called [[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms|Designing Forms]]. | # Enter data into tables. Read the following section called [[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Entering Data Into Tables|Entering Data Into Tables]].</translate> | ||
# Use forms to enter data. Read the section called [[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Entering Data Using Forms|Entering Data Using Forms]]. | <translate> | ||
<!--T:28--> | |||
# Design database queries. Read the following section called [[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Queries|Designing Database Queries]].</translate> | |||
<translate> | |||
<!--T:29--> | |||
# Design forms. Read the following section called [[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms|Designing Forms]].</translate> | |||
<translate> | |||
<!--T:30--> | |||
# Use forms to enter data. Read the following section called [[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Entering Data Using Forms|Entering Data Using Forms]]. | |||
<!--T:8--> | <!--T:8--> | ||
Latest revision as of 20:52, 25 December 2024
Building Simple Databases
Introduction
To learn the basics of KEXI we will build a simple database utilizing most of the elementary features of KEXI. To make things simpler, advanced database design topics will not be covered here.
We start by creating a new empty Phone Book.
Having a new empty database project, perform the following steps:
- Design database tables. Read the following section called Designing Database Tables.
- Enter data into tables. Read the following section called Entering Data Into Tables.
- Design database queries. Read the following section called Designing Database Queries.
- Design forms. Read the following section called Designing Forms.
- Use forms to enter data. Read the following section called Entering Data Using Forms.