{"id":5363,"date":"2023-08-25T00:00:00","date_gmt":"2023-08-25T00:00:00","guid":{"rendered":"https:\/\/tech-lib.eu\/tech\/creating-a-one-to-many-relationship-in-access-2013\/"},"modified":"2023-08-25T00:00:00","modified_gmt":"2023-08-25T00:00:00","slug":"creating-a-one-to-many-relationship-in-access-2013","status":"publish","type":"post","link":"https:\/\/tech-lib.eu\/tech\/creating-a-one-to-many-relationship-in-access-2013\/","title":{"rendered":"Creating a One-to-Many Relationship in Access 2013"},"content":{"rendered":"<div class=\"articlecontent\">\n<div class=\"newlinediv\"><\/div>\n<p> Vztahy maj\u00ed z\u00e1sadn\u00ed v\u00fdznam pro organizaci a propojen\u00ed dat v architektu\u0159e datab\u00e1ze. Access 2013 nab\u00edz\u00ed jednoduch\u00e9 u\u017eivatelsk\u00e9 rozhran\u00ed pro vytv\u00e1\u0159en\u00ed r\u016fzn\u00fdch druh\u016f asociac\u00ed mezi tabulkami. Vztahy typu one-to-many, kdy je jeden z\u00e1znam v jedn\u00e9 tabulce p\u0159i\u0159azen k mnoha z\u00e1znam\u016fm v jin\u00e9 tabulce, pat\u0159\u00ed mezi nejroz\u0161\u00ed\u0159en\u011bj\u0161\u00ed interakce. Tento \u010dl\u00e1nek se bude zab\u00fdvat t\u00edm, jak v aplikaci Access 2013 vytvo\u0159it vztah typu one-to-many, a tak\u00e9 souvisej\u00edc\u00edmi t\u00e9maty, jako jsou vztahy typu many-to-many a vytv\u00e1\u0159en\u00ed vztah\u016f v r\u016fzn\u00fdch iterac\u00edch aplikace Access. <\/p>\n<div class=\"newlinediv\"><\/div>\n<p> Pomoc\u00ed t\u011bchto krok\u016f vytvo\u0159\u00edte v aplikaci Access 2013 vztah typu one-to-many: Kartu N\u00e1stroje datab\u00e1ze najdete tak, \u017ee otev\u0159ete datab\u00e1zi Access a vyberete ji. 2. Chcete-li otev\u0159\u00edt podokno Vztahy, klepn\u011bte na tla\u010d\u00edtko Vztahy. 3. Chcete-li p\u0159idat tabulky, kter\u00e9 chcete vz\u00e1jemn\u011b propojit, klepn\u011bte na mo\u017enost Zobrazit tabulku v podokn\u011b Vztahy. 4. Po rozhodnut\u00ed, kter\u00e9 tabulky vybrat, klikn\u011bte na tla\u010d\u00edtko P\u0159idat. Dialogov\u00e9 okno Zobrazit tabulku by se m\u011blo zav\u0159\u00edt. <\/p>\n<div class=\"newlinediv\"><\/div>\n<p>5. Vybran\u00e9 tabulky se zobraz\u00ed jako pole v okn\u011b Vztahy. P\u0159eta\u017een\u00edm p\u0159esu\u0148te pole prim\u00e1rn\u00edho kl\u00ed\u010de z jedn\u00e9 tabulky do odpov\u00eddaj\u00edc\u00edho pole ciz\u00edho kl\u00ed\u010de v druh\u00e9 tabulce. V\u00fdsledkem je vytvo\u0159en\u00ed vztahu one-to-many mezi ob\u011bma tabulkami. 6. Zobraz\u00ed se dialogov\u00e9 okno Vlastnosti spojen\u00ed. Dejte pozor, abyste za\u0161krtli pol\u00ed\u010dko Enforce Referential Integrity. T\u00edm zajist\u00edte, \u017ee pole ciz\u00edho kl\u00ed\u010de m\u016f\u017ee p\u0159ij\u00edmat pouze spr\u00e1vn\u00e1 data. 7. Chcete-li vytvo\u0159it vztah, klepn\u011bte na mo\u017enost Vytvo\u0159it. <\/p>\n<div class=\"newlinediv\"><\/div>\n<p> Po \u00fasp\u011b\u0161n\u00e9m vytvo\u0159en\u00ed vztahu one-to-many m\u016f\u017eete nyn\u00ed za\u010d\u00edt p\u0159id\u00e1vat data do tabulek. Na platn\u00fd prim\u00e1rn\u00ed kl\u00ed\u010d v tabulce &#8222;jedna&#8220; se d\u00edky vztahu odkazuje pole ciz\u00edho kl\u00ed\u010de v tabulce &#8222;mnoho&#8220;. D\u00edky tomu nedoch\u00e1z\u00ed k tvorb\u011b osi\u0159el\u00fdch z\u00e1znam\u016f a je zachov\u00e1na integrita dat. <\/p>\n<div class=\"newlinediv\"><\/div>\n<p> Odpov\u011b\u010f na n\u00e1sleduj\u00edc\u00ed dotaz: Vytvo\u0159en\u00ed vztahu mnoho-v\u00edce je v programu Access o n\u011bco obt\u00ed\u017en\u011bj\u0161\u00ed. P\u0159esto\u017ee vztahy typu many-to-many nelze v Accessu vytvo\u0159it p\u0159\u00edmo, lze je vytvo\u0159it pomoc\u00ed spojovac\u00ed tabulky. Propojovac\u00ed tabulka slou\u017e\u00ed jako spojovac\u00ed bod mezi dv\u011bma tabulkami a umo\u017e\u0148uje vytv\u00e1\u0159et vztahy mezi mnoha z\u00e1znamy v obou tabulk\u00e1ch. Ciz\u00ed kl\u00ed\u010de v propojovac\u00ed tabulce obsahuj\u00ed odkazy na prim\u00e1rn\u00ed kl\u00ed\u010de v obou p\u0159idru\u017een\u00fdch tabulk\u00e1ch. <\/p>\n<div class=\"newlinediv\"><\/div>\n<p> Vytvo\u0159en\u00ed vztahu mnoho-v\u00edce v aplikaci Access 2007 je toto\u017en\u00e9 jako v aplikaci Access 2013. Pou\u017e\u00edvaj\u00ed se stejn\u00e9 postupy jako d\u0159\u00edve, ale k vytvo\u0159en\u00ed vztahu se pou\u017e\u00edv\u00e1 spojovac\u00ed tabulka. <\/p>\n<div class=\"newlinediv\"><\/div>\n<p> Je d\u016fle\u017eit\u00e9 si uv\u011bdomit, \u017ee Excel je v podstat\u011b tabulkov\u00fd procesor, nikoli syst\u00e9m pro spr\u00e1vu datab\u00e1z\u00ed jako Access. Vestav\u011bn\u00fd n\u00e1stroj pro vytv\u00e1\u0159en\u00ed asociac\u00ed mezi tabulkami je v aplikaci Excel jin\u00fd. Pomoc\u00ed odkaz\u016f na bu\u0148ky a vzorc\u016f v\u0161ak m\u016f\u017eete v aplikaci Excel vytvo\u0159it vztah typu &#8222;jeden k v\u00edce&#8220;. Spojen\u00ed mezi daty v n\u011bkolika tabulk\u00e1ch uvnit\u0159 se\u0161itu aplikace Excel m\u016f\u017eete vytvo\u0159it pomoc\u00ed vyhled\u00e1vac\u00edch funkc\u00ed nebo propojen\u00edm dat ve v\u00edce listech. <\/p>\n<div class=\"newlinediv\"><\/div>\n<p> Z\u00e1v\u011brem lze \u0159\u00edci, \u017ee aplikace Access 2013 umo\u017e\u0148uje snadno vytv\u00e1\u0159et vztahy typu one-to-many. Postupy popsan\u00e9 v tomto \u010dl\u00e1nku v\u00e1m pomohou propojit tabulky a zaru\u010dit integritu dat. A\u010dkoli Access nativn\u011b neumo\u017e\u0148uje vztahy mnoho k mnoha, lze k jejich realizaci pou\u017e\u00edt spojovac\u00ed tabulky. Spojen\u00ed mezi tabulkami v\u0161ak m\u016f\u017eete vytv\u00e1\u0159et i pomoc\u00ed aplikace Excel s vyu\u017eit\u00edm odkaz\u016f na bu\u0148ky a vzorc\u016f, p\u0159esto\u017ee k tomu nem\u00e1 nativn\u00ed mo\u017enosti.<\/p><\/div>\n<div class=\"questions\">\n<div class=\"questionstitle\">FAQ<\/div>\n<div class=\"question\">\n<div class=\"qtitle\"> Jak vytvo\u0159\u00edte vztah many-to-many v aplikaci Power Query?<\/div>\n<p> Pomoc\u00ed t\u011bchto krok\u016f lze v aplikaci Power Query vytvo\u0159it vztah many-to-many: 1. Vstupte do programu Power Query se dv\u011bma tabulkami, kter\u00e9 chcete propojit ve vztahu many-to-many. 2. V editoru Power Query vyberte tabulku, kter\u00e1 bude fungovat jako &#8222;most&#8220; nebo prost\u0159edn\u00edk mezi dv\u011bma prim\u00e1rn\u00edmi tabulkami. 3. Chcete-li p\u0159emos\u0165uj\u00edc\u00ed tabulku duplikovat, pou\u017eijte mo\u017enost &#8222;Duplikovat&#8220; z kontextov\u00e9 nab\u00eddky, kdy\u017e na ni kliknete prav\u00fdm tla\u010d\u00edtkem my\u0161i. 4. Duplikovan\u00e9 tabulce dejte nov\u00fd smyslupln\u00fd n\u00e1zev, nap\u0159\u00edklad &#8222;BridgeTable&#8220;. 5. Z tabulky BridgeTable odstra\u0148te v\u0161echny p\u0159ebyte\u010dn\u00e9 sloupce a ponechte pouze ty, kter\u00e9 budou pou\u017eity pro vztah. <\/p>\n<div class=\"newlinediv\"><\/div>\n<p> 5. Vyberte relevantn\u00ed sloupce, kter\u00e9 budou pou\u017eity pro vztah, a pot\u00e9 rozbalte prim\u00e1rn\u00ed tabulky. Ujist\u011bte se, \u017ee jsou ob\u011b tabulky rozbaleny a \u017ee n\u00e1zvy p\u0159\u00edslu\u0161n\u00fdch sloupc\u016f z\u016fst\u00e1vaj\u00ed stejn\u00e9. 7. Spojte tabulku BridgeTable s ob\u011bma hlavn\u00edmi tabulkami. Vyberte jednu z prim\u00e1rn\u00edch tabulek a pot\u00e9 na kart\u011b Dom\u016f editoru Power Query vyberte tla\u010d\u00edtko &#8222;Slou\u010dit dotazy&#8220;. Jako druhou tabulku, se kterou se m\u00e1 slou\u010dit, vyberte tabulku BridgeTable. V dialogov\u00e9m okn\u011b Slou\u010dit vyberte odpov\u00eddaj\u00edc\u00ed sloupce z ka\u017ed\u00e9 tabulky, kter\u00e9 budou vyu\u017eity pro vztah. V z\u00e1vislosti na sv\u00fdch pot\u0159eb\u00e1ch vyberte spr\u00e1vn\u00fd typ spojen\u00ed (nap\u0159. vnit\u0159n\u00ed spojen\u00ed, lev\u00e9 vn\u011bj\u0161\u00ed spojen\u00ed). Rozbalte slou\u010den\u00e9 sloupce a odstra\u0148te v\u0161echny sloupce nav\u00edc. 10. Slou\u010dte tabulku BridgeTable s druhou hlavn\u00ed tabulkou opakov\u00e1n\u00edm krok\u016f 7-9. Znovu na\u010dt\u011bte datov\u00fd model se zm\u011bn\u011bn\u00fdmi tabulkami v kroku 11. <\/p>\n<div class=\"newlinediv\"><\/div>\n<p> Pou\u017eit\u00edm pomocn\u00e9 tabulky jako propojen\u00ed mezi dv\u011bma prim\u00e1rn\u00edmi tabulkami m\u016f\u017eete v programu Power Query vytvo\u0159it vztah mnoho-v\u00edce podle n\u00e1sleduj\u00edc\u00edch krok\u016f. <\/p>\n<\/div>\n<div class=\"question\">\n<div class=\"qtitle\"> Jak\u00fd je p\u0159\u00edklad vztahu mnoho k jednomu?<\/div>\n<p> Vztah t\u0159\u00eddy a jej\u00edch student\u016f je p\u0159\u00edkladem vztahu mnoho k jednomu. V tomto p\u0159\u00edpad\u011b m\u016f\u017ee b\u00fdt k jedn\u00e9 t\u0159\u00edd\u011b p\u0159ipojeno v\u00edce ne\u017e jeden student. <\/p>\n<\/div>\n<div class=\"question\">\n<div class=\"qtitle\"> Existuje v datab\u00e1zi vztah many-to-one?<\/div>\n<p> V datab\u00e1zi existuje vztah many-to-one. V\u00edce z\u00e1znam\u016f z jedn\u00e9 tabulky m\u016f\u017ee b\u00fdt propojeno s jedn\u00edm z\u00e1znamem v jin\u00e9 tabulce ve spojen\u00ed many-to-one. P\u0159i organizaci a propojov\u00e1n\u00ed dat v rela\u010dn\u00edm syst\u00e9mu spr\u00e1vy datab\u00e1z\u00ed, jako je Access 2013, se tento druh vztahu \u010dasto pou\u017e\u00edv\u00e1. T\u00edm, \u017ee zaji\u0161\u0165uje spr\u00e1vn\u00e9 propojen\u00ed p\u0159\u00edslu\u0161n\u00fdch dat, podporuje integritu dat a umo\u017e\u0148uje efektivn\u00ed spr\u00e1vu dat.<\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Vztahy maj\u00ed z\u00e1sadn\u00ed v\u00fdznam pro organizaci a propojen\u00ed dat v architektu\u0159e datab\u00e1ze. Access 2013 nab\u00edz\u00ed jednoduch\u00e9 u\u017eivatelsk\u00e9 rozhran\u00ed pro vytv\u00e1\u0159en\u00ed r\u016fzn\u00fdch druh\u016f asociac\u00ed mezi tabulkami. Vztahy typu one-to-many, kdy je jeden z\u00e1znam v jedn\u00e9 tabulce p\u0159i\u0159azen k mnoha z\u00e1znam\u016fm v jin\u00e9 tabulce, pat\u0159\u00ed mezi nejroz\u0161\u00ed\u0159en\u011bj\u0161\u00ed interakce. Tento \u010dl\u00e1nek se bude zab\u00fdvat t\u00edm, jak v aplikaci &#8230; <a title=\"Creating a One-to-Many Relationship in Access 2013\" class=\"read-more\" href=\"https:\/\/tech-lib.eu\/tech\/creating-a-one-to-many-relationship-in-access-2013\/\" aria-label=\"\u010c\u00edst v\u00edce o Creating a One-to-Many Relationship in Access 2013\">\u010c\u00edst d\u00e1l<\/a><\/p>\n","protected":false},"author":116,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2168],"tags":[],"class_list":["post-5363","post","type-post","status-publish","format-standard","hentry","category-database-administration"],"_links":{"self":[{"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/posts\/5363","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/users\/116"}],"replies":[{"embeddable":true,"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/comments?post=5363"}],"version-history":[{"count":0,"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/posts\/5363\/revisions"}],"wp:attachment":[{"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/media?parent=5363"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/categories?post=5363"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/tags?post=5363"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}