{"id":511,"date":"2021-06-01T14:12:32","date_gmt":"2021-06-01T12:12:32","guid":{"rendered":"http:\/\/vita.sk.vps202.nameserver.sk\/?post_type=product&#038;p=511"},"modified":"2026-10-23T19:46:45","modified_gmt":"2026-10-23T17:46:45","slug":"online-kurz-microsoft-access-i-zaciatocnik","status":"publish","type":"product","link":"https:\/\/www.vita.sk\/en\/online-kurz-microsoft-access-i-zaciatocnik\/","title":{"rendered":"Online kurz Microsoft Access I. Za\u010diato\u010dn\u00edk"},"content":{"rendered":"<p>Online kurz Microsoft Access I. Za\u010diato\u010dn\u00edk v\u00e1s nau\u010d\u00ed vytv\u00e1ra\u0165 jednoduch\u00e9 rela\u010dn\u00e9 datab\u00e1zy, organizova\u0165 \u00fadaje v tabu\u013ek\u00e1ch a z\u00edskava\u0165 potrebn\u00e9 inform\u00e1cie pomocou dopytov. <strong>Ide o certifikovan\u00fd online kurz na Microsoft Access.<\/strong> Za\u010dneme vysvetlen\u00edm datab\u00e1zov\u00fdch pojmov, aby sme rozumeli rozdielu medzi datab\u00e1zou, tabu\u013ekou, z\u00e1znamom a po\u013eom. Zorientujeme sa v pou\u017e\u00edvate\u013eskom prostred\u00ed, zobrazen\u00ed Backstage a z\u00e1kladn\u00fdch datab\u00e1zov\u00fdch objektoch. Vytvor\u00edme pr\u00e1zdnu datab\u00e1zu a uk\u00e1\u017eeme si, ako navrhova\u0165 jej \u0161trukt\u00faru pod\u013ea inform\u00e1ci\u00ed, ktor\u00e9 potrebujeme evidova\u0165. Kurz je vhodn\u00fd aj bez predch\u00e1dzaj\u00facich sk\u00fasenost\u00ed s datab\u00e1zami alebo programovan\u00edm. Z\u00e1klady si osvoj\u00edme na postupoch vyu\u017eite\u013en\u00fdch pri evidencii z\u00e1kazn\u00edkov, produktov, objedn\u00e1vok \u010di pracovn\u00fdch z\u00e1znamov. D\u00f4raz budeme kl\u00e1s\u0165 na zrozumite\u013en\u00fa organiz\u00e1ciu \u00fadajov a ich \u010fal\u0161ie pou\u017e\u00edvanie.<\/p>\n<p>&nbsp;<\/p>\n<p>Pri n\u00e1vrhu tabuliek budeme definova\u0165 polia, d\u00e1tov\u00e9 typy a prim\u00e1rne k\u013e\u00fa\u010de. Vysvetl\u00edme si, pre\u010do text, \u010d\u00edslo, d\u00e1tum alebo menov\u00e1 hodnota vy\u017eaduj\u00fa vhodn\u00e9 nastavenie a ako k\u013e\u00fa\u010d pom\u00e1ha jednozna\u010dne identifikova\u0165 z\u00e1znam. Nau\u010d\u00edme sa \u00fadaje zad\u00e1va\u0165, upravova\u0165, porovn\u00e1va\u0165, filtrova\u0165 a zora\u010fova\u0165. Prejdeme aj skr\u00fdvan\u00edm st\u013apcov a prisp\u00f4soben\u00edm zobrazenia tabu\u013eky. N\u00e1sledne vytvor\u00edme v\u00fdberov\u00e9 dopyty v n\u00e1vrhovom zobrazen\u00ed a nastav\u00edme krit\u00e9ri\u00e1 na vyh\u013eadanie po\u017eadovan\u00fdch z\u00e1znamov. Pri pr\u00e1ci s v\u00fdrazmi vyu\u017eijeme oper\u00e1tory, d\u00e1tumov\u00e9 podmienky, funkcie a oper\u00e1tor LIKE. Uk\u00e1\u017eeme si tie\u017e zostavova\u010d v\u00fdrazov a spracovanie s\u00fa\u010dtov. Z\u00edskame tak z\u00e1klad na pr\u00edpravu opakovane pou\u017eite\u013en\u00fdch v\u00fdberov \u00fadajov pod\u013ea konkr\u00e9tnej pracovnej ot\u00e1zky, napr\u00edklad pri vyh\u013ead\u00e1van\u00ed polo\u017eiek pod\u013ea n\u00e1zvu alebo zvolen\u00e9ho obdobia.<\/p>\n<p>&nbsp;<\/p>\n<p>V \u010fal\u0161ej \u010dasti online kurz Microsoft Access prepoj\u00edme tabu\u013eky pomocou rel\u00e1ci\u00ed a prim\u00e1rnych a cudz\u00edch k\u013e\u00fa\u010dov. Vysvetl\u00edme si v\u00fdznam d\u00e1tov\u00e9ho modelu, redundancie a z\u00e1kladov normaliz\u00e1cie. Budeme uva\u017eova\u0165 o tom, ktor\u00e9 inform\u00e1cie patria do samostatn\u00fdch tabuliek a ako ich spoji\u0165 bez zbyto\u010dn\u00e9ho opakovania rovnak\u00fdch \u00fadajov. Rozl\u00ed\u0161ime ch\u00fdbaj\u00facu hodnotu Null, nulu a pr\u00e1zdny text. Prejdeme importom a exportom \u00fadajov medzi Accessom, Microsoft Excelom a s\u00fabormi CSV, vr\u00e1tane v\u00fdznamu odde\u013eova\u010dov a d\u00e1tov\u00fdch typov. Obozn\u00e1mime sa aj so z\u00e1lohovan\u00edm a zhutnen\u00edm datab\u00e1zy. V\u00fdsledkom bude schopnos\u0165 navrhn\u00fa\u0165 jednoduch\u00fa evidenciu, vyh\u013ead\u00e1va\u0165 v nej \u00fadaje a pripravi\u0165 ich na \u010fal\u0161ie spracovanie. Ak sa chcete skuto\u010dne nau\u010di\u0165 vytv\u00e1ra\u0165 datab\u00e1zy, navrhova\u0165 tabu\u013eky a pracova\u0165 s dopytmi v Microsoft Access, tak toto je ide\u00e1lny vstupn\u00fd online kurz pre v\u00e1s.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Online kurz Microsoft Access I.","protected":false},"author":4,"featured_media":1163,"comment_status":"open","ping_status":"closed","template":"","meta":{"_acf_changed":false},"product_brand":[],"product_cat":[66,68,73],"product_tag":[2046,2047,2048,2049,187,1235,1670,1671,2028,2044,2045],"class_list":{"0":"post-511","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-online-kurzy-kancelarske-baliky","7":"product_cat-online-kurzy-microsoft-access","8":"product_cat-bez-kategorie","9":"product_tag-databazove-relacie","10":"product_tag-normalizacia-databaz","11":"product_tag-import-a-export-udajov","12":"product_tag-datove-modelovanie","13":"product_tag-kancelarske-baliky","14":"product_tag-microsoft-access","15":"product_tag-relacne-databazy","16":"product_tag-databazove-tabulky","17":"product_tag-databazove-dopyty","18":"product_tag-access-pre-zaciatocnikov","19":"product_tag-primarne-kluce","21":"first","22":"instock","23":"sale","24":"virtual","25":"sold-individually","26":"taxable","27":"purchasable","28":"product-type-simple"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v25.0 (Yoast SEO v25.0) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Online kurz Microsoft Access I. Za\u010diato\u010dn\u00edk 2026 | VITA<\/title>\n<meta name=\"description\" content=\"Online kurz Microsoft Access I. Za\u010diato\u010dn\u00edk v\u00e1s nau\u010d\u00ed vytv\u00e1ra\u0165 datab\u00e1zy, tabu\u013eky, dopyty a rel\u00e1cie aj importova\u0165 \u00fadaje z Excelu a CSV. \u2705\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.vita.sk\/online-kurz-microsoft-access-i-zaciatocnik\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Online kurz Microsoft Access I. Za\u010diato\u010dn\u00edk\" \/>\n<meta property=\"og:description\" content=\"Online kurz Microsoft Access I. Za\u010diato\u010dn\u00edk v\u00e1s nau\u010d\u00ed vytv\u00e1ra\u0165 datab\u00e1zy, tabu\u013eky, dopyty a rel\u00e1cie aj importova\u0165 \u00fadaje z Excelu a CSV. \u2705\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vita.sk\/online-kurz-microsoft-access-i-zaciatocnik\/\" \/>\n<meta property=\"og:site_name\" content=\"VITA\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/VitaAcademySK\" \/>\n<meta property=\"article:modified_time\" content=\"2026-10-23T17:46:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.vita.sk\/wp-content\/uploads\/2018\/10\/Microsoft-Access-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"360\" \/>\n\t<meta property=\"og:image:height\" content=\"360\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\n\t    \"@context\": \"https:\/\/schema.org\",\n\t    \"@graph\": [\n\t        {\n\t            \"@type\": \"WebPage\",\n\t            \"@id\": \"https:\/\/www.vita.sk\/online-kurz-microsoft-access-i-zaciatocnik\/\",\n\t            \"url\": \"https:\/\/www.vita.sk\/online-kurz-microsoft-access-i-zaciatocnik\/\",\n\t            \"name\": \"Online kurz Microsoft Access I. Za\u010diato\u010dn\u00edk {Y} | VITA\",\n\t            \"isPartOf\": {\n\t                \"@id\": \"https:\/\/www.vita.sk\/#website\"\n\t            },\n\t            \"primaryImageOfPage\": {\n\t                \"@id\": \"https:\/\/www.vita.sk\/online-kurz-microsoft-access-i-zaciatocnik\/#primaryimage\"\n\t            },\n\t            \"image\": {\n\t                \"@id\": \"https:\/\/www.vita.sk\/online-kurz-microsoft-access-i-zaciatocnik\/#primaryimage\"\n\t            },\n\t            \"thumbnailUrl\": \"https:\/\/www.vita.sk\/wp-content\/uploads\/2018\/10\/Microsoft-Access-1.png\",\n\t            \"datePublished\": \"2021-06-01T12:12:32+00:00\",\n\t            \"dateModified\": \"2026-10-23T17:46:45+00:00\",\n\t            \"description\": \"Online kurz Microsoft Access I. Za\u010diato\u010dn\u00edk v\u00e1s nau\u010d\u00ed vytv\u00e1ra\u0165 datab\u00e1zy, tabu\u013eky, dopyty a rel\u00e1cie aj importova\u0165 \u00fadaje z Excelu a CSV. \u2705\",\n\t            \"breadcrumb\": {\n\t                \"@id\": \"https:\/\/www.vita.sk\/online-kurz-microsoft-access-i-zaciatocnik\/#breadcrumb\"\n\t            },\n\t            \"inLanguage\": \"en-US\",\n\t            \"potentialAction\": [\n\t                {\n\t                    \"@type\": \"ReadAction\",\n\t                    \"target\": [\n\t                        \"https:\/\/www.vita.sk\/online-kurz-microsoft-access-i-zaciatocnik\/\"\n\t                    ]\n\t                }\n\t            ]\n\t        },\n\t        {\n\t            \"@type\": \"ImageObject\",\n\t            \"inLanguage\": \"en-US\",\n\t            \"@id\": \"https:\/\/www.vita.sk\/online-kurz-microsoft-access-i-zaciatocnik\/#primaryimage\",\n\t            \"url\": \"https:\/\/www.vita.sk\/wp-content\/uploads\/2018\/10\/Microsoft-Access-1.png\",\n\t            \"contentUrl\": \"https:\/\/www.vita.sk\/wp-content\/uploads\/2018\/10\/Microsoft-Access-1.png\",\n\t            \"width\": 360,\n\t            \"height\": 360,\n\t            \"caption\": \"Online kurz Microsoft Access\"\n\t        },\n\t        {\n\t            \"@type\": \"BreadcrumbList\",\n\t            \"@id\": \"https:\/\/www.vita.sk\/online-kurz-microsoft-access-i-zaciatocnik\/#breadcrumb\",\n\t            \"itemListElement\": [\n\t                {\n\t                    \"@type\": \"ListItem\",\n\t                    \"position\": 1,\n\t                    \"name\": \"VITA Academy\",\n\t                    \"item\": \"https:\/\/www.vita.sk\/en\/\"\n\t                },\n\t                {\n\t                    \"@type\": \"ListItem\",\n\t                    \"position\": 2,\n\t                    \"name\": \"Shop\",\n\t                    \"item\": \"https:\/\/www.vita.sk\/shop\/\"\n\t                },\n\t                {\n\t                    \"@type\": \"ListItem\",\n\t                    \"position\": 3,\n\t                    \"name\": \"Kancel\u00e1rske Bal\u00edky (Microsoft Office)\",\n\t                    \"item\": \"https:\/\/www.vita.sk\/online-kurzy-kancelarske-baliky\/\"\n\t                },\n\t                {\n\t                    \"@type\": \"ListItem\",\n\t                    \"position\": 4,\n\t                    \"name\": \"Microsoft Access\",\n\t                    \"item\": \"https:\/\/www.vita.sk\/online-kurzy-microsoft-access\/\"\n\t                },\n\t                {\n\t                    \"@type\": \"ListItem\",\n\t                    \"position\": 5,\n\t                    \"name\": \"Online kurz Microsoft Access I. Za\u010diato\u010dn\u00edk\"\n\t                }\n\t            ]\n\t        },\n\t        {\n\t            \"@type\": \"WebSite\",\n\t            \"@id\": \"https:\/\/www.vita.sk\/#website\",\n\t            \"url\": \"https:\/\/www.vita.sk\/\",\n\t            \"name\": \"VITA Academy - Online Kurzy a \u0160kolenia\",\n\t            \"description\": \"\",\n\t            \"publisher\": {\n\t                \"@id\": \"https:\/\/www.vita.sk\/#organization\"\n\t            },\n\t            \"potentialAction\": [\n\t                {\n\t                    \"@type\": \"SearchAction\",\n\t                    \"target\": {\n\t                        \"@type\": \"EntryPoint\",\n\t                        \"urlTemplate\": \"https:\/\/www.vita.sk\/?s={search_term_string}\"\n\t                    },\n\t                    \"query-input\": {\n\t                        \"@type\": \"PropertyValueSpecification\",\n\t                        \"valueRequired\": true,\n\t                        \"valueName\": \"search_term_string\"\n\t                    }\n\t                }\n\t            ],\n\t            \"inLanguage\": \"en-US\"\n\t        },\n\t        {\n\t            \"email\": \"admin@vita.sk\",\n\t            \"logo\": \"https:\/\/www.vita.sk\/img\/vita_logo.png \",\n\t            \"address\": {\n\t                \"type\": \"PostalAddress\",\n\t                \"streetAddress\": \"Tom\u00e1\u0161ikova 50\/A\",\n\t                \"addressLocality\": \"Bratislava\",\n\t                \"postalCode\": \"83104\",\n\t                \"addressCountry\": {\n\t                    \"name\": \"SK\",\n\t                    \"type\": \"Country\"\n\t                }\n\t            },\n\t            \"contactPoint\": {\n\t                \"type\": \"ContactPoint\",\n\t                \"telephone\": \"+421 907 375\u00a0543\",\n\t                \"Email\": \"admin@vita.sk\",\n\t                \"contactType\": \"customer service\"\n\t            },\n\t            \"sameAs\": [\n\t                \"https:\/\/www.facebook.com\/VitaAcademySK\/\",\n\t                \"https:\/\/www.linkedin.com\/company\/vita-academy\/\"\n\t            ]\n\t        }\n\t    ]\n\t}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Online kurz Microsoft Access I. Za\u010diato\u010dn\u00edk 2026 | VITA","description":"Online kurz Microsoft Access I. Za\u010diato\u010dn\u00edk v\u00e1s nau\u010d\u00ed vytv\u00e1ra\u0165 datab\u00e1zy, tabu\u013eky, dopyty a rel\u00e1cie aj importova\u0165 \u00fadaje z Excelu a CSV. \u2705","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.vita.sk\/online-kurz-microsoft-access-i-zaciatocnik\/","og_locale":"en_US","og_type":"article","og_title":"Online kurz Microsoft Access I. Za\u010diato\u010dn\u00edk","og_description":"Online kurz Microsoft Access I. Za\u010diato\u010dn\u00edk v\u00e1s nau\u010d\u00ed vytv\u00e1ra\u0165 datab\u00e1zy, tabu\u013eky, dopyty a rel\u00e1cie aj importova\u0165 \u00fadaje z Excelu a CSV. \u2705","og_url":"https:\/\/www.vita.sk\/online-kurz-microsoft-access-i-zaciatocnik\/","og_site_name":"VITA","article_publisher":"https:\/\/www.facebook.com\/VitaAcademySK","article_modified_time":"2026-10-23T17:46:45+00:00","og_image":[{"width":360,"height":360,"url":"https:\/\/www.vita.sk\/wp-content\/uploads\/2018\/10\/Microsoft-Access-1.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.vita.sk\/online-kurz-microsoft-access-i-zaciatocnik\/","url":"https:\/\/www.vita.sk\/online-kurz-microsoft-access-i-zaciatocnik\/","name":"Online kurz Microsoft Access I. Za\u010diato\u010dn\u00edk {Y} | VITA","isPartOf":{"@id":"https:\/\/www.vita.sk\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.vita.sk\/online-kurz-microsoft-access-i-zaciatocnik\/#primaryimage"},"image":{"@id":"https:\/\/www.vita.sk\/online-kurz-microsoft-access-i-zaciatocnik\/#primaryimage"},"thumbnailUrl":"https:\/\/www.vita.sk\/wp-content\/uploads\/2018\/10\/Microsoft-Access-1.png","datePublished":"2021-06-01T12:12:32+00:00","dateModified":"2026-10-23T17:46:45+00:00","description":"Online kurz Microsoft Access I. Za\u010diato\u010dn\u00edk v\u00e1s nau\u010d\u00ed vytv\u00e1ra\u0165 datab\u00e1zy, tabu\u013eky, dopyty a rel\u00e1cie aj importova\u0165 \u00fadaje z Excelu a CSV. \u2705","breadcrumb":{"@id":"https:\/\/www.vita.sk\/online-kurz-microsoft-access-i-zaciatocnik\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vita.sk\/online-kurz-microsoft-access-i-zaciatocnik\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vita.sk\/online-kurz-microsoft-access-i-zaciatocnik\/#primaryimage","url":"https:\/\/www.vita.sk\/wp-content\/uploads\/2018\/10\/Microsoft-Access-1.png","contentUrl":"https:\/\/www.vita.sk\/wp-content\/uploads\/2018\/10\/Microsoft-Access-1.png","width":360,"height":360,"caption":"Online kurz Microsoft Access"},{"@type":"BreadcrumbList","@id":"https:\/\/www.vita.sk\/online-kurz-microsoft-access-i-zaciatocnik\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"VITA Academy","item":"https:\/\/www.vita.sk\/en\/"},{"@type":"ListItem","position":2,"name":"Shop","item":"https:\/\/www.vita.sk\/shop\/"},{"@type":"ListItem","position":3,"name":"Kancel\u00e1rske Bal\u00edky (Microsoft Office)","item":"https:\/\/www.vita.sk\/online-kurzy-kancelarske-baliky\/"},{"@type":"ListItem","position":4,"name":"Microsoft Access","item":"https:\/\/www.vita.sk\/online-kurzy-microsoft-access\/"},{"@type":"ListItem","position":5,"name":"Online kurz Microsoft Access I. Za\u010diato\u010dn\u00edk"}]},{"@type":"WebSite","@id":"https:\/\/www.vita.sk\/#website","url":"https:\/\/www.vita.sk\/","name":"VITA Academy - Online Kurzy a \u0160kolenia","description":"","publisher":{"@id":"https:\/\/www.vita.sk\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.vita.sk\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"email":"admin@vita.sk","logo":"https:\/\/www.vita.sk\/img\/vita_logo.png ","address":{"type":"PostalAddress","streetAddress":"Tom\u00e1\u0161ikova 50\/A","addressLocality":"Bratislava","postalCode":"83104","addressCountry":{"name":"SK","type":"Country"}},"contactPoint":{"type":"ContactPoint","telephone":"+421 907 375\u00a0543","Email":"admin@vita.sk","contactType":"customer service"},"sameAs":["https:\/\/www.facebook.com\/VitaAcademySK\/","https:\/\/www.linkedin.com\/company\/vita-academy\/"]}]}},"acf":[],"_links":{"self":[{"href":"https:\/\/www.vita.sk\/en\/wp-json\/wp\/v2\/product\/511","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vita.sk\/en\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/www.vita.sk\/en\/wp-json\/wp\/v2\/types\/product"}],"author":[{"embeddable":true,"href":"https:\/\/www.vita.sk\/en\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vita.sk\/en\/wp-json\/wp\/v2\/comments?post=511"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.vita.sk\/en\/wp-json\/wp\/v2\/media\/1163"}],"wp:attachment":[{"href":"https:\/\/www.vita.sk\/en\/wp-json\/wp\/v2\/media?parent=511"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/www.vita.sk\/en\/wp-json\/wp\/v2\/product_brand?post=511"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/www.vita.sk\/en\/wp-json\/wp\/v2\/product_cat?post=511"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/www.vita.sk\/en\/wp-json\/wp\/v2\/product_tag?post=511"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}