Kexi/Handbook/Building Simple Databases: Difference between revisions
Appearance
m add formatting |
No edit summary |
||
(13 intermediate revisions by 5 users not shown) | |||
Line 1: | Line 1: | ||
<languages/> | <languages/> | ||
<translate> | <translate> | ||
== | ==Building Simple Databases== <!--T:1--> | ||
<!--T:2--> | |||
*[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases#Introduction|Introduction]] | |||
<!--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]] | |||
<!--T:13--> | |||
*[[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> | |||
<translate> | |||
<!--T:15--> | |||
**[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Most important terms|Most important terms]]</translate> | |||
<translate> | |||
<!--T:16--> | |||
**[[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Forms/Forms versus tables|Forms versus tables]]</translate> | |||
<translate> | |||
<!--T:17--> | |||
**[[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]] | |||
===Introduction=== <!--T:3--> | |||
<!--T:4--> | |||
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--> | |||
We start by creating a new empty Phone Book. | |||
<!--T:6--> | |||
Having a new empty database project, perform the following steps: | Having a new empty database project, perform the following steps: | ||
# Design database tables. Read the section called | <!--T:7--> | ||
# Enter data into tables. Read the section called | # Design database tables. Read the following section called [[Special:MyLanguage/Kexi/Handbook/Building Simple Databases/Designing Database Tables|Designing Database Tables]].</translate> | ||
# Design database queries. Read the section called | <translate> | ||
# Design forms. Read the section called | <!--T:27--> | ||
# Use forms to enter data. Read the section called | # 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> | ||
<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--> | |||
{{Prevnext2 | |||
|prevpage=Special:MyLanguage/Kexi/Handbook/Kexi_Basics/Using_built-in_help | |||
|prevtext=Using built-in help | |||
|nextpage=Special:MyLanguage/Kexi/Handbook/Building_Simple_Databases/Designing_Database_Tables | |||
|nexttext=Designing Database Tables | |||
|index=Special:MyLanguage/Kexi/Handbook|indextext=Back to menu | |||
}} | |||
<!--T:9--> | |||
[[Category:Kexi]] | [[Category:Kexi]] | ||
[[Category:Tutorials]] | [[Category:Tutorials]] | ||
</translate> | </translate> |
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.