Kexi/Handbook/Kexi Basics/The Kexi Main Window: Difference between revisions

From KDE Wiki Sandbox
No edit summary
m (clarify terminology)
 
(13 intermediate revisions by 3 users not shown)
Line 14: Line 14:


<!--T:5-->
<!--T:5-->
Database objects (tables, queries, etc.) listed in the '''Project Navigator''' can be opened by clicking (or double-clicking, depending upon your global KDE settings) on their names.
Database objects (tables, queries, reports.) listed in the '''Project Navigator''' can be opened by double-clicking on their names.


====Main application elements==== <!--T:6-->
====Main Application Elements==== <!--T:6-->


<!--T:7-->
<!--T:7-->
Line 23: Line 23:
<!--T:8-->
<!--T:8-->
;Tabbed Toolbar  
;Tabbed Toolbar  
:Contains available commands for the application. You will find detailed description of any of the commands in [[Special:myLanguage/Kexi/Handbook/Command Reference|the appendix]].</translate>
:Contains available commands for the application. You will find a detailed description of any of the commands in [[Special:myLanguage/Kexi/Handbook/Command Reference|Appendix C]].</translate>
<translate><!--T:40-->
<translate><!--T:40-->
;Project Navigator pane
;Project Navigator pane
:Contains a list of any object (tables, queries, forms, ...) created within the currently opened database project. The navigator also contains small toolbar with most usable commands related to the database objects. </translate>
:Contains a list of any object (tables, queries, forms, ...) created within the currently opened database project. The navigator also contains a small toolbar with the most frequently used commands related to the database objects. </translate>
<translate>
<translate>
<!--T:41-->
<!--T:41-->
;Opened Database Objects Area / Tabbed Windows
;Opened Database Objects Area / Tabbed Windows
:A central area of the application taking most of the screen space. For IDEAl user interface mode it contains switchable tabs with windows that are always maximized. For Childframe user interface mode it contains floating windows. </translate>
:A central area of the application utilising most of the screen space. In IDEAl user interface mode it contains switchable tabs with windows that are always maximized. In Childframe user interface mode it contains floating windows. </translate>
<translate>
<translate>
<!--T:42-->
<!--T:42-->
;Property Editor pane
;Property Editor pane
:Contains a list of properties of currently activated database object. For certain objects (e.g. form's widgets) it can have several tabs.  
:Contains a list of properties of the currently selected database object. For certain objects (e.g. form widgets) it may have several tabs.


====Tabbed Toolbar==== <!--T:9-->
====Tabbed Toolbar==== <!--T:9-->
Line 55: Line 55:
* Import / Export Data
* Import / Export Data


Depending on the context, additional tabs can be visible:
<!--T:51-->
Depending on the context, additional tabs may be visible:


* '''Form Design''' tab is visible if the Form Designer is actually used.
<!--T:52-->
* '''Form Design''' tab is only visible if the Form Designer is actually in use.


* '''Report Design''' tab is visible if the Report Designer is actually used.
<!--T:53-->
* '''Report Design''' tab is only visible if the Report Designer is actually in use.


====Project Navigator pane==== <!--T:17-->
====Project Navigator Pane==== <!--T:17-->


<!--T:18-->
<!--T:18-->
Line 70: Line 73:


<!--T:20-->
<!--T:20-->
The Project Navigator pane also contains a small toolbar for most frequently used commands (from left to right): <menuchoice>Open</menuchoice> selected object, <menuchoice>Design</menuchoice> selected object, and <menuchoice>Delete</menuchoice> selected object.  
The Project Navigator pane also contains a small toolbar for the most frequently used commands (from left to right): <menuchoice>Open</menuchoice> selected object, <menuchoice>Design</menuchoice> selected object, and <menuchoice>Delete</menuchoice> selected object.  


<!--T:21-->
<!--T:21-->
Line 81: Line 84:
{{Note|Even though your operating system or window manager may be set up to handle single clicks instead of double clicks, '''Kexi''' uses double clicks in '''Project Navigator''' to avoid accidentally opening large datasets or executing queries.}}
{{Note|Even though your operating system or window manager may be set up to handle single clicks instead of double clicks, '''Kexi''' uses double clicks in '''Project Navigator''' to avoid accidentally opening large datasets or executing queries.}}


====Opened database objects area / Tabbed Windows==== <!--T:24-->
====Opened Database Objects Area / Tabbed Windows==== <!--T:24-->


<!--T:25-->
<!--T:25-->
Line 90: Line 93:


<!--T:27-->
<!--T:27-->
You can rearrange the tabs by drag and drop and close them using the {{Icon|tab-close}} button located at the far right of the tab strip.
You can rearrange the tabs by drag and drop, and close them using the {{Icon|tab-close}} button located on the right of each tab.


<!--T:28-->
<!--T:28-->
{{Note|Sometime later on there will be an option to detach tabs, creating somewhat something similar to an MDI interface. That could be useful for custom solutions or multiple displays.}}
{{Note|Sometime later on there will be an option to detach tabs, creating somewhat something similar to an MDI interface. That could be useful for custom solutions or multiple displays.}}


====Property Editor pane==== <!--T:29-->
====Property Editor Pane==== <!--T:29-->


<!--T:30-->
<!--T:30-->
Line 101: Line 104:


<!--T:31-->
<!--T:31-->
In the '''Property Editor''' pane you can change properties of the object displayed in the active window. Depending on the context, the pane is consisted of one or more tabs. The first, always visible tab, <menuchoice>Properties</menuchoice>, contains the list of available properties.  
In the '''Property Editor''' pane you can change properties of the object displayed in the active window. Depending on the context, the pane consists of one or more tabs. The first, always visible tab, <menuchoice>Properties</menuchoice>, contains the list of available properties.  


<!--T:32-->
<!--T:32-->
Line 116: Line 119:
<translate>
<translate>
<!--T:45-->
<!--T:45-->
** a number; you can enter the value directly or increase or decrease its value by clicking with the left mouse button on the arrows. </translate>
** a number; you can enter the value directly or increase or decrease its value by clicking with the left mouse button on the up/down arrows at the right of the value field. </translate>
<translate>
<translate>
<!--T:46-->
<!--T:46-->
Line 122: Line 125:
<translate>
<translate>
<!--T:47-->
<!--T:47-->
** drop down list of values</translate>
** a drop down list of values; click on the desired value to select</translate>
<translate>
<translate>
<!--T:48-->
<!--T:48-->
Line 135: Line 138:


<!--T:50-->
<!--T:50-->
* After changing the value of a property, a special <menuchoice>Undo changes</menuchoice> button appears on the right side of the Property Editor's list. By clicking it you can revert the value of the property to the original value that was loaded from the database upon opening the database object. The button is only visible when the property is actually highlighted.}}<!--{{-->
* After changing the value of a property, a special <menuchoice>Undo changes</menuchoice> button appears on the right side of the Property Name. By clicking it you can revert the value of the property to the original value that was loaded from the database upon opening the database object.}}<!--{{-->


<!--T:35-->
<!--T:35-->
The '''Property Editor''' pane is empty if:
The '''Property Editor''' pane is not visible if:


<!--T:36-->
<!--T:36-->
* no single database object's window is opened, or
* no single database object's window is open, or


<!--T:37-->
<!--T:37-->
* the active database object's window does not offer properties; it is usually the case when it is opened in '''Data View''' instead of '''Design View'''.
* the active database object's window does not offer properties as is the case when open in '''Data View''' instead of '''Design View'''.


<!--T:38-->
<!--T:38-->

Latest revision as of 18:11, 8 April 2015

Other languages:

The Kexi Main Window

The Tabbed Toolbar on the top gives access to common actions and commands.

The Project Navigator and Property Editor are shown in panes on each side of the child window. These can be resized or hidden as required. A pane can be hidden by clicking the small cross at the top of the pane (just below the toolbar).

Database objects (tables, queries, reports.) listed in the Project Navigator can be opened by double-clicking on their names.

Main Application Elements

Main elements of Kexi application's window are:

Tabbed Toolbar
Contains available commands for the application. You will find a detailed description of any of the commands in Appendix C.
Project Navigator pane
Contains a list of any object (tables, queries, forms, ...) created within the currently opened database project. The navigator also contains a small toolbar with the most frequently used commands related to the database objects.
Opened Database Objects Area / Tabbed Windows
A central area of the application utilising most of the screen space. In IDEAl user interface mode it contains switchable tabs with windows that are always maximized. In Childframe user interface mode it contains floating windows.
Property Editor pane
Contains a list of properties of the currently selected database object. For certain objects (e.g. form widgets) it may have several tabs.

Tabbed Toolbar

The toolbar is the place that gives you access to most Kexi commands and actions. Using the actions found in the different tabs on the toolbar you can:

  • Create / Open / Close Kexi projects
  • Create Database objects
  • Import / Export Data

Depending on the context, additional tabs may be visible:

  • Form Design tab is only visible if the Form Designer is actually in use.
  • Report Design tab is only visible if the Report Designer is actually in use.

Project Navigator Pane

The Project Navigator pane is one of the most frequently used elements of the Kexi main window. The pane contains a list of all objects created within the currently opened Kexi database project. The objects are split into groups: tables, queries, forms, reports and scripts.

The Project Navigator pane also contains a small toolbar for the most frequently used commands (from left to right): Open selected object, Design selected object, and Delete selected object.

For each object on the list a context menu is available using the right mouse button.

Double clicking with the left mouse button on the object's name on the list opens the object in Data View. If the object's window was already opened, the action just activates the window without switching it's view mode.

Note
Even though your operating system or window manager may be set up to handle single clicks instead of double clicks, Kexi uses double clicks in Project Navigator to avoid accidentally opening large datasets or executing queries.


Opened Database Objects Area / Tabbed Windows

Whenever you double click an object in the project navigator, it opens in the Opened database objects area. Each window has its own tab in Kexi.

You can rearrange the tabs by drag and drop, and close them using the button located on the right of each tab.

Note
Sometime later on there will be an option to detach tabs, creating somewhat something similar to an MDI interface. That could be useful for custom solutions or multiple displays.


Property Editor Pane

In the Property Editor pane you can change properties of the object displayed in the active window. Depending on the context, the pane consists of one or more tabs. The first, always visible tab, Properties, contains the list of available properties.

Rules for using the Property Editor:

  • Each row contains a single property.
  • You can use the mouse or the keyboard to change values of particular properties.
  • Most frequently used types of property values are:
    • a number; you can enter the value directly or increase or decrease its value by clicking with the left mouse button on the up/down arrows at the right of the value field.
    • text
    • a drop down list of values; click on the desired value to select
    • Yes/No; you can toggle the value by clicking on the button; Yes (true) means that the button is toggled on, No (false) means that the button is toggled off.
Note
* There is no need to confirm a changed value: changes are visible immediately after moving to a different row of the Property Editor's list or by pressing the Enter key.
  • Names of the recently changed properties that not yet were stored in the database are marked with bold text.
  • After changing the value of a property, a special Undo changes button appears on the right side of the Property Name. By clicking it you can revert the value of the property to the original value that was loaded from the database upon opening the database object.


The Property Editor pane is not visible if:

  • no single database object's window is open, or
  • the active database object's window does not offer properties as is the case when open in Data View instead of Design View.