Sophie

Sophie

distrib > Fedora > 13 > x86_64 > media > updates > by-pkgid > f32c3b729134a3865493af7ddc10fe5c > files > 32

koffice-kexi-2.3.2-3.fc13.x86_64.rpm

<!--
  <!DOCTYPE chapter PUBLIC "-//KDE//DTD DocBook XML V4.2-Based Variant V1.1//EN" "dtd/kdex.dtd" >

 -->

  <sect1 id="entering-data-into-tables">
    <title>Entering Data Into Tables</title>
    <para>
      You have designed the two tables <literal>Persons</literal> and
      <literal>phone_numbers</literal>. 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.
    </para>
    <procedure>
      <step>
        <para>
          Start with the <literal>persons</literal> table. Open it in <interface>Data View</interface> using the <!--<a href="04_06_01_project_navigator.html">--><interface>Project Navigator</interface>'s context menu.
          The current cell is marked with
          (usually black) thicker border, a <firstterm>cell cursor</firstterm>. 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.
          <!--<img src="icons/button_tableview_currentrow.png" class="icon">-->
        </para>
        <para>
          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. <!-- TODO chapter moved 
          To learn more
          about available key bindings for the data table view, see the section
          <a href="ab_00_00_shortcuts.html#data_table">
          B.4. Data Table in the Appendix B. Key Bindings. -->
        </para>
        <para>
          Initially, after opening the table <literal>Persons</literal>, the cursor is placed in
          the <literal>id</literal> column. The column has autonumber property defined,
          marked with blue <literal>(autonumber)</literal> 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.
        </para>
        <!--<screenshot>
          <screeninfo>Data entry</screeninfo>
          <mediaobject>
            <imageobject>
              <imagedata fileref="img/05_02_00_data_editing.png" format="PNG"/>
            </imageobject>
            <textobject>
              <phrase>Data entry</phrase>
            </textobject>
          </mediaobject>
        </screenshot>-->
      </step>
      <step>
        <para>
          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 <!--<img src="icons/button_tableview_newrow.png" class="icon">-->
          sign. Place your cursor in the (second) <literal>name</literal> 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>Arrow Down</keycap> key or by clicking in the last 
   row with the mouse to append a new row. 
        </para>
        <note>
          <title>Details About Actions Available While Entering Data Into Tables</title>
          <itemizedlist>
            <listitem>
              <para>
                As soon as you enter the first character, the current row is being edited. A pencil <!--<img src="icons/button_tableview_editrow.png" class="icon">--> symbol appears on the left side of the data table.
              </para>
            </listitem>
            <listitem>
              <para>
                Double clicking a cell with the &LMB; or pressing &Enter; or the <keycap>F2</keycap> key also starts
                editing of the current row.
              </para>
            </listitem>
            <listitem>
              <para>
                Pressing the &Esc; key when the contents of a cell is edited 
                <emphasis>cancels changes made to this cell</emphasis>. However, the pencil
                <!--<img src="icons/button_tableview_editrow.png" class="icon">-->
                symbol will not disappear because you can still move to a different cell
                of the edited row to change its contents. To
                <emphasis>cancel changes made to the entire edited row</emphasis>, press the
                &Esc; key again.
              </para>
            </listitem>
            <listitem>
              <para>
                Instead of pressing the &Esc; key, you can click the
                <!--<img src="icons/button_cancel.png" class="icon">--><guibutton>Cancel</guibutton>
                toolbar button or select
                <menuchoice><guimenu>Data</guimenu><guimenuitem>Cancel Row Changes</guimenuitem></menuchoice>
                from the menubar.
              </para>
            </listitem>
            <listitem>
              <para>
                Click the <keycombo action="simul">&Shift;&Enter;</keycombo>
                keys to accept changes made to all cells in the currently edited row. You can also click
                <!--<img src="icons/button_ok.png" class="icon">--><guibutton>OK</guibutton> toolbar
                button or select <menuchoice><guimenu>Data</guimenu><guimenuitem>Save Row</guimenuitem></menuchoice>
                from the menubar.
              </para>
            </listitem>
          </itemizedlist>
        </note>
      </step>
      <step>
        <para>
          Fill the <literal>phone_numbers</literal> table with data.<!--, e.g. similar to
          provided in the figure below.--> In the <literal>persons</literal> column you
          need to provide a number of the person existing in the <literal>persons</literal>
          table.
        </para>
        <!--<screenshot>
          <screeninfo>Example contents of the <literal>phone_numbers</literal> table</screeninfo>
          <mediaobject>
            <imageobject>
              <imagedata fileref="img/05_01_01_table2_contents.png" format="PNG"/>
            </imageobject>
            <textobject>
              <phrase>Example contents of the <literal>phone_numbers</literal> table</phrase>
            </textobject>
          </mediaobject>
        </screenshot>-->
      </step>
    </procedure>
  </sect1>