{"id":1378,"date":"2021-02-28T14:40:20","date_gmt":"2021-02-28T13:40:20","guid":{"rendered":"https:\/\/ssntb.org\/mirozaric\/?p=1378"},"modified":"2021-02-28T14:40:20","modified_gmt":"2021-02-28T13:40:20","slug":"ms-access","status":"publish","type":"post","link":"https:\/\/ssntb.org\/mirozaric\/2021\/02\/28\/ms-access\/","title":{"rendered":"MS ACCESS"},"content":{"rendered":"\n<h3 class=\"wp-block-heading\">Uvod<\/h3>\n\n\n\n<p>Jedan od softverskih paketa na tr\u017ei\u0161tu namjenjen kreiranju baza podataka je MS Access, program iz grupe MS Office. Baza podataka kreirana u ovom programu sastoji se od elemenata koji su prikazani na donjoj ilustraciji.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"592\" height=\"676\" src=\"https:\/\/ssntb.org\/mirozaric\/wp-content\/uploads\/2021\/02\/Slika-18-2.jpg\" alt=\"\" class=\"wp-image-1379\" srcset=\"https:\/\/ssntb.org\/mirozaric\/wp-content\/uploads\/2021\/02\/Slika-18-2.jpg 592w, https:\/\/ssntb.org\/mirozaric\/wp-content\/uploads\/2021\/02\/Slika-18-2-263x300.jpg 263w\" sizes=\"auto, (max-width: 592px) 100vw, 592px\" \/><\/figure>\n\n\n\n<p>Najva\u017eniji dio posla je definicija <strong>tabela<\/strong>, tj pa\u017eljivo prevo\u0111enje relacione \u0161eme dobijene na na\u010din opisan u prethodnom poglavlju u tabele u Access-u. Time se postavljaju \u201etemelji\u201c za izgradnju baze podataka. <\/p>\n\n\n\n<p>Da bi se vr\u0161ila manipulacija podacima na na\u010din svojstven Windows okru\u017eenju, slede\u0107i korak je definicija <strong>formi<\/strong> (obrazaca, prozora). No ovo je jedan od na\u010dina pristupa podacima, koji ne pru\u017ea naro\u010ditu fleksibilnost. <\/p>\n\n\n\n<p>Drugi na\u010din je kori\u0161\u0107enjem<strong> upita <\/strong>koji se mogu definisati i upotrebom SQL jezika (pogledati prethodno poglavlje).<\/p>\n\n\n\n<p>Da bi se dobili trajni ( \u0161tampani ) rezultati rada sa bazom, potrebno je kreirati odgovaraju\u0107e <strong>izve\u0161taje<\/strong> ( reports ). <\/p>\n\n\n\n<p>Ukoliko su pak zahtevi obrade podataka slo\u017eeni i ne mogu se obaviti definicijom prethodnih elemenata potrebno je prije\u0107i na programiranje <strong>modula<\/strong>. Pri tome se koristi <strong>VBA<\/strong> (<em>Visual Basic for Aplications<\/em>). No to ve\u0107 izlazi iz okvira programa predmeta Baze podataka. <\/p>\n\n\n\n<p>Prema tome u nastavku \u0107emo se pozabaviti redom slede\u0107im elementima Access-a: <\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>tabelama, <\/li><li>formama, <\/li><li>upitima i <\/li><li>izve\u0161tajima.<\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Uvod Jedan od softverskih paketa na tr\u017ei\u0161tu namjenjen kreiranju baza podataka je MS Access, program iz grupe MS Office. Baza podataka kreirana u ovom programu sastoji se od elemenata koji su prikazani na donjoj ilustraciji. Najva\u017eniji dio posla je definicija tabela, tj pa\u017eljivo prevo\u0111enje relacione \u0161eme dobijene na na\u010din opisan u prethodnom poglavlju u tabele&hellip; <br \/> <a class=\"button small blue\" href=\"https:\/\/ssntb.org\/mirozaric\/2021\/02\/28\/ms-access\/\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18],"tags":[],"class_list":["post-1378","post","type-post","status-publish","format-standard","hentry","category-18"],"_links":{"self":[{"href":"https:\/\/ssntb.org\/mirozaric\/wp-json\/wp\/v2\/posts\/1378","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ssntb.org\/mirozaric\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ssntb.org\/mirozaric\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ssntb.org\/mirozaric\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ssntb.org\/mirozaric\/wp-json\/wp\/v2\/comments?post=1378"}],"version-history":[{"count":1,"href":"https:\/\/ssntb.org\/mirozaric\/wp-json\/wp\/v2\/posts\/1378\/revisions"}],"predecessor-version":[{"id":1380,"href":"https:\/\/ssntb.org\/mirozaric\/wp-json\/wp\/v2\/posts\/1378\/revisions\/1380"}],"wp:attachment":[{"href":"https:\/\/ssntb.org\/mirozaric\/wp-json\/wp\/v2\/media?parent=1378"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ssntb.org\/mirozaric\/wp-json\/wp\/v2\/categories?post=1378"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ssntb.org\/mirozaric\/wp-json\/wp\/v2\/tags?post=1378"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}