Kexi/Handbook/Building Simple Databases/Entering Data Into Tables: Difference between revisions

From KDE Wiki Sandbox
(Formatting + minor clarification)
m (grammatical changes for readability)
 
Line 4: Line 4:


<!--T:2-->
<!--T:2-->
You have designed the two tables '''''Persons''''' and '''''Phones'''''. None of them contain any data yet. You can enter some, and in this chapter you will learn how to do this fast and effectively.  
You have designed the two tables '''''Persons''''' and '''''Phones'''''. Neither of them contain any data yet. You need to enter some, and in this chapter you will learn how to do this fast and effectively.  


<!--T:3-->
<!--T:3-->
Start with the '''''Persons''''' table. Open it in Data View using <menuchoice>Open</menuchoice>  in the '''Project Navigator's''' context menu or the toolbar button. The current cell is marked with (usually black) thicker border, a cell cursor. The contents of the cell, if present, are highlighted with a different color. The current row, i.e. the one you have placed your rectangular cursor in, is marked on the left hand with an arrow symbol.  
Start with the '''''Persons''''' table. Open it in Data View using <menuchoice>Open</menuchoice>  in the '''Project Navigator's''' context menu or the toolbar button. The current cell is marked with a thicker border (usually black) , & a cell cursor. The contents of the cell, if present, are highlighted with a different color. The current row, i.e. the one you have placed your cursor in, is marked on the left hand with an arrow symbol and is highlighted with a darker colour.


<!--T:4-->
<!--T:4-->
You can navigate through table cells using the arrow keys, <keycap>Page Down</keycap>, <keycap>Page Down</keycap>, <keycap>Home</keycap>, <keycap>End</keycap> keys; you can also click with the mouse in a cell to select it.  
You can navigate through table cells using the arrow keys, <keycap>Page Down</keycap>, <keycap>Page Down</keycap>, <keycap>Home</keycap>, <keycap>End</keycap> and <keycap>Tab</keycap>keys; you can also click with the mouse in a cell to select it.  


<!--T:5-->
<!--T:5-->
Initially, after opening the table '''''Persons''''', the cursor is placed in the '''''Id''''' column. The column has autonumber property defined, marked with blue (autonumber) text in the last row. It means you do not have to enter values there by hand when entering data for a new row because the cell will be filled automatically with successive numbers.  
Initially, after opening the table '''''Persons''''', the cursor is placed in the '''''Id''''' column. The column has the autonumber property defined and is marked with blue (auto) text in the last row. It means you do not have to enter values there by hand when entering data for a new row because the cell will be filled automatically with sequential numbers.  


<!--T:6-->
<!--T:6-->
Inserting new rows and entering data for them in '''Kexi''' is different from the way of doing this in spreadsheets. To enter data for a new row, you need to use the arrow keys or mouse, to move your cursor to the special empty last row marked with a plus sign. Place your cursor in the (second) '''''name''''' column and enter a person's name. Also enter surname, street, house number and city. When done, move the cell cursor to the last empty row either by using the <keycap>Down</keycap> key or by clicking in the last row with the mouse to append a new row.  
Inserting new rows and entering data for them in '''Kexi''' is different from the way of doing this in spreadsheets. To enter data for a new row, you need to use the arrow keys or mouse, to move your cursor to the special empty last row marked with a plus sign. Place your cursor in the (second) '''''name''''' column and enter a person's name. Also enter surname, street, house number and city. When done, move the cell cursor to the last empty row either by using the <keycap>Down</keycap> key or by clicking in the last row with the mouse to append a new row. The <keycap>Page Down</keycap> key will also move you to a new row.


====Details About Actions Available While Entering Data Into Tables==== <!--T:7-->
====Details About Actions Available While Entering Data Into Tables==== <!--T:7-->
Line 24: Line 24:


<!--T:9-->
<!--T:9-->
* Double clicking a cell with the left mouse button or pressing <keycap>Enter</keycap> or the <keycap>F2</keycap> key also starts editing of the current row.  
* Double clicking a cell with the left mouse button or pressing <keycap>Enter</keycap> or the <keycap>F2</keycap> key also enters edit mode in the current row.  


