| Offset 1, 8 lines modified | Offset 1, 8 lines modified |
| 1 | <FILENAME·filename="index.html"><html><head><title>Handbok·Kexi</title><link·rel="stylesheet"·type="text/css"·href="help:/common/kde-default.css"><link·rel="stylesheet"·type="text/css"·href="help:/common/kde-docs.css"><link·rel="stylesheet"·type="text/css"·href="help:/common/kde-localised.css"><meta·name="generator"·content="DocBook·XSL·Stylesheets·V1.76.1"><meta·name="description"·content="Kexi·är·programmet·för·att·skapa·databaser·och·för·datahantering·i·Calligra·produktivitetssvit."><meta·name="keywords"·content="KDE,·Calligra,·Kexi,·databas"><link·rel="home"·href="index.html"·title="Handbok·Kexi"><link·rel="next"·href="introduction.html"·title="Kapitel·1.·Inledning"><meta·http-equiv="Content-Type"·content="text/html;·charset=utf-8"><meta·name="GENERATOR"·content="KDE·XSL·Stylesheet·V1.14·using·libxslt"></head><body·bgcolor="white"·text="black"·link="#0000FF"·vlink="#840084"·alink="#0000FF"><div·id="content"><div·id="header"><div·id="header_content"><div·id="header_left"><div·id="header_right"><img·src="he·✂ | 1 | <FILENAME·filename="index.html"><html><head><title>Handbok·Kexi</title><link·rel="stylesheet"·type="text/css"·href="help:/common/kde-default.css"><link·rel="stylesheet"·type="text/css"·href="help:/common/kde-docs.css"><link·rel="stylesheet"·type="text/css"·href="help:/common/kde-localised.css"><meta·name="generator"·content="DocBook·XSL·Stylesheets·V1.76.1"><meta·name="description"·content="Kexi·är·programmet·för·att·skapa·databaser·och·för·datahantering·i·Calligra·produktivitetssvit."><meta·name="keywords"·content="KDE,·Calligra,·Kexi,·databas"><link·rel="home"·href="index.html"·title="Handbok·Kexi"><link·rel="next"·href="introduction.html"·title="Kapitel·1.·Inledning"><meta·http-equiv="Content-Type"·content="text/html;·charset=utf-8"><meta·name="GENERATOR"·content="KDE·XSL·Stylesheet·V1.14·using·libxslt"></head><body·bgcolor="white"·text="black"·link="#0000FF"·vlink="#840084"·alink="#0000FF"><div·id="content"><div·id="header"><div·id="header_content"><div·id="header_left"><div·id="header_right"><img·src="he·✂ |
| 2 | </p></div></div><div·id="footer"><div·class="navCenter"><table·class="navigation"><tr><td·class="prevCell"><a·accesskey="p"·href="index.html">Föregående</a></td><td·class="upCell"><a·accesskey="h"·href="index.html">Hem</a></td><td·class="nextCell"><a·accesskey="n"·href="kexi-basics.html">Nästa</a></td></tr><tr><td·class="prevCell">Handbok·<span·class="application">Kexi</span> </td><td·class="upCell"> </td><td·class="nextCell"> Grunderna·i·Kexi</td></tr></table></div><div·id="footer_text">Vill·du·ge·en·kommentar·eller·bidra·med·en·uppdatering·av·den·här·sidan?<br>Skicka·dina·förslag·till·<a·href="mailto:kde-doc-english@kde.org"·class="footer_email">KDE:s·dokumentationsgrupp</a></div></div></div></body></html></FILENAME><FILENAME·filename="kexi-basics.html"><html><head><title>Kapitel·2.·Grunderna·i·Kexi</title><link·rel="stylesheet"·type="text/css"·href="help:/common/kde-default.css"><link·rel="stylesheet"·type="text/css"·href="help:/common/kde-docs.css"><link·rel="stylesheet"·type="text/css"·href="help:/common·✂ | 2 | </p></div></div><div·id="footer"><div·class="navCenter"><table·class="navigation"><tr><td·class="prevCell"><a·accesskey="p"·href="index.html">Föregående</a></td><td·class="upCell"><a·accesskey="h"·href="index.html">Hem</a></td><td·class="nextCell"><a·accesskey="n"·href="kexi-basics.html">Nästa</a></td></tr><tr><td·class="prevCell">Handbok·<span·class="application">Kexi</span> </td><td·class="upCell"> </td><td·class="nextCell"> Grunderna·i·Kexi</td></tr></table></div><div·id="footer_text">Vill·du·ge·en·kommentar·eller·bidra·med·en·uppdatering·av·den·här·sidan?<br>Skicka·dina·förslag·till·<a·href="mailto:kde-doc-english@kde.org"·class="footer_email">KDE:s·dokumentationsgrupp</a></div></div></div></body></html></FILENAME><FILENAME·filename="kexi-basics.html"><html><head><title>Kapitel·2.·Grunderna·i·Kexi</title><link·rel="stylesheet"·type="text/css"·href="help:/common/kde-default.css"><link·rel="stylesheet"·type="text/css"·href="help:/common/kde-docs.css"><link·rel="stylesheet"·type="text/css"·href="help:/common·✂ |
| 3 | </p></li><li·class="listitem"><p><a·class="link"·href="opening-an-existing-kexi-database-file.html"·title="Öppna·en·befintlig·Kexi·databasfil">Öppna·en·befintlig·Kexi·databasfil</a> </p><div·class="itemizedlist"><ul·class="itemizedlist"·type="circle"><li·class="listitem"><p><a·class="link"·href="opening-an-existing-kexi-database-file.html#opening-a-database-file-in-the-open-existing-project-dialog"·title="Öppna·en·databasfil·i·dialogrutan·Öppna·projekt">Öppna·en·databasfil·i·dialogrutan·Öppna·befintligt·projekt</a> </p></li><li·class="listitem"><p><a·class="link"·href="opening-an-existing-kexi-database-file.html#opening-an-existing-kexi-database-file-by-clicking-on--kexi-files-icon"·title="Öppna·en·befintlig·Kexi·databasfil·genom·att·klicka·på·.kexi-filens·ikon">Öppna·en·befintlig·Kexi·databasfil·genom·att·klicka·på·.kexi-filens·ikon</a> </p></li></ul></div><p> | 3 | </p></li><li·class="listitem"><p><a·class="link"·href="opening-an-existing-kexi-database-file.html"·title="Öppna·en·befintlig·Kexi·databasfil">Öppna·en·befintlig·Kexi·databasfil</a> </p><div·class="itemizedlist"><ul·class="itemizedlist"·type="circle"><li·class="listitem"><p><a·class="link"·href="opening-an-existing-kexi-database-file.html#opening-a-database-file-in-the-open-existing-project-dialog"·title="Öppna·en·databasfil·i·dialogrutan·Öppna·projekt">Öppna·en·databasfil·i·dialogrutan·Öppna·befintligt·projekt</a> </p></li><li·class="listitem"><p><a·class="link"·href="opening-an-existing-kexi-database-file.html#opening-an-existing-kexi-database-file-by-clicking-on--kexi-files-icon"·title="Öppna·en·befintlig·Kexi·databasfil·genom·att·klicka·på·.kexi-filens·ikon">Öppna·en·befintlig·Kexi·databasfil·genom·att·klicka·på·.kexi-filens·ikon</a> </p></li></ul></div><p> |
| 4 | </p></li><li·class="listitem"><p><a·class="link"·href="using-built-in-help.html"·title="Använda·inbyggd·hjälp">Använda·inbyggd·hjälp</a> </p></li></ul></div><div·class="sect1"><div·class="titlepage"><div><div><h2·class="title"·style="clear:·both"><a·name="kexi-databases"></a>Databaser·i·Kexi</h2></div></div></div><p>Många·program·som·<span·class="trademark">OpenOffice.org</span>®,·<span·class="trademark">LibreOffice</span>®·eller·<span·class="application"><span·class="trademark">Microsoft</span>®·Excel</span>·skapar·filer·som·kallas·dokument.·<span·class="application">Kexi</span>·skapar·också·filer,·men·här·kallar·vi·dem·<span·class="application">Kexi</span>·databasfiler,·eller·helt·enkelt·databasfiler.·</p><p>Förutom·att·lagra·dina·databaser·i·databasfiler,·kan·<span·class="application">Kexi</span>·också·använda·databaser·på·en·databasserver,·vilket·är·orsaken·till·att·vi·kallar·dem·databasfiler,·och·inte·helt·enkelt·databaser.·</p><p>Termen·<span·class="application">Kexi</span>·projekt,·eller·helt·enkelt·pr·✂ | 4 | </p></li><li·class="listitem"><p><a·class="link"·href="using-built-in-help.html"·title="Använda·inbyggd·hjälp">Använda·inbyggd·hjälp</a> </p></li></ul></div><div·class="sect1"><div·class="titlepage"><div><div><h2·class="title"·style="clear:·both"><a·name="kexi-databases"></a>Databaser·i·Kexi</h2></div></div></div><p>Många·program·som·<span·class="trademark">OpenOffice.org</span>®,·<span·class="trademark">LibreOffice</span>®·eller·<span·class="application"><span·class="trademark">Microsoft</span>®·Excel</span>·skapar·filer·som·kallas·dokument.·<span·class="application">Kexi</span>·skapar·också·filer,·men·här·kallar·vi·dem·<span·class="application">Kexi</span>·databasfiler,·eller·helt·enkelt·databasfiler.·</p><p>Förutom·att·lagra·dina·databaser·i·databasfiler,·kan·<span·class="application">Kexi</span>·också·använda·databaser·på·en·databasserver,·vilket·är·orsaken·till·att·vi·kallar·dem·databasfiler,·och·inte·helt·enkelt·databaser.·</p><p>Termen·<span·class="application">Kexi</span>·projekt,·eller·helt·enkelt·pr·✂ |
| 5 | </p></div><FILENAME·filename="creating-a-new-database-file.html"><html><head><title>Skapa·en·ny·databasfil</title><link·rel="stylesheet"·type="text/css"·href="help:/common/kde-default.css"><link·rel="stylesheet"·type="text/css"·href="help:/common/kde-docs.css"><link·rel="stylesheet"·type="text/css"·href="help:/common/kde-localised.css"><meta·name="generator"·content="DocBook·XSL·Stylesheets·V1.76.1"><meta·name="keywords"·content="KDE,·Calligra,·Kexi,·databas"><link·rel="home"·href="index.html"·title="Handbok·Kexi"><link·rel="up"·href="kexi-basics.html"·title="Kapitel·2.·Grunderna·i·Kexi"><link·rel="prev"·href="kexi-basics.html"·title="Kapitel·2.·Grunderna·i·Kexi"><link·rel="next"·href="the-kexi-main-window.html"·title="Huvudfönstret·i·Kexi"><meta·http-equiv="Content-Type"·content="text/html;·charset=utf-8"><meta·name="GENERATOR"·content="KDE·XSL·Stylesheet·V1.14·using·libxslt"></head><body·bgcolor="white"·text="black"·link="#0000FF"·vlink="#840084"·alink="#0000FF"><div·id="content"><div·id="header"><div·id="h·✂ | 5 | </p></div><FILENAME·filename="creating-a-new-database-file.html"><html><head><title>Skapa·en·ny·databasfil</title><link·rel="stylesheet"·type="text/css"·href="help:/common/kde-default.css"><link·rel="stylesheet"·type="text/css"·href="help:/common/kde-docs.css"><link·rel="stylesheet"·type="text/css"·href="help:/common/kde-localised.css"><meta·name="generator"·content="DocBook·XSL·Stylesheets·V1.76.1"><meta·name="keywords"·content="KDE,·Calligra,·Kexi,·databas"><link·rel="home"·href="index.html"·title="Handbok·Kexi"><link·rel="up"·href="kexi-basics.html"·title="Kapitel·2.·Grunderna·i·Kexi"><link·rel="prev"·href="kexi-basics.html"·title="Kapitel·2.·Grunderna·i·Kexi"><link·rel="next"·href="the-kexi-main-window.html"·title="Huvudfönstret·i·Kexi"><meta·http-equiv="Content-Type"·content="text/html;·charset=utf-8"><meta·name="GENERATOR"·content="KDE·XSL·Stylesheet·V1.14·using·libxslt"></head><body·bgcolor="white"·text="black"·link="#0000FF"·vlink="#840084"·alink="#0000FF"><div·id="content"><div·id="header"><div·id="h·✂ |
| 6 | </p><div·class="screenshot"><div·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="mediaobject"><hr><img·src="newproject.png"><hr></div></div><p> | 6 | </p><div·class="screenshot"><div·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="mediaobject"><hr><img·src="newproject.png"><hr></div></div><p> |
| 7 | </p><div·class="orderedlist"><ol·class="orderedlist"·type="1"><li·class="listitem"><p>Starta·<span·class="application">Kexi</span>,·eller·om·det·redan·kör,·använd·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guimenu">Kexi</span></span>·→·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guimenuitem">Ny...·(Ctrl+N)</span></span>.</p></li><li·class="listitem"><p>På·sidan·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Nytt·projekt</span></span>,·under·avsnittet·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Tomma·projekt</span></span>,·välj·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Tom·databas</span></span>.·</p><div·class="screenshot"><div·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="mediaobject"><hr><img·src="projectstorage.png"><hr></div></div></li><li·class="listit·✂ | 7 | </p><div·class="orderedlist"><ol·class="orderedlist"·type="1"><li·class="listitem"><p>Starta·<span·class="application">Kexi</span>,·eller·om·det·redan·kör,·använd·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guimenu">Kexi</span></span>·→·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guimenuitem">Ny...·(Ctrl+N)</span></span>.</p></li><li·class="listitem"><p>På·sidan·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Nytt·projekt</span></span>,·under·avsnittet·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Tomma·projekt</span></span>,·välj·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Tom·databas</span></span>.·</p><div·class="screenshot"><div·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="mediaobject"><hr><img·src="projectstorage.png"><hr></div></div></li><li·class="listit·✂ |
| 8 | </p><div·class="screenshot"><div·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="mediaobject"><hr><img·src="kexi_mainwindow.png"><hr></div></div><p> | 8 | </p><div·class="screenshot"><div·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="mediaobject"><hr><img·src="kexi_mainwindow.png"><hr></div></div><p> |
| Offset 40, 25 lines modified | Offset 40, 25 lines modified |
| 40 | </p><div·class="screenshot"><div·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="mediaobject"><hr><img·src="kexi_form_design_tab.png"><hr></div></div><p> | 40 | </p><div·class="screenshot"><div·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="mediaobject"><hr><img·src="kexi_form_design_tab.png"><hr></div></div><p> |
| 41 | </p><p>Från·fliken·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Formulärkonstruktion</span></span>·kan·du·välja·grafiska·komponenter·att·lägga·till·i·formuläret.·</p><div·class="variablelist"><dl><dt><span·class="term"><span·class="bold"><strong><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Pekare</span></span></strong></span></span></dt><dd><p><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Pekare</span></span>·byter·till·komponentvalsläge.</p></dd></dl></div><div·class="note"·style="margin-left:·0.5in;·margin-right:·0.5in;"><h3·class="title">Notera</h3><p>När·du·väljer·en·komponent·kommer·programmet·övergå·till·läget·för·att·lägga·till·komponenter.·Sedan·kan·du·klicka·var·som·helst·i·formuläret·för·att·placera·komponenten.</p></div><p> | 41 | </p><p>Från·fliken·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Formulärkonstruktion</span></span>·kan·du·välja·grafiska·komponenter·att·lägga·till·i·formuläret.·</p><div·class="variablelist"><dl><dt><span·class="term"><span·class="bold"><strong><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Pekare</span></span></strong></span></span></dt><dd><p><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Pekare</span></span>·byter·till·komponentvalsläge.</p></dd></dl></div><div·class="note"·style="margin-left:·0.5in;·margin-right:·0.5in;"><h3·class="title">Notera</h3><p>När·du·väljer·en·komponent·kommer·programmet·övergå·till·läget·för·att·lägga·till·komponenter.·Sedan·kan·du·klicka·var·som·helst·i·formuläret·för·att·placera·komponenten.</p></div><p> |
| 42 | </p><div·class="variablelist"><dl><dt><span·class="term"><span·class="bold"><strong><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Etikett</span></span></strong></span></span></dt><dd><p>Komponenten·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Etikett</span></span>·visar·fördefinierad·information·i·ett·formulär.·Den·används·oftast·som·rubrik·bredvid·andra·datastyrda·komponenter.</p></dd><dt><span·class="term"><span·class="bold"><strong><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Textruta</span></span></strong></span></span></dt><dd><p>En·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Textruta</span></span>·är·en·enkelradig·behållare·för·data·som·finns·i·en·tabell.</p></dd><dt><span·class="term"><span·class="bold"><strong><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="g·✂ | 42 | </p><div·class="variablelist"><dl><dt><span·class="term"><span·class="bold"><strong><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Etikett</span></span></strong></span></span></dt><dd><p>Komponenten·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Etikett</span></span>·visar·fördefinierad·information·i·ett·formulär.·Den·används·oftast·som·rubrik·bredvid·andra·datastyrda·komponenter.</p></dd><dt><span·class="term"><span·class="bold"><strong><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Textruta</span></span></strong></span></span></dt><dd><p>En·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Textruta</span></span>·är·en·enkelradig·behållare·för·data·som·finns·i·en·tabell.</p></dd><dt><span·class="term"><span·class="bold"><strong><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="g·✂ |
| 43 | </p><div·class="screenshot"><div·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="mediaobject"><hr><img·src="kexi_report_design_tab.png"><hr></div></div><p> | 43 | </p><div·class="screenshot"><div·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="mediaobject"><hr><img·src="kexi_report_design_tab.png"><hr></div></div><p> |
| 44 | </p><p>Från·fliken·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Rapportkonstruktion</span></span>·kan·du·välja·vilka·komponenter·du·vill·lägga·till·i·en·rapport.·</p><div·class="variablelist"><dl><dt><span·class="term"><span·class="bold"><strong><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Etikett</span></span></strong></span></span></dt><dd><p>Komponenten·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Etikett</span></span>·visar·fördefinierad·information·om·en·rapport.·Den·används·oftast·som·rubrik·bredvid·andra·datastyrda·komponenter.</p></dd><dt><span·class="term"><span·class="bold"><strong><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Fält</span></span></strong></span></span></dt><dd><p>Komponenten·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Fält</span·✂ | 44 | </p><p>Från·fliken·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Rapportkonstruktion</span></span>·kan·du·välja·vilka·komponenter·du·vill·lägga·till·i·en·rapport.·</p><div·class="variablelist"><dl><dt><span·class="term"><span·class="bold"><strong><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Etikett</span></span></strong></span></span></dt><dd><p>Komponenten·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Etikett</span></span>·visar·fördefinierad·information·om·en·rapport.·Den·används·oftast·som·rubrik·bredvid·andra·datastyrda·komponenter.</p></dd><dt><span·class="term"><span·class="bold"><strong><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Fält</span></span></strong></span></span></dt><dd><p>Komponenten·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Fält</span·✂ |
| 45 | </p><div·class="screenshot"><div·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="mediaobject"><hr><img·src="contact-example.png"><hr></div></div><p> | 45 | </p><div·class="screenshot"><div·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="mediaobject"><hr><img·src="contact-example.png"><hr></div></div><p> |
| 46 | </p><p>Bilden·ovan·visar·en·uppsättning·med·två·kontakter,·där·var·och·en·visas·på·ett·separat·kort.·Det·verkar·som·ett·sådan·kort·kan·utgöra·en·enstaka·rad·i·en·tabell:·</p><p> | 46 | </p><p>Bilden·ovan·visar·en·uppsättning·med·två·kontakter,·där·var·och·en·visas·på·ett·separat·kort.·Det·verkar·som·ett·sådan·kort·kan·utgöra·en·enstaka·rad·i·en·tabell:·</p><p> |
| 47 | </p><div·class="table"><a·name="idp149412664"></a><p·class="title"><b>Tabell·6.1.·<span·class="emphasis"><em>Kontakttabell</em></span></b></p><div·class="table-contents"><table·summary="Kontakttabell"·border="1"><colgroup><col><col></colgroup><thead><tr><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Namn</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Tel·nr.</span></span></th></tr></thead><tbody><tr><td> | 47 | </p><div·class="table"><a·name="idp149441336"></a><p·class="title"><b>Tabell·6.1.·<span·class="emphasis"><em>Kontakttabell</em></span></b></p><div·class="table-contents"><table·summary="Kontakttabell"·border="1"><colgroup><col><col></colgroup><thead><tr><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Namn</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Tel·nr.</span></span></th></tr></thead><tbody><tr><td> |
| 48 | ····<p>Anna</p> | 48 | ····<p>Anna</p> |
| 49 | ····</td><td> | 49 | ····</td><td> |
| 50 | ····<p>699·23·43·12</p> | 50 | ····<p>699·23·43·12</p> |
| 51 | ····</td></tr><tr><td> | 51 | ····</td></tr><tr><td> |
| 52 | ····<p>Stefan</p> | 52 | ····<p>Stefan</p> |
| 53 | ····</td><td> | 53 | ····</td><td> |
| 54 | ····<p>711·19·77·21</p></td></tr></tbody></table></div></div><p><br·class="table-break"> | 54 | ····<p>711·19·77·21</p></td></tr></tbody></table></div></div><p><br·class="table-break"> |
| 55 | </p><p>Termer·och·definitioner:·Ett·ensamt·dataobjekt·som·utgör·en·del·av·en·större·samling·kan·kallas·en·<span·class="emphasis"><em>rad</em></span>,·eller·mer·professionellt·en·<span·class="emphasis"><em>post</em></span>.·Samlingen·kallas·normalt·en·<span·class="emphasis"><em>tabell</em></span>.·Dessutom·är·det·mest·naturliga·namnet·på·tabellen·det·som·beskriver·datan·som·den·erbjuder/lagrar,·vilket·är·Kontakter.·Dessutom·består·varje·rad·i·tabellen·av·kolumner,·som·ofta·också·kallas·<span·class="emphasis"><em>fält</em></span>.·Det·finns·två·kolumner·(fält)·i·tabellen·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="replaceable"><em·class="replaceable"><code>Kontakter</code></em></span>:·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Namn</span></span>·och·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Tel·nr.</span></span>.·</p><p>För·enkla·användningar·kan·en·enda·tabell·utgöra·en·databas.·Må·✂ | 55 | </p><p>Termer·och·definitioner:·Ett·ensamt·dataobjekt·som·utgör·en·del·av·en·större·samling·kan·kallas·en·<span·class="emphasis"><em>rad</em></span>,·eller·mer·professionellt·en·<span·class="emphasis"><em>post</em></span>.·Samlingen·kallas·normalt·en·<span·class="emphasis"><em>tabell</em></span>.·Dessutom·är·det·mest·naturliga·namnet·på·tabellen·det·som·beskriver·datan·som·den·erbjuder/lagrar,·vilket·är·Kontakter.·Dessutom·består·varje·rad·i·tabellen·av·kolumner,·som·ofta·också·kallas·<span·class="emphasis"><em>fält</em></span>.·Det·finns·två·kolumner·(fält)·i·tabellen·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="replaceable"><em·class="replaceable"><code>Kontakter</code></em></span>:·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Namn</span></span>·och·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Tel·nr.</span></span>.·</p><p>För·enkla·användningar·kan·en·enda·tabell·utgöra·en·databas.·Må·✂ |
| 56 | </p></div><FILENAME·filename="database-and-spreadsheet.html"><html><head><title>Databas·och·kalkylblad</title><link·rel="stylesheet"·type="text/css"·href="help:/common/kde-default.css"><link·rel="stylesheet"·type="text/css"·href="help:/common/kde-docs.css"><link·rel="stylesheet"·type="text/css"·href="help:/common/kde-localised.css"><meta·name="generator"·content="DocBook·XSL·Stylesheets·V1.76.1"><meta·name="keywords"·content="KDE,·Calligra,·Kexi,·databas"><link·rel="home"·href="index.html"·title="Handbok·Kexi"><link·rel="up"·href="appendix-a--introduction-to-databases.html"·title="Kapitel·6.·Appendix·A.·Introduktion·till·databaser"><link·rel="prev"·href="appendix-a--introduction-to-databases.html"·title="Kapitel·6.·Appendix·A.·Introduktion·till·databaser"><link·rel="next"·href="database-design.html"·title="Databaskonstruktion"><meta·http-equiv="Content-Type"·content="text/html;·charset=utf-8"><meta·name="GENERATOR"·content="KDE·XSL·Stylesheet·V1.14·using·libxslt"></head><body·bgcolor="white"·text="black"·link·✂ | 56 | </p></div><FILENAME·filename="database-and-spreadsheet.html"><html><head><title>Databas·och·kalkylblad</title><link·rel="stylesheet"·type="text/css"·href="help:/common/kde-default.css"><link·rel="stylesheet"·type="text/css"·href="help:/common/kde-docs.css"><link·rel="stylesheet"·type="text/css"·href="help:/common/kde-localised.css"><meta·name="generator"·content="DocBook·XSL·Stylesheets·V1.76.1"><meta·name="keywords"·content="KDE,·Calligra,·Kexi,·databas"><link·rel="home"·href="index.html"·title="Handbok·Kexi"><link·rel="up"·href="appendix-a--introduction-to-databases.html"·title="Kapitel·6.·Appendix·A.·Introduktion·till·databaser"><link·rel="prev"·href="appendix-a--introduction-to-databases.html"·title="Kapitel·6.·Appendix·A.·Introduktion·till·databaser"><link·rel="next"·href="database-design.html"·title="Databaskonstruktion"><meta·http-equiv="Content-Type"·content="text/html;·charset=utf-8"><meta·name="GENERATOR"·content="KDE·XSL·Stylesheet·V1.14·using·libxslt"></head><body·bgcolor="white"·text="black"·link·✂ |
| 57 | </p><div·class="table"><a·name="idp149432120"></a><p·class="title"><b>Tabell·6.2.·<span·class="emphasis"><em>Kontakttabell</em></span></b></p><div·class="table-contents"><table·summary="Kontakttabell"·border="1"><colgroup><col><col><col></colgroup><thead><tr><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">För-·och·efternamn</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Tel</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Adress</span></span></th></tr></thead><tbody><tr><td> | 57 | </p><div·class="table"><a·name="idp149460792"></a><p·class="title"><b>Tabell·6.2.·<span·class="emphasis"><em>Kontakttabell</em></span></b></p><div·class="table-contents"><table·summary="Kontakttabell"·border="1"><colgroup><col><col><col></colgroup><thead><tr><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">För-·och·efternamn</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Tel</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Adress</span></span></th></tr></thead><tbody><tr><td> |
| 58 | ····<p>Anna·Johansson</p> | 58 | ····<p>Anna·Johansson</p> |
| 59 | ····</td><td> | 59 | ····</td><td> |
| 60 | ····<p>699·23·43·12</p> | 60 | ····<p>699·23·43·12</p> |
| 61 | ····</td><td> | 61 | ····</td><td> |
| 62 | ····<p>Västerport·1,·Grönköping</p> | 62 | ····<p>Västerport·1,·Grönköping</p> |
| 63 | ····</td></tr><tr><td> | 63 | ····</td></tr><tr><td> |
| 64 | ····<p>Stefan·Andersson</p> | 64 | ····<p>Stefan·Andersson</p> |
| Offset 81, 24 lines modified | Offset 81, 24 lines modified |
| 81 | ····</td></tr><tr><td> | 81 | ····</td></tr><tr><td> |
| 82 | ····<p>STEFAN·Andersson</p> | 82 | ····<p>STEFAN·Andersson</p> |
| 83 | ····</td><td> | 83 | ····</td><td> |
| 84 | ····<p>231·83·02·04</p> | 84 | ····<p>231·83·02·04</p> |
| 85 | ····</td><td> | 85 | ····</td><td> |
| 86 | ····<p>Klockargränd·5,·Wadköping</p></td></tr></tbody></table></div></div><p><br·class="table-break"> | 86 | ····<p>Klockargränd·5,·Wadköping</p></td></tr></tbody></table></div></div><p><br·class="table-break"> |
| 87 | </p><p>En·sådan·tabell·kan·både·skapas·i·ett·kalkylblad·och·i·en·databas.·Det·är·förstås·mycket·enkelt·att·använda·ett·kalkylblad.·Vilka·problem·stöter·man·på·i·detta·stadium?·</p></div><div·class="sect2"><div·class="titlepage"><div><div><h3·class="title"><a·name="referential-data-integrity"></a>Datahänvisningsintegritet</h3></div></div></div><p>Antag·att·du·använder·ett·kalkylblad·och·måste·ändra·adressen·för·minst·en·person.·Du·har·ett·litet·problem:·du·måste·ofta·ändra·adressen·på·flera·rader.·Anna·använder·till·exempel·tre·rader.·Ett·riktigt·problem·uppstår·om·du·glömmer·att·ändra·en·av·de·tre·raderna:·adressen·som·hör·ihop·med·personen·blir·tvetydig,·på·så·sätt·går·dataintegriteten·förlorad.·</p><p>Förutom·det·finns·det·inget·enkelt·sätt·att·ta·bort·en·vald·person·från·tabellen,·eftersom·du·måste·komma·ihåg·att·ta·bort·alla·rader·som·hör·ihop·med·honom·eller·henne.·</p></div><div·class="sect2"><div·class="titlepage"><div><div><h3·class="title"><a·name="data-redundancy"></a>Överflödig·data</h3></div></div·✂ | 87 | </p><p>En·sådan·tabell·kan·både·skapas·i·ett·kalkylblad·och·i·en·databas.·Det·är·förstås·mycket·enkelt·att·använda·ett·kalkylblad.·Vilka·problem·stöter·man·på·i·detta·stadium?·</p></div><div·class="sect2"><div·class="titlepage"><div><div><h3·class="title"><a·name="referential-data-integrity"></a>Datahänvisningsintegritet</h3></div></div></div><p>Antag·att·du·använder·ett·kalkylblad·och·måste·ändra·adressen·för·minst·en·person.·Du·har·ett·litet·problem:·du·måste·ofta·ändra·adressen·på·flera·rader.·Anna·använder·till·exempel·tre·rader.·Ett·riktigt·problem·uppstår·om·du·glömmer·att·ändra·en·av·de·tre·raderna:·adressen·som·hör·ihop·med·personen·blir·tvetydig,·på·så·sätt·går·dataintegriteten·förlorad.·</p><p>Förutom·det·finns·det·inget·enkelt·sätt·att·ta·bort·en·vald·person·från·tabellen,·eftersom·du·måste·komma·ihåg·att·ta·bort·alla·rader·som·hör·ihop·med·honom·eller·henne.·</p></div><div·class="sect2"><div·class="titlepage"><div><div><h3·class="title"><a·name="data-redundancy"></a>Överflödig·data</h3></div></div·✂ |
| 88 | </p><div·class="table"><a·name="idp149454520"></a><p·class="title"><b>Tabell·6.3.·<span·class="emphasis"><em>Persontabell</em></span></b></p><div·class="table-contents"><table·summary="Persontabell"·border="1"><colgroup><col><col></colgroup><thead><tr><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">För-·och·efternamn</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Adress</span></span></th></tr></thead><tbody><tr><td> | 88 | </p><div·class="table"><a·name="idp149483192"></a><p·class="title"><b>Tabell·6.3.·<span·class="emphasis"><em>Persontabell</em></span></b></p><div·class="table-contents"><table·summary="Persontabell"·border="1"><colgroup><col><col></colgroup><thead><tr><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">För-·och·efternamn</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Adress</span></span></th></tr></thead><tbody><tr><td> |
| 89 | ····<p>Anna·Johansson</p> | 89 | ····<p>Anna·Johansson</p> |
| 90 | ····</td><td> | 90 | ····</td><td> |
| 91 | ····<p>Västerport·1,·Grönköping</p> | 91 | ····<p>Västerport·1,·Grönköping</p> |
| 92 | ····</td></tr><tr><td> | 92 | ····</td></tr><tr><td> |
| 93 | ····<p>Stefan·Andersson</p> | 93 | ····<p>Stefan·Andersson</p> |
| 94 | ····</td><td> | 94 | ····</td><td> |
| 95 | ····<p>Klockargränd·5,·Wadköping</p></td></tr></tbody></table></div></div><p><br·class="table-break"> | 95 | ····<p>Klockargränd·5,·Wadköping</p></td></tr></tbody></table></div></div><p><br·class="table-break"> |
| 96 | </p><p>Varje·rad·i·tabellen·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="replaceable"><em·class="replaceable"><code>Personer</code></em></span>·motsvarar·en·och·samma·person.·Tabellen·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="replaceable"><em·class="replaceable"><code>Kontakter</code></em></span>·är·från·och·med·nu·i·en·relation·till·tabellen·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="replaceable"><em·class="replaceable"><code>Personer</code></em></span>.·</p></div><div·class="sect2"><div·class="titlepage"><div><div><h3·class="title"><a·name="data-integrity-and-validity"></a>Dataintegritet·och·giltighet</h3></div></div></div><p>Observera·sättet·som·data·skrivs·in·i·fälten·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="replaceable"><em·class="replaceable"><code>För-·och·efternamn</code></em></span>·samt·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="replaceable"><em·class="replaceable"><code>Adress</code></em><·✂ | 96 | </p><p>Varje·rad·i·tabellen·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="replaceable"><em·class="replaceable"><code>Personer</code></em></span>·motsvarar·en·och·samma·person.·Tabellen·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="replaceable"><em·class="replaceable"><code>Kontakter</code></em></span>·är·från·och·med·nu·i·en·relation·till·tabellen·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="replaceable"><em·class="replaceable"><code>Personer</code></em></span>.·</p></div><div·class="sect2"><div·class="titlepage"><div><div><h3·class="title"><a·name="data-integrity-and-validity"></a>Dataintegritet·och·giltighet</h3></div></div></div><p>Observera·sättet·som·data·skrivs·in·i·fälten·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="replaceable"><em·class="replaceable"><code>För-·och·efternamn</code></em></span>·samt·<span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="replaceable"><em·class="replaceable"><code>Adress</code></em><·✂ |
| 97 | </p><div·class="table"><a·name="idp149486008"></a><p·class="title"><b>Tabell·6.4.·<span·class="emphasis"><em>Persontabell</em></span></b></p><div·class="table-contents"><table·summary="Persontabell"·border="1"><colgroup><col><col><col><col><col></colgroup><thead><tr><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Namn</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Efternamn</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Gatuadress</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Gatunummer</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Postort</span></span></th></tr></thead><tbody><tr><td> | 97 | </p><div·class="table"><a·name="idp149502392"></a><p·class="title"><b>Tabell·6.4.·<span·class="emphasis"><em>Persontabell</em></span></b></p><div·class="table-contents"><table·summary="Persontabell"·border="1"><colgroup><col><col><col><col><col></colgroup><thead><tr><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Namn</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Efternamn</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Gatuadress</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Gatunummer</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Postort</span></span></th></tr></thead><tbody><tr><td> |
| 98 | ····<p>Anna</p> | 98 | ····<p>Anna</p> |
| 99 | ····</td><td> | 99 | ····</td><td> |
| 100 | ····<p>Johansson</p> | 100 | ····<p>Johansson</p> |
| 101 | ····</td><td> | 101 | ····</td><td> |
| 102 | ····<p>Västerport</p> | 102 | ····<p>Västerport</p> |
| 103 | ····</td><td> | 103 | ····</td><td> |
| 104 | ····<p>1</p> | 104 | ····<p>1</p> |
| Offset 123, 15 lines modified | Offset 123, 15 lines modified |
| 123 | ····</td><td> | 123 | ····</td><td> |
| 124 | ····<p>nödvändigt·fält</p> | 124 | ····<p>nödvändigt·fält</p> |
| 125 | ····</td><td> | 125 | ····</td><td> |
| 126 | ····<p>nödvändigt·fält</p> | 126 | ····<p>nödvändigt·fält</p> |
| 127 | ····</td><td> | 127 | ····</td><td> |
| 128 | ····<p>nödvändigt·fält</p></td></tr></tbody></table></div></div><p><br·class="table-break"> | 128 | ····<p>nödvändigt·fält</p></td></tr></tbody></table></div></div><p><br·class="table-break"> |
| 129 | </p><p>På·grund·av·att·villkoret·nödvändigt·fält·introducerades·kan·vi·vara·säkra·på·att·inskriven·data·är·fullständig.·I·fallet·med·andra·tabeller·kan·man·förstås·fortsätta·att·utesluta·vissa·fält·när·data·skrivs·in.·</p></div><div·class="sect2"><div·class="titlepage"><div><div><h3·class="title"><a·name="limiting-data-view"></a>Begränsa·datavisning</h3></div></div></div><p>Kalkylblad·visar·alla·rader·och·kolumner·i·tabellen,·vilket·är·besvärligt·i·fallet·med·mycket·stora·datamängder.·Du·kan·förstås·filtrera·och·sortera·rader·i·kalkylblad,·men·du·måste·vara·extra·försiktig·när·du·gör·det.·Användare·av·kalkylblad·löper·risk·att·glömma·att·datavyn·har·filtrerats,·vilket·kan·orsaka·misstag.·När·du·beräknar·summor,·kanske·du·tror·att·du·har·100·rader·med·data,·medan·det·i·själva·verket·finns·ytterligare·20·dolda·rader.·</p><p>Om·du·vill·arbeta·med·en·mindre·delmängd·av·data,·t.ex.·för·att·skicka·den·till·andra·för·redigering,·kan·du·kopiera·och·klistra·in·i·ett·annat·kalkylblad,·och·efter·redigering·klistra·in·än·✂ | 129 | </p><p>På·grund·av·att·villkoret·nödvändigt·fält·introducerades·kan·vi·vara·säkra·på·att·inskriven·data·är·fullständig.·I·fallet·med·andra·tabeller·kan·man·förstås·fortsätta·att·utesluta·vissa·fält·när·data·skrivs·in.·</p></div><div·class="sect2"><div·class="titlepage"><div><div><h3·class="title"><a·name="limiting-data-view"></a>Begränsa·datavisning</h3></div></div></div><p>Kalkylblad·visar·alla·rader·och·kolumner·i·tabellen,·vilket·är·besvärligt·i·fallet·med·mycket·stora·datamängder.·Du·kan·förstås·filtrera·och·sortera·rader·i·kalkylblad,·men·du·måste·vara·extra·försiktig·när·du·gör·det.·Användare·av·kalkylblad·löper·risk·att·glömma·att·datavyn·har·filtrerats,·vilket·kan·orsaka·misstag.·När·du·beräknar·summor,·kanske·du·tror·att·du·har·100·rader·med·data,·medan·det·i·själva·verket·finns·ytterligare·20·dolda·rader.·</p><p>Om·du·vill·arbeta·med·en·mindre·delmängd·av·data,·t.ex.·för·att·skicka·den·till·andra·för·redigering,·kan·du·kopiera·och·klistra·in·i·ett·annat·kalkylblad,·och·efter·redigering·klistra·in·än·✂ |
| 130 | </p><div·class="table"><a·name="idp149521080"></a><p·class="title"><b>Tabell·6.5.·<span·class="emphasis"><em>Persontabell</em></span></b></p><div·class="table-contents"><table·summary="Persontabell"·border="1"><colgroup><col><col><col><col><col><col></colgroup><thead><tr><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Namn</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Efternamn</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Gatuadress</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Gatunummer</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Postort</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Inkomst</sp·✂ | 130 | </p><div·class="table"><a·name="idp149603000"></a><p·class="title"><b>Tabell·6.5.·<span·class="emphasis"><em>Persontabell</em></span></b></p><div·class="table-contents"><table·summary="Persontabell"·border="1"><colgroup><col><col><col><col><col><col></colgroup><thead><tr><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Namn</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Efternamn</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Gatuadress</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Gatunummer</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Postort</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Inkomst</sp·✂ |
| 131 | ····<p>Anna</p> | 131 | ····<p>Anna</p> |
| 132 | ····</td><td> | 132 | ····</td><td> |
| 133 | ····<p>Johansson</p> | 133 | ····<p>Johansson</p> |
| 134 | ····</td><td> | 134 | ····</td><td> |
| 135 | ····<p>Västerport</p> | 135 | ····<p>Västerport</p> |
| 136 | ····</td><td> | 136 | ····</td><td> |
| 137 | ····<p>1</p> | 137 | ····<p>1</p> |
| Offset 148, 15 lines modified | Offset 148, 15 lines modified |
| 148 | ····</td><td> | 148 | ····</td><td> |
| 149 | ····<p>5</p> | 149 | ····<p>5</p> |
| 150 | ····</td><td> | 150 | ····</td><td> |
| 151 | ····<p>Wadköping</p> | 151 | ····<p>Wadköping</p> |
| 152 | ····</td><td> | 152 | ····</td><td> |
| 153 | ····<p>19·000</p></td></tr></tbody></table></div></div><p><br·class="table-break"> | 153 | ····<p>19·000</p></td></tr></tbody></table></div></div><p><br·class="table-break"> |
| 154 | </p><p>Låt·oss·anta·att·den·nytillagda·kolumnen·Inkomst·innehåller·konfidentiell·data.·Hur·kan·du·till·exempel·dela·personernas·kontaktinformation·med·arbetskollegor·utan·att·avslöja·deras·inkomst?·Det·är·möjligt·om·du·bara·delar·en·förfrågan·och·inte·hela·tabellen.·Förfrågan·kunde·välja·alla·kolumner·utom·kolumnen·Inkomst.·I·databasvärlden·är·en·sådan·förfrågan·ofta·känd·som·en·vy.·</p></div><div·class="sect2"><div·class="titlepage"><div><div><h3·class="title"><a·name="performance-and-capacity"></a>Prestanda·och·kapacitet</h3></div></div></div><p>Din·dator·är·troligen·rätt·snabb,·men·du·märker·lätt·att·det·inte·hjälper·med·långsamma,·stora·kalkylblad.·Deras·låga·effektivitet·beror·först·av·allt·på·avsaknaden·av·index·som·snabbar·upp·datasökningsprocessen·(databaser·erbjuder·dem).·Om·du·dessutom·använder·saker·som·systemets·klippbord,·kan·till·och·med·kopiering·av·data·bli·besvärlig·med·tiden.·</p><p>Kalkylblad·som·innehåller·stora·datamängder·kan·ta·enorm·tid·att·öppna.·Kalkylblad·laddar·mängder·med·data·i·d·✂ | 154 | </p><p>Låt·oss·anta·att·den·nytillagda·kolumnen·Inkomst·innehåller·konfidentiell·data.·Hur·kan·du·till·exempel·dela·personernas·kontaktinformation·med·arbetskollegor·utan·att·avslöja·deras·inkomst?·Det·är·möjligt·om·du·bara·delar·en·förfrågan·och·inte·hela·tabellen.·Förfrågan·kunde·välja·alla·kolumner·utom·kolumnen·Inkomst.·I·databasvärlden·är·en·sådan·förfrågan·ofta·känd·som·en·vy.·</p></div><div·class="sect2"><div·class="titlepage"><div><div><h3·class="title"><a·name="performance-and-capacity"></a>Prestanda·och·kapacitet</h3></div></div></div><p>Din·dator·är·troligen·rätt·snabb,·men·du·märker·lätt·att·det·inte·hjälper·med·långsamma,·stora·kalkylblad.·Deras·låga·effektivitet·beror·först·av·allt·på·avsaknaden·av·index·som·snabbar·upp·datasökningsprocessen·(databaser·erbjuder·dem).·Om·du·dessutom·använder·saker·som·systemets·klippbord,·kan·till·och·med·kopiering·av·data·bli·besvärlig·med·tiden.·</p><p>Kalkylblad·som·innehåller·stora·datamängder·kan·ta·enorm·tid·att·öppna.·Kalkylblad·laddar·mängder·med·data·i·d·✂ |
| 155 | </p><div·class="table"><a·name="idp149644344"></a><p·class="title"><b>Tabell·7.1.·<span·class="emphasis"><em>Jämförelse·av·datatyper·som·används·i·Kexi·och·andra·databasprogram</em></span></b></p><div·class="table-contents"><table·summary="Jämförelse·av·datatyper·som·används·i·Kexi·och·andra·databasprogram"·border="1"><colgroup><col><col><col><col></colgroup><thead><tr><th><span·class="application">Kexi</span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">MS·Access</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">dBase/FoxPro</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Paradox</span></span></th></tr></thead><tbody><tr><td> | 155 | </p><div·class="table"><a·name="idp149664824"></a><p·class="title"><b>Tabell·7.1.·<span·class="emphasis"><em>Jämförelse·av·datatyper·som·används·i·Kexi·och·andra·databasprogram</em></span></b></p><div·class="table-contents"><table·summary="Jämförelse·av·datatyper·som·används·i·Kexi·och·andra·databasprogram"·border="1"><colgroup><col><col><col><col></colgroup><thead><tr><th><span·class="application">Kexi</span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">MS·Access</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">dBase/FoxPro</span></span></th><th><span·xmlns:doc="http://nwalsh.com/xsl/documentation/1.0"·class="guiitem"><span·class="guilabel">Paradox</span></span></th></tr></thead><tbody><tr><td> |
| 156 | ····<p>Text·(Text)</p> | 156 | ····<p>Text·(Text)</p> |
| 157 | ····</td><td> | 157 | ····</td><td> |
| 158 | ····<p>Text</p> | 158 | ····<p>Text</p> |
| 159 | ····</td><td> | 159 | ····</td><td> |
| 160 | ····<p>Character</p> | 160 | ····<p>Character</p> |
| 161 | ····</td><td> | 161 | ····</td><td> |
| 162 | ····<p>Alphanumeric</p> | 162 | ····<p>Alphanumeric</p> |