{"id":9368,"date":"2026-01-08T10:00:00","date_gmt":"2026-01-08T10:00:00","guid":{"rendered":"https:\/\/euroshopkey.com\/microsoft-access-datubazu-izveides-rokasgramata\/"},"modified":"2026-01-08T10:00:00","modified_gmt":"2026-01-08T10:00:00","slug":"microsoft-access-datubazu-izveides-rokasgramata","status":"publish","type":"post","link":"https:\/\/euroshopkey.com\/lv\/microsoft-access-guide-professional-database\/","title":{"rendered":"Microsoft Access: piln\u012bga rokasgr\u0101mata datub\u0101\u017eu izveidei"},"content":{"rendered":"<h2>Microsoft Access: datub\u0101ze ikvienam<\/h2>\n<p><strong>Microsoft Access<\/strong> ir datub\u0101zu p\u0101rvald\u012bbas sist\u0113ma (DBVS), kas iek\u013cauta <strong>Microsoft Office<\/strong> pakotn\u0113. Vair\u0101k nek\u0101 30 gadu t\u0101 pal\u012bdz uz\u0146\u0113mumiem, biedr\u012bb\u0101m un priv\u0101tperson\u0101m veidot, p\u0101rvald\u012bt un vaic\u0101t datub\u0101zes bez padzi\u013cin\u0101t\u0101m SQL programm\u0113\u0161anas zin\u0101\u0161an\u0101m.<\/p>\n<p>Pret\u0113ji izplat\u012btajam uzskatam <strong>Access<\/strong> nav vienk\u0101r\u0161i uzlabota izkl\u0101jlapa. Tas ir \u012bsts rel\u0101ciju datu p\u0101rvald\u012bbas r\u012bks, kas sp\u0113j apstr\u0101d\u0101t t\u016bksto\u0161iem ierakstu, veidot profesion\u0101las datu ievades formas un \u0123ener\u0113t automatiz\u0113tus p\u0101rskatus.<\/p>\n<p><strong>Access<\/strong> ir iek\u013cauts <strong>Office Professional Plus<\/strong> versij\u0101, kas euroshopkey.com pieejama tikai par <strong><strong class=\"prix-produit\">skat\u012bt cenu<\/strong><\/strong>.<\/p>\n<h3>Satura r\u0101d\u012bt\u0101js<\/h3>\n<ul>\n<li><a href=\"#acc-quoi\">1. Kam izmanto Microsoft Access?<\/a><\/li>\n<li><a href=\"#acc-vs-excel\">2. Access pret Excel: kuru un kad izv\u0113l\u0113ties<\/a><\/li>\n<li><a href=\"#acc-fonctions\">3. Galven\u0101s funkcijas<\/a><\/li>\n<li><a href=\"#acc-creer\">4. Pirm\u0101s datub\u0101zes izveide<\/a><\/li>\n<li><a href=\"#acc-usages\">5. Piem\u0113ri no re\u0101l\u0101s dz\u012bves<\/a><\/li>\n<li><a href=\"#acc-obtenir\">6. K\u0101 ieg\u0101d\u0101ties Microsoft Access<\/a><\/li>\n<li><a href=\"#acc-faq\">7. Bie\u017e\u0101k uzdotie jaut\u0101jumi<\/a><\/li>\n<\/ul>\n<h2 id=\"acc-quoi\">1. Kam izmanto Microsoft Access?<\/h2>\n<p><strong>Microsoft Access<\/strong> \u013cauj:<\/p>\n<ul>\n<li><strong>Uzglab\u0101t struktur\u0113tus datus<\/strong> rel\u0101ciju tabul\u0101s<\/li>\n<li><strong>Veidot saist\u012bbas<\/strong> starp da\u017e\u0101d\u0101m tabul\u0101m (klienti \u2194 pas\u016bt\u012bjumi \u2194 produkti)<\/li>\n<li><strong>Izstr\u0101d\u0101t datu ievades formas<\/strong>, kas ir saprotamas ar\u012b lietot\u0101jiem bez tehnisk\u0101m zin\u0101\u0161an\u0101m<\/li>\n<li><strong>\u0122ener\u0113t izdruk\u0101jamus p\u0101rskatus<\/strong> ar autom\u0101tiskiem apr\u0113\u0137iniem<\/li>\n<li><strong>Automatiz\u0113t procesus<\/strong> ar makro un VBA pal\u012bdz\u012bbu<\/li>\n<li><strong>Import\u0113t un eksport\u0113t<\/strong> datus no Excel, CSV, SQL Server, SharePoint<\/li>\n<\/ul>\n<h2 id=\"acc-vs-excel\">2. Access pret Excel: kuru un kad izv\u0113l\u0113ties?<\/h2>\n<p>\u0160is ir visbie\u017e\u0101k uzdotais jaut\u0101jums. Daudzi lietot\u0101ji izmanto Excel k\u0101 datub\u0101zi, ta\u010du tas nav t\u0101 uzdevums. L\u016bk, kad ir v\u0113rts p\u0101riet uz Access:<\/p>\n<table>\n<thead>\n<tr>\n<th>Krit\u0113rijs<\/th>\n<th>Excel<\/th>\n<th>Access<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Ierakstu skaits<\/td>\n<td>L\u012bdz 1 048 576 rind\u0101m<\/td>\n<td>L\u012bdz 2 GB (miljoniem ierakstu)<\/td>\n<\/tr>\n<tr>\n<td>Saist\u012bbas starp datiem<\/td>\n<td>\u274c Sare\u017e\u0123\u012bti<\/td>\n<td>\u2705 Ieb\u016bv\u0113tas (1:N, N:N saist\u012bbas)<\/td>\n<\/tr>\n<tr>\n<td>Datu ievades formas<\/td>\n<td>\u274c Ierobe\u017eotas<\/td>\n<td>\u2705 Profesion\u0101las formas<\/td>\n<\/tr>\n<tr>\n<td>Vair\u0101ki lietot\u0101ji<\/td>\n<td>\u26a0\ufe0f Bie\u017ei konflikti<\/td>\n<td>\u2705 Iesp\u0113jama vienlaic\u012bga piek\u013cuve<\/td>\n<\/tr>\n<tr>\n<td>Automatiz\u0113ti p\u0101rskati<\/td>\n<td>\u26a0\ufe0f Ierobe\u017eoti<\/td>\n<td>\u2705 Sare\u017e\u0123\u012bti p\u0101rskati<\/td>\n<\/tr>\n<tr>\n<td>Apr\u0113\u0137ini un anal\u012bze<\/td>\n<td>\u2705 Izcili<\/td>\n<td>\u26a0\ufe0f SQL vaic\u0101jumi<\/td>\n<\/tr>\n<tr>\n<td>Diagrammas<\/td>\n<td>\u2705 Izcilas<\/td>\n<td>\u26a0\ufe0f Pamata l\u012bmen\u012b<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>Vienk\u0101r\u0161s princips:<\/strong> ja jums ir vair\u0101k nek\u0101 10 000 rindu, ja nepiecie\u0161ams sasaist\u012bt vair\u0101kas tabulas vai ja datus ievada vair\u0101ki cilv\u0113ki \u2192 p\u0101rejiet uz <strong>Access<\/strong>.<\/p>\n<h2 id=\"acc-fonctions\">3. Access galven\u0101s funkcijas<\/h2>\n<h4>Tabulas un saist\u012bbas<\/h4>\n<p>Veidojiet tabulas ar noteikta tipa laukiem (teksts, skaitlis, datums, J\u0101\/N\u0113, pielikumi). Defin\u0113jiet prim\u0101r\u0101s atsl\u0113gas un saist\u012bbas starp tabul\u0101m, lai nodro\u0161in\u0101tu datu integrit\u0101ti.<\/p>\n<h4>Vaic\u0101jumi<\/h4>\n<p>Vaic\u0101jiet datus ar vizu\u0101l\u0101 vaic\u0101jumu ved\u0146a pal\u012bdz\u012bbu vai rakstiet SQL tie\u0161i. Pieejami atlases, atjaunin\u0101\u0161anas, dz\u0113\u0161anas, tabulu izveides un krustotie vaic\u0101jumi.<\/p>\n<h4>Formas<\/h4>\n<p>Izstr\u0101d\u0101jiet profesion\u0101las datu ievades saskarnes ar teksta laukiem, nolai\u017eamajiem sarakstiem, izv\u0113les r\u016bti\u0146\u0101m, ciln\u0113m un apak\u0161form\u0101m. Lietot\u0101jiem nekad nav j\u0101redz pa\u0161as tabulas.<\/p>\n<h4>P\u0101rskati<\/h4>\n<p>\u0122ener\u0113jiet izdruk\u0101jamus dokumentus: r\u0113\u0137inus, pas\u016bt\u012bjumus, eti\u0137etes un kopsavilkuma p\u0101rskatus ar autom\u0101tiskiem kopsummas un starpsummas apr\u0113\u0137iniem.<\/p>\n<h4>Makro un VBA<\/h4>\n<p>Automatiz\u0113jiet atk\u0101rtotus uzdevumus ar vienk\u0101r\u0161iem makro vai VBA kodu sare\u017e\u0123\u012bt\u0101kiem procesiem (e-pasta s\u016bt\u012b\u0161ana, autom\u0101tisks imports, padzi\u013cin\u0101ta p\u0101rbaude).<\/p>\n<h2 id=\"acc-creer\">4. Pirm\u0101s datub\u0101zes izveide<\/h2>\n<p>L\u016bk, so\u013ci, k\u0101 s\u0101kt darbu ar <strong>Microsoft Access<\/strong>:<\/p>\n<h4>1. solis: izpl\u0101nojiet strukt\u016bru<\/h4>\n<p>Nosakiet, k\u0101di dati j\u0101uzglab\u0101 un k\u0101das saist\u012bbas starp tiem past\u0101v. Piem\u0113rs klientu p\u0101rvald\u012bbai: tabula Klienti, tabula Pas\u016bt\u012bjumi, tabula Produkti.<\/p>\n<h4>2. solis: izveidojiet tabulas<\/h4>\n<p>Atveriet Access un izveidojiet jaunu datub\u0101zi. Defin\u0113jiet tabulas kop\u0101 ar to laukiem un datu tipiem.<\/p>\n<h4>3. solis: defin\u0113jiet saist\u012bbas<\/h4>\n<p>Ciln\u0113 &#8220;Datub\u0101zes r\u012bki&#8221; \u2192 &#8220;Saist\u012bbas&#8221; sasaistiet tabulas sav\u0101 starp\u0101, izmantojot prim\u0101r\u0101s un \u0101r\u0113j\u0101s atsl\u0113gas.<\/p>\n<h4>4. solis: izveidojiet formu<\/h4>\n<p>Atlasiet tabulu un p\u0113c tam izv\u0113lieties &#8220;Izveidot&#8221; \u2192 &#8220;Forma&#8221;. Access autom\u0101tiski \u0123ener\u0113 datu ievades formu, kuru varat piel\u0101got.<\/p>\n<h4>5. solis: pievienojiet vaic\u0101jumus un p\u0101rskatus<\/h4>\n<p>Izveidojiet vaic\u0101jumus, lai filtr\u0113tu un analiz\u0113tu datus, un p\u0113c tam p\u0101rskatus, lai tos profesion\u0101li noform\u0113tu.<\/p>\n<h2 id=\"acc-usages\">5. Piem\u0113ri no re\u0101l\u0101s dz\u012bves<\/h2>\n<ul>\n<li><strong>Klientu p\u0101rvald\u012bba \/ CRM<\/strong>: kontaktu uzskaite, sazi\u0146as v\u0113sture, atg\u0101din\u0101jumi<\/li>\n<li><strong>Noliktavas p\u0101rvald\u012bba<\/strong>: pre\u010du pie\u0146em\u0161ana un izsnieg\u0161ana, inventariz\u0101cija, papildin\u0101\u0161anas sliek\u0161\u0146i<\/li>\n<li><strong>R\u0113\u0137inu izrakst\u012b\u0161ana<\/strong>: r\u0113\u0137inu \u0123ener\u0113\u0161ana, maks\u0101jumu uzskaite, autom\u0101tiski atg\u0101din\u0101jumi<\/li>\n<li><strong>Projektu vad\u012bba<\/strong>: uzdevumu uzskaite, resursu pie\u0161\u0137ir\u0161ana, atskaites<\/li>\n<li><strong>Nekustam\u0101 \u012bpa\u0161uma p\u0101rvald\u012bba<\/strong>: \u012brnieki, l\u012bgumi, \u012bres maksa, komun\u0101lie maks\u0101jumi<\/li>\n<li><strong>Biedr\u012bbas<\/strong>: biedri, biedru naudas, pas\u0101kumi, vienk\u0101r\u0161ota gr\u0101matved\u012bba<\/li>\n<\/ul>\n<h2 id=\"acc-obtenir\">6. K\u0101 ieg\u0101d\u0101ties Microsoft Access<\/h2>\n<p><strong>Access NAV pieejams atsevi\u0161\u0137i.<\/strong> Tas ir iek\u013cauts tikai Office <strong>Professional Plus<\/strong> versij\u0101s:<\/p>\n<div style=\"display:grid;grid-template-columns:1fr 1fr;gap:20px;margin:20px 0;\">\n<div style=\"border:2px solid #0078d4;border-radius:10px;padding:20px;text-align:center;\">\n<h4 style=\"color:#0078d4;\">Office 2024 Pro Plus<\/h4>\n<p>Word + Excel + PPT + Outlook + <strong>Access<\/strong> + Publisher + Teams<\/p>\n<p style=\"font-size:1.3em;font-weight:700;color:#e74c3c;\"><strong class=\"prix-produit\">skat\u012bt cenu<\/strong><\/p>\n<p><a href=\"https:\/\/euroshopkey.com\/lv\/product\/office-2024-professionnel-plus\/\" style=\"display:inline-block;background:#0078d4;color:#fff;padding:10px 30px;border-radius:5px;text-decoration:none;font-weight:600;\">Pirkt tagad \u2192<\/a>\n<\/div>\n<div style=\"border:2px solid #27ae60;border-radius:10px;padding:20px;text-align:center;\">\n<h4 style=\"color:#27ae60;\">Office 2021 Pro Plus<\/h4>\n<p>Word + Excel + PPT + Outlook + <strong>Access<\/strong> + Publisher<\/p>\n<p style=\"font-size:1.3em;font-weight:700;color:#e74c3c;\"><strong class=\"prix-produit\">skat\u012bt cenu<\/strong><\/p>\n<p><a href=\"https:\/\/euroshopkey.com\/lv\/product\/office-2021-professionnel-plus\/\" style=\"display:inline-block;background:#27ae60;color:#fff;padding:10px 30px;border-radius:5px;text-decoration:none;font-weight:600;\">Pirkt tagad \u2192<\/a>\n<\/div>\n<\/div>\n<p>Skatiet visas versijas: <a href=\"https:\/\/euroshopkey.com\/lv\/pack-office-2024-guide-complet-suite-microsoft\/\">piln\u0101 Office 2024 komplekta rokasgr\u0101mata<\/a>.<\/p>\n<h2 id=\"acc-faq\">7. Bie\u017e\u0101k uzdotie jaut\u0101jumi \u2014 Microsoft Access<\/h2>\n<h4>Vai Access ir iek\u013cauts Office Home &#038; Student versij\u0101?<\/h4>\n<p>N\u0113. Access ir iek\u013cauts tikai <strong>Office Professional Plus<\/strong> un <strong>Microsoft 365 Business\/Enterprise<\/strong> versij\u0101s.<\/p>\n<h4>Vai Access ir pieejams Mac datoriem?<\/h4>\n<p>N\u0113. Microsoft Access ir pieejams tikai Windows videi. Mac dator\u0101 k\u0101 alternat\u012bvu varat izmantot FileMaker Pro vai palaist Access Windows virtu\u0101laj\u0101 ma\u0161\u012bn\u0101.<\/p>\n<h4>Vai Access var aizst\u0101t SQL Server?<\/h4>\n<p>Neliel\u0101m datub\u0101z\u0113m (l\u012bdz da\u017eiem desmitiem t\u016bksto\u0161u ierakstu ar nedaudziem vienlaic\u012bgiem lietot\u0101jiem) Access ir lieliski piem\u0113rots. Liel\u0101k\u0101m datub\u0101z\u0113m vai t\u012bmek\u013ca lietojumprogramm\u0101m lab\u0101k noder SQL Server.<\/p>\n<h4>Vai Access datub\u0101zi var koplietot t\u012bkl\u0101?<\/h4>\n<p>J\u0101. Failu .accdb varat ievietot koplietot\u0101 t\u012bkla map\u0113. Lab\u0101kai vair\u0101ku lietot\u0101ju veiktsp\u0113jai atdaliet priek\u0161galu (formas) no aizmugures (datiem).<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft Access: datub\u0101ze ikvienam Microsoft Access ir datub\u0101zu p\u0101rvald\u012bbas sist\u0113ma (DBVS), kas iek\u013cauta Microsoft Office pakotn\u0113. Vair\u0101k nek\u0101 30 gadu t\u0101 pal\u012bdz uz\u0146\u0113mumiem, biedr\u012bb\u0101m un priv\u0101tperson\u0101m veidot, p\u0101rvald\u012bt un vaic\u0101t datub\u0101zes bez padzi\u013cin\u0101t\u0101m SQL programm\u0113\u0161anas zin\u0101\u0161an\u0101m. Pret\u0113ji izplat\u012btajam uzskatam Access nav vienk\u0101r\u0161i uzlabota izkl\u0101jlapa. Tas ir \u012bsts rel\u0101ciju datu p\u0101rvald\u012bbas r\u012bks, kas sp\u0113j apstr\u0101d\u0101t t\u016bksto\u0161iem [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2662,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[379],"tags":[],"class_list":["post-9368","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-guide"],"_links":{"self":[{"href":"https:\/\/euroshopkey.com\/lv\/wp-json\/wp\/v2\/posts\/9368","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/euroshopkey.com\/lv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/euroshopkey.com\/lv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/euroshopkey.com\/lv\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/euroshopkey.com\/lv\/wp-json\/wp\/v2\/comments?post=9368"}],"version-history":[{"count":0,"href":"https:\/\/euroshopkey.com\/lv\/wp-json\/wp\/v2\/posts\/9368\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/euroshopkey.com\/lv\/wp-json\/wp\/v2\/media\/2662"}],"wp:attachment":[{"href":"https:\/\/euroshopkey.com\/lv\/wp-json\/wp\/v2\/media?parent=9368"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/euroshopkey.com\/lv\/wp-json\/wp\/v2\/categories?post=9368"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/euroshopkey.com\/lv\/wp-json\/wp\/v2\/tags?post=9368"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}