<!--T:10-->
<!--T:10-->
* Pressing the <keycap>Esc</keycap> key when the contents of a cell is edited cancels changes made to this cell. However, the pencil symbol will not disappear because you can still move to a different cell of the edited row to change its contents. To cancel changes made to the entire edited row, press the <keycap>Esc</keycap> key again. <!--FIXME Esc does not work in master (2.4) as described here bug in docs or app?-->
* Pressing the <keycap>Esc</keycap> key when the contents of a cell is edited cancels changes made to this cell. However, the pencil symbol will not disappear and you can still move to a different cell in the row to edit its contents. To cancel changes made to the entire edited row, press the <keycap>Esc</keycap> key again (or twice if you have not yet pressed it once). <!--FIXME Esc does not work in master (2.4) as described here bug in docs or app?-->


<!--T:11-->
<!--T:11-->
* Instead of pressing the <keycap>Esc</keycap> key, you can click the <menuchoice>Cancel Record Changes</menuchoice> toolbar button.  
* Instead of pressing the <keycap>Esc</keycap> key twice you can click the <menuchoice>Cancel Record Changes</menuchoice> toolbar button.  


<!--T:12-->
<!--T:12-->
* Press the <keycap>Shift + Enter</keycap> keys to accept changes made to all cells in the currently edited row.  
* Press the <keycap>Shift + Enter</keycap> keys to accept changes made to all cells in the currently edited row. The pencil symbol will change to the arrow symbol. Moving of a row, either up or down, will also cause all edits to be accepted.


<!--T:13-->
<!--T:13-->
Fill the '''''Phones''''' table with data. In the '''''person''''' column you need to provide an '''''Id''''' number of the person existing in the '''''Persons''''' table.
Fill the '''''Phones''''' table with data. In the '''''person''''' column you need to provide the '''''Id''''' number of the person existing in the '''''Persons''''' table for that record.


<!--T:14-->
<!--T:14-->

Latest revision as of 17:53, 7 May 2015

Other languages:

Entering Data Into Tables

You have designed the two tables Persons and Phones. Neither of them contain any data yet. You need to enter some, and in this chapter you will learn how to do this fast and effectively.

Start with the Persons table. Open it in Data View using Open in the Project Navigator's context menu or the toolbar button. The current cell is marked with a thicker border (usually black) , & a cell cursor. The contents of the cell, if present, are highlighted with a different color. The current row, i.e. the one you have placed your cursor in, is marked on the left hand with an arrow symbol and is highlighted with a darker colour.

You can navigate through table cells using the arrow keys, Page Down, Page Down, Home, End and Tabkeys; you can also click with the mouse in a cell to select it.

Initially, after opening the table Persons, the cursor is placed in the Id column. The column has the autonumber property defined and is marked with blue (auto) text in the last row. It means you do not have to enter values there by hand when entering data for a new row because the cell will be filled automatically with sequential numbers.

Inserting new rows and entering data for them in Kexi is different from the way of doing this in spreadsheets. To enter data for a new row, you need to use the arrow keys or mouse, to move your cursor to the special empty last row marked with a plus sign. Place your cursor in the (second) name column and enter a person's name. Also enter surname, street, house number and city. When done, move the cell cursor to the last empty row either by using the Down key or by clicking in the last row with the mouse to append a new row. The Page Down key will also move you to a new row.

Details About Actions Available While Entering Data Into Tables

  • As soon as you enter the first character, the current row is being edited. A pencil symbol appears on the left side of the data table.
  • Double clicking a cell with the left mouse button or pressing Enter or the F2 key also enters edit mode in the current row.
  • Pressing the Esc key when the contents of a cell is edited cancels changes made to this cell. However, the pencil symbol will not disappear and you can still move to a different cell in the row to edit its contents. To cancel changes made to the entire edited row, press the Esc key again (or twice if you have not yet pressed it once).
  • Instead of pressing the Esc key twice you can click the Cancel Record Changes toolbar button.
  • Press the Shift + Enter keys to accept changes made to all cells in the currently edited row. The pencil symbol will change to the arrow symbol. Moving of a row, either up or down, will also cause all edits to be accepted.

Fill the Phones table with data. In the person column you need to provide the Id number of the person existing in the Persons table for that record.