{"id":264,"date":"2025-05-22T07:03:38","date_gmt":"2025-05-22T07:03:38","guid":{"rendered":"https:\/\/www.infomega.ro\/a10a\/?page_id=264"},"modified":"2025-05-22T08:40:03","modified_gmt":"2025-05-22T08:40:03","slug":"m5-t-i-c-l2-baze-de-date-access","status":"publish","type":"page","link":"https:\/\/www.infomega.ro\/a10a\/t-i-c\/m5-t-i-c\/m5-t-i-c-l2-baze-de-date-access\/","title":{"rendered":"M5 T.I.C. L2 Baze de Date Access"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Microsoft Access este un <strong>sistem de gestionare a bazelor de date (DBMS = Database Management System)<\/strong> dezvoltat de Microsoft, care combin\u0103 motorul de baze de date rela\u021bional Microsoft Jet cu o interfa\u021b\u0103 grafic\u0103 \u0219i instrumente de dezvoltare software. Face parte din <strong>pachetul Microsoft 365 Office<\/strong> \u0219i este adesea utilizat pentru crearea bazelor de date simple, bazate pe desktop, pentru aplica\u021bii de dimensiuni mici \u0219i medii.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">O <strong>baz\u0103 de date<\/strong> este <strong>o colec\u021bie organizat\u0103 de date, stocate pe suporturi externe<\/strong> \u0219i gestionate astfel \u00eenc\u00e2t s\u0103 poat\u0103 fi u\u0219or accesate, actualizate \u0219i analizate. Este folosit\u0103 pentru a stoca informa\u021bii \u00eentr-un mod structurat, astfel \u00eenc\u00e2t s\u0103 po\u021bi g\u0103si \u0219i utiliza rapid ceea ce ai nevoie.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">O <strong>baz\u0103 de date<\/strong> este ca un <strong>dosar digital<\/strong> unde se p\u0103streaz\u0103 informa\u021bii despre oameni, obiecte, activit\u0103\u021bi etc., organizate \u00een tabele (similar cu un Excel, dar mai avansat).<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Exemple:<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>O baz\u0103 de date pentru o <strong>\u0219coal\u0103<\/strong> poate con\u021bine tabele cu informa\u021bii despre elevi, profesori, clase, note etc.<\/li>\n\n\n\n<li>O baz\u0103 de date pentru un <strong>magazin<\/strong> poate stoca produse, comenzi, clien\u021bi \u0219i stocuri.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Elemente principale ale unei baze de date rela\u021bionale:<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Tabele<\/strong>: structuri formate din r\u00e2nduri \u0219i coloane (ex: tabelul \u201eElev\u201d)<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>C\u00e2mpuri<\/strong>: coloanele din tabel (ex: Nume, Prenume, Varsta)<\/li>\n\n\n\n<li><strong>\u00cenregistr\u0103ri<\/strong>: r\u00e2ndurile din tabel (ex: un elev)<\/li>\n\n\n\n<li><strong>Chei primare<\/strong>: identificatori unici pentru fiecare r\u00e2nd (ex: ElevID)<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"510\" src=\"https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2025\/05\/relatie1.jpg\" alt=\"\" class=\"wp-image-272\" srcset=\"https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2025\/05\/relatie1.jpg 1024w, https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2025\/05\/relatie1-300x149.jpg 300w, https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2025\/05\/relatie1-768x383.jpg 768w, https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2025\/05\/relatie1-400x199.jpg 400w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">img 1 tabele si relatie<\/figcaption><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Chei externe<\/strong>: leag\u0103 informa\u021bii \u00eentre tabele (ex: ClassID \u00een tabelul Elev)<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"683\" src=\"https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2025\/05\/chei1.jpg\" alt=\"\" class=\"wp-image-273\" srcset=\"https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2025\/05\/chei1.jpg 1024w, https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2025\/05\/chei1-300x200.jpg 300w, https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2025\/05\/chei1-768x512.jpg 768w, https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2025\/05\/chei1-400x267.jpg 400w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">img 2 rela\u021bie 1 la mai multi<\/figcaption><\/figure>\n<\/div>\n\n\n<h3 class=\"wp-block-heading\">Ce po\u021bi face cu o baz\u0103 de date?<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Ad\u0103uga<\/strong> date (ex: un nou elev)<\/li>\n\n\n\n<li><strong>C\u0103uta<\/strong> date (ex: elevii din clasa a IX-a)<\/li>\n\n\n\n<li><strong>Actualiza<\/strong> informa\u021bii (ex: schimbi dirigintele)<\/li>\n\n\n\n<li><strong>\u0218terge<\/strong> date (ex: un elev care s-a transferat)<\/li>\n\n\n\n<li><strong>Genera rapoarte \u0219i statistici<\/strong><\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Caracteristici principale Access:<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Tabele<\/strong>: Stocheaz\u0103 date \u00een r\u00e2nduri \u0219i coloane (similar cu Excel, dar \u00eentr-un mod rela\u021bional).<\/li>\n\n\n\n<li><strong>Interog\u0103ri (Queries)<\/strong>: Extrag, filtreaz\u0103 \u0219i analizeaz\u0103 datele folosind SQL sau un designer vizual.<\/li>\n\n\n\n<li><strong>Formulare (Forms)<\/strong>: Interfe\u021be personalizate pentru introducerea \u0219i navigarea datelor.<\/li>\n\n\n\n<li><strong>Rapoarte (Reports)<\/strong>: Formate preg\u0103tite pentru tip\u0103rire, pentru rezumarea sau prezentarea datelor.<\/li>\n\n\n\n<li><strong>Macrocomenzi (Macros)<\/strong>: Automatizeaz\u0103 sarcinile folosind logic\u0103 predefinit\u0103.<\/li>\n\n\n\n<li><strong>VBA (Visual Basic for Applications)<\/strong>: Limbaj de programare pentru crearea de logic\u0103 avansat\u0103 sau interfe\u021be personalizate.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Utiliz\u0103ri comune Access:<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Urm\u0103rirea clien\u021bilor sau a stocurilor \u00eentr-o mic\u0103 afacere<\/li>\n\n\n\n<li>Aplica\u021bii desktop care necesit\u0103 stocare local\u0103 a datelor<\/li>\n\n\n\n<li>Instrumente interne pentru departamente (HR, financiar, logistic\u0103)<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Avantaje Access:<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>U\u0219or de utilizat pentru \u00eencep\u0103tori<\/li>\n\n\n\n<li>Se integreaz\u0103 bine cu alte produse Microsoft<\/li>\n\n\n\n<li>Dezvoltare rapid\u0103 cu formulare \u0219i rapoarte<\/li>\n\n\n\n<li>Potrivit pentru accesul de c\u0103tre un singur utilizator sau echipe mici<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Dezavantaje Access:<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Nu este ideal pentru aplica\u021bii la scar\u0103 mare sau bazate pe web<\/li>\n\n\n\n<li>Probleme de performan\u021b\u0103 cu seturi mari de date<\/li>\n\n\n\n<li>Suport limitat pentru mai mul\u021bi utilizatori comparativ cu sisteme precum SQL Server sau MySQL<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Exemplu de baz\u0103 de date \u00een Access<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Un exemplu de baz\u0103 de date foarte simpl\u0103 \u00een Microsoft Access cu dou\u0103 tabele \u2013 <strong>Elev<\/strong> \u0219i <strong>Clas\u0103<\/strong> \u2013 \u0219i o interogare care le leag\u0103.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">1. <strong>Tabelul \u201eClas\u0103\u201d<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Acest tabel con\u021bine informa\u021bii despre clasele dintr-o \u0219coal\u0103.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>IDClasa (cheie primar\u0103)<\/th><th>NumeClasa<\/th><th>ProfesorDiriginte<\/th><\/tr><\/thead><tbody><tr><td>1<\/td><td>IX C<\/td><td>Popescu Andrei<\/td><\/tr><tr><td>2<\/td><td>X B<\/td><td>Ionescu Maria<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">2. <strong>Tabelul \u201eElev\u201d<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Acest tabel con\u021bine informa\u021bii despre elevi, fiecare fiind asociat cu o clas\u0103.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>IDElev (cheie primar\u0103)<\/th><th>NumeElev<\/th><th>Varsta<\/th><th>IDClasa (cheie extern\u0103)<\/th><\/tr><\/thead><tbody><tr><td>1<\/td><td>Mihai Georgescu<\/td><td>15<\/td><td>1<\/td><\/tr><tr><td>2<\/td><td>Ana Ionescu<\/td><td>16<\/td><td>2<\/td><\/tr><tr><td>3<\/td><td>Vlad Popa<\/td><td>15<\/td><td>1<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">3. <strong>Rela\u021bia \u00eentre tabele<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Tabelul \u201eElev\u201d are o <strong>cheie extern\u0103<\/strong> <code>IDClasa<\/code>, care face leg\u0103tura cu <code>IDClasa<\/code> din tabelul \u201eClas\u0103\u201d.<\/li>\n\n\n\n<li>Creeaz\u0103 aceast\u0103 rela\u021bie \u00een Access folosind op\u021biunea <strong>Database Tools &gt; Relationships<\/strong>.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">4. <strong>Interogare: Elevi cu detalii despre clas\u0103<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Aceast\u0103 interogare va combina informa\u021biile din ambele tabele pentru a afi\u0219a numele elevilor, v\u00e2rsta lor, clasa \u0219i dirigintele.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Cod SQL<\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT Elev.NumeElev, Elev.Varsta, Clasa.NumeClasa, Clasa.ProfesorDiriginte\nFROM Elev\nINNER JOIN Clasa ON Elev.IDClasa = Clasa.IDClasa;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Pa\u0219i \u00een Access:<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Deschide Microsoft Access \u0219i creeaz\u0103 o baz\u0103 de date nou\u0103.<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2025\/05\/001-1024x576.jpg\" alt=\"\" class=\"wp-image-276\" srcset=\"https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2025\/05\/001-1024x576.jpg 1024w, https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2025\/05\/001-300x169.jpg 300w, https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2025\/05\/001-768x432.jpg 768w, https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2025\/05\/001-1536x864.jpg 1536w, https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2025\/05\/001-400x225.jpg 400w, https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2025\/05\/001.jpg 1920w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">img 1 creare baza de date<\/figcaption><\/figure>\n<\/div>\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"603\" height=\"287\" src=\"https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2025\/05\/002.jpg\" alt=\"\" class=\"wp-image-277\" srcset=\"https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2025\/05\/002.jpg 603w, https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2025\/05\/002-300x143.jpg 300w, https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2025\/05\/002-400x190.jpg 400w\" sizes=\"auto, (max-width: 603px) 100vw, 603px\" \/><figcaption class=\"wp-element-caption\">img 2 denume\u0219te baza de date \u0219i clic pe butonul creare<\/figcaption><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>Creeaz\u0103 tabelul <strong>Clas\u0103<\/strong> cu c\u00e2mpurile: <code>IDClasa<\/code> (AutoNumber, cheie primar\u0103), <code>NumeClasa<\/code> (Text), <code>ProfesorDiriginte<\/code> (Text).<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"262\" height=\"118\" src=\"https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2025\/05\/003.jpg\" alt=\"\" class=\"wp-image-278\"\/><figcaption class=\"wp-element-caption\">img 3 alege modul de vizualizare Proiect \u0219i redenume\u0219te Tabel1 cu Clas\u0103<\/figcaption><\/figure>\n<\/div>\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"858\" height=\"488\" src=\"https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2025\/05\/004.jpg\" alt=\"\" class=\"wp-image-279\" srcset=\"https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2025\/05\/004.jpg 858w, https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2025\/05\/004-300x171.jpg 300w, https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2025\/05\/004-768x437.jpg 768w, https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2025\/05\/004-400x228.jpg 400w\" sizes=\"auto, (max-width: 858px) 100vw, 858px\" \/><figcaption class=\"wp-element-caption\">img 4 Modul de vizualizare Proiect al tabelului Clas\u0103<\/figcaption><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>Creeaz\u0103 tabelul <strong>Elev<\/strong> cu c\u00e2mpurile: <code>IDElev<\/code> (AutoNumber, cheie primar\u0103), <code>NumeElev<\/code> (Text), <code>Varsta<\/code> (Number), <code>IDClasa<\/code> (Number &#8211; rela\u021bie).<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"654\" height=\"308\" src=\"https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2025\/05\/005.jpg\" alt=\"\" class=\"wp-image-280\" style=\"width:729px;height:auto\" srcset=\"https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2025\/05\/005.jpg 654w, https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2025\/05\/005-300x141.jpg 300w, https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2025\/05\/005-400x188.jpg 400w\" sizes=\"auto, (max-width: 654px) 100vw, 654px\" \/><figcaption class=\"wp-element-caption\">img 5 Ad\u0103ug\u0103m un nou tabel cu numele Elev execut\u00e2nd pa\u0219ii dinainte. <\/figcaption><\/figure>\n<\/div>\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"704\" height=\"443\" src=\"https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2025\/05\/006.jpg\" alt=\"\" class=\"wp-image-281\" srcset=\"https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2025\/05\/006.jpg 704w, https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2025\/05\/006-300x189.jpg 300w, https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2025\/05\/006-400x252.jpg 400w\" sizes=\"auto, (max-width: 704px) 100vw, 704px\" \/><figcaption class=\"wp-element-caption\">img 6 Tabela Elev in modul de vizualizare Proiect.<\/figcaption><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>Introdu c\u00e2teva date manual. Ad\u0103ugarea datelor se face \u00een modul de vizualizare Foaie de Date. <\/li>\n\n\n\n<li>Creeaz\u0103 rela\u021bia \u00eentre <code>Elev.IDClasa<\/code> \u0219i <code>Clasa.IDClasa<\/code>.\n<ul class=\"wp-block-list\">\n<li>Creeaz\u0103 aceast\u0103 rela\u021bie \u00een Access folosind op\u021biunea <strong>Database Tools &gt; Relationships<\/strong>.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"474\" src=\"https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2025\/05\/007-1024x474.jpg\" alt=\"\" class=\"wp-image-282\" srcset=\"https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2025\/05\/007-1024x474.jpg 1024w, https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2025\/05\/007-300x139.jpg 300w, https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2025\/05\/007-768x355.jpg 768w, https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2025\/05\/007-400x185.jpg 400w, https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2025\/05\/007.jpg 1144w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">img 7 Proiectarea rela\u021biei.<\/figcaption><\/figure>\n<\/div>\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"558\" height=\"230\" src=\"https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2025\/05\/008.jpg\" alt=\"\" class=\"wp-image-283\" srcset=\"https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2025\/05\/008.jpg 558w, https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2025\/05\/008-300x124.jpg 300w, https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2025\/05\/008-400x165.jpg 400w\" sizes=\"auto, (max-width: 558px) 100vw, 558px\" \/><figcaption class=\"wp-element-caption\">img 8 Rela\u021bia 1 la mai multi adic\u0103 \u00eentr-o clas\u0103 sunt mai mul\u021bi elevi<\/figcaption><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>Creeaz\u0103 o interogare nou\u0103 \u0219i folose\u0219te SQL-ul de mai sus sau adaug\u0103 tabelele \u0219i trage c\u00e2mpurile \u00een vizualizarea design.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Tem\u0103:<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">S\u0103 se realizeze o baz\u0103 de date Access cu dou\u0103 tabele \u00eentre care este o rela\u021bie 1 la mai mul\u021bi \u0219i maxim 5 \u00eenregistr\u0103ri pe tabel.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft Access este un sistem de gestionare a bazelor de date (DBMS = Database Management System) dezvoltat de Microsoft, care combin\u0103 motorul de baze de date rela\u021bional Microsoft Jet cu o interfa\u021b\u0103 grafic\u0103 \u0219i instrumente de dezvoltare software. Face parte din pachetul Microsoft 365 Office \u0219i este adesea utilizat pentru crearea bazelor de date simple, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":231,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_FSMCFIC_featured_image_caption":"","_FSMCFIC_featured_image_nocaption":"","_FSMCFIC_featured_image_hide":"","footnotes":""},"class_list":["post-264","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>M5 T.I.C. L2 Baze de Date Access - Clasa a X-a InfoMega<\/title>\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.infomega.ro\/a10a\/t-i-c\/m5-t-i-c\/m5-t-i-c-l2-baze-de-date-access\/\" \/>\n<meta property=\"og:locale\" content=\"ro_RO\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"M5 T.I.C. L2 Baze de Date Access - Clasa a X-a InfoMega\" \/>\n<meta property=\"og:description\" content=\"Microsoft Access este un sistem de gestionare a bazelor de date (DBMS = Database Management System) dezvoltat de Microsoft, care combin\u0103 motorul de baze de date rela\u021bional Microsoft Jet cu o interfa\u021b\u0103 grafic\u0103 \u0219i instrumente de dezvoltare software. Face parte din pachetul Microsoft 365 Office \u0219i este adesea utilizat pentru crearea bazelor de date simple, [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.infomega.ro\/a10a\/t-i-c\/m5-t-i-c\/m5-t-i-c-l2-baze-de-date-access\/\" \/>\n<meta property=\"og:site_name\" content=\"Clasa a X-a InfoMega\" \/>\n<meta property=\"article:modified_time\" content=\"2025-05-22T08:40:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2025\/05\/relatie1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"510\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Timp estimat pentru citire\" \/>\n\t<meta name=\"twitter:data1\" content=\"7 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.infomega.ro\\\/a10a\\\/t-i-c\\\/m5-t-i-c\\\/m5-t-i-c-l2-baze-de-date-access\\\/\",\"url\":\"https:\\\/\\\/www.infomega.ro\\\/a10a\\\/t-i-c\\\/m5-t-i-c\\\/m5-t-i-c-l2-baze-de-date-access\\\/\",\"name\":\"M5 T.I.C. L2 Baze de Date Access - Clasa a X-a InfoMega\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.infomega.ro\\\/a10a\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.infomega.ro\\\/a10a\\\/t-i-c\\\/m5-t-i-c\\\/m5-t-i-c-l2-baze-de-date-access\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.infomega.ro\\\/a10a\\\/t-i-c\\\/m5-t-i-c\\\/m5-t-i-c-l2-baze-de-date-access\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.infomega.ro\\\/a10a\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2025\\\/05\\\/relatie1.jpg\",\"datePublished\":\"2025-05-22T07:03:38+00:00\",\"dateModified\":\"2025-05-22T08:40:03+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.infomega.ro\\\/a10a\\\/t-i-c\\\/m5-t-i-c\\\/m5-t-i-c-l2-baze-de-date-access\\\/#breadcrumb\"},\"inLanguage\":\"ro-RO\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.infomega.ro\\\/a10a\\\/t-i-c\\\/m5-t-i-c\\\/m5-t-i-c-l2-baze-de-date-access\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ro-RO\",\"@id\":\"https:\\\/\\\/www.infomega.ro\\\/a10a\\\/t-i-c\\\/m5-t-i-c\\\/m5-t-i-c-l2-baze-de-date-access\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.infomega.ro\\\/a10a\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2025\\\/05\\\/relatie1.jpg\",\"contentUrl\":\"https:\\\/\\\/www.infomega.ro\\\/a10a\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2025\\\/05\\\/relatie1.jpg\",\"width\":1024,\"height\":510},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.infomega.ro\\\/a10a\\\/t-i-c\\\/m5-t-i-c\\\/m5-t-i-c-l2-baze-de-date-access\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Prima pagin\u0103\",\"item\":\"https:\\\/\\\/www.infomega.ro\\\/a10a\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"T.I.C.\",\"item\":\"https:\\\/\\\/www.infomega.ro\\\/a10a\\\/t-i-c\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"M5 T.I.C.\",\"item\":\"https:\\\/\\\/www.infomega.ro\\\/a10a\\\/t-i-c\\\/m5-t-i-c\\\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"M5 T.I.C. L2 Baze de Date Access\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.infomega.ro\\\/a10a\\\/#website\",\"url\":\"https:\\\/\\\/www.infomega.ro\\\/a10a\\\/\",\"name\":\"Clasa a X-a InfoMega\",\"description\":\"Informa\u021bia a\u0219a cum o po\u021bi imagina\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.infomega.ro\\\/a10a\\\/#\\\/schema\\\/person\\\/9694de2962f527a4ed763694fd74245e\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.infomega.ro\\\/a10a\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ro-RO\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.infomega.ro\\\/a10a\\\/#\\\/schema\\\/person\\\/9694de2962f527a4ed763694fd74245e\",\"name\":\"2nf0\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ro-RO\",\"@id\":\"https:\\\/\\\/www.infomega.ro\\\/a10a\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/11\\\/150colorchanger.png\",\"url\":\"https:\\\/\\\/www.infomega.ro\\\/a10a\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/11\\\/150colorchanger.png\",\"contentUrl\":\"https:\\\/\\\/www.infomega.ro\\\/a10a\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/11\\\/150colorchanger.png\",\"width\":150,\"height\":150,\"caption\":\"2nf0\"},\"logo\":{\"@id\":\"https:\\\/\\\/www.infomega.ro\\\/a10a\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/11\\\/150colorchanger.png\"},\"sameAs\":[\"https:\\\/\\\/www.infomega.ro\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"M5 T.I.C. L2 Baze de Date Access - Clasa a X-a InfoMega","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.infomega.ro\/a10a\/t-i-c\/m5-t-i-c\/m5-t-i-c-l2-baze-de-date-access\/","og_locale":"ro_RO","og_type":"article","og_title":"M5 T.I.C. L2 Baze de Date Access - Clasa a X-a InfoMega","og_description":"Microsoft Access este un sistem de gestionare a bazelor de date (DBMS = Database Management System) dezvoltat de Microsoft, care combin\u0103 motorul de baze de date rela\u021bional Microsoft Jet cu o interfa\u021b\u0103 grafic\u0103 \u0219i instrumente de dezvoltare software. Face parte din pachetul Microsoft 365 Office \u0219i este adesea utilizat pentru crearea bazelor de date simple, [&hellip;]","og_url":"https:\/\/www.infomega.ro\/a10a\/t-i-c\/m5-t-i-c\/m5-t-i-c-l2-baze-de-date-access\/","og_site_name":"Clasa a X-a InfoMega","article_modified_time":"2025-05-22T08:40:03+00:00","og_image":[{"width":1024,"height":510,"url":"https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2025\/05\/relatie1.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Timp estimat pentru citire":"7 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.infomega.ro\/a10a\/t-i-c\/m5-t-i-c\/m5-t-i-c-l2-baze-de-date-access\/","url":"https:\/\/www.infomega.ro\/a10a\/t-i-c\/m5-t-i-c\/m5-t-i-c-l2-baze-de-date-access\/","name":"M5 T.I.C. L2 Baze de Date Access - Clasa a X-a InfoMega","isPartOf":{"@id":"https:\/\/www.infomega.ro\/a10a\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.infomega.ro\/a10a\/t-i-c\/m5-t-i-c\/m5-t-i-c-l2-baze-de-date-access\/#primaryimage"},"image":{"@id":"https:\/\/www.infomega.ro\/a10a\/t-i-c\/m5-t-i-c\/m5-t-i-c-l2-baze-de-date-access\/#primaryimage"},"thumbnailUrl":"https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2025\/05\/relatie1.jpg","datePublished":"2025-05-22T07:03:38+00:00","dateModified":"2025-05-22T08:40:03+00:00","breadcrumb":{"@id":"https:\/\/www.infomega.ro\/a10a\/t-i-c\/m5-t-i-c\/m5-t-i-c-l2-baze-de-date-access\/#breadcrumb"},"inLanguage":"ro-RO","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.infomega.ro\/a10a\/t-i-c\/m5-t-i-c\/m5-t-i-c-l2-baze-de-date-access\/"]}]},{"@type":"ImageObject","inLanguage":"ro-RO","@id":"https:\/\/www.infomega.ro\/a10a\/t-i-c\/m5-t-i-c\/m5-t-i-c-l2-baze-de-date-access\/#primaryimage","url":"https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2025\/05\/relatie1.jpg","contentUrl":"https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2025\/05\/relatie1.jpg","width":1024,"height":510},{"@type":"BreadcrumbList","@id":"https:\/\/www.infomega.ro\/a10a\/t-i-c\/m5-t-i-c\/m5-t-i-c-l2-baze-de-date-access\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Prima pagin\u0103","item":"https:\/\/www.infomega.ro\/a10a\/"},{"@type":"ListItem","position":2,"name":"T.I.C.","item":"https:\/\/www.infomega.ro\/a10a\/t-i-c\/"},{"@type":"ListItem","position":3,"name":"M5 T.I.C.","item":"https:\/\/www.infomega.ro\/a10a\/t-i-c\/m5-t-i-c\/"},{"@type":"ListItem","position":4,"name":"M5 T.I.C. L2 Baze de Date Access"}]},{"@type":"WebSite","@id":"https:\/\/www.infomega.ro\/a10a\/#website","url":"https:\/\/www.infomega.ro\/a10a\/","name":"Clasa a X-a InfoMega","description":"Informa\u021bia a\u0219a cum o po\u021bi imagina","publisher":{"@id":"https:\/\/www.infomega.ro\/a10a\/#\/schema\/person\/9694de2962f527a4ed763694fd74245e"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.infomega.ro\/a10a\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ro-RO"},{"@type":["Person","Organization"],"@id":"https:\/\/www.infomega.ro\/a10a\/#\/schema\/person\/9694de2962f527a4ed763694fd74245e","name":"2nf0","image":{"@type":"ImageObject","inLanguage":"ro-RO","@id":"https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2024\/11\/150colorchanger.png","url":"https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2024\/11\/150colorchanger.png","contentUrl":"https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2024\/11\/150colorchanger.png","width":150,"height":150,"caption":"2nf0"},"logo":{"@id":"https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2024\/11\/150colorchanger.png"},"sameAs":["https:\/\/www.infomega.ro"]}]}},"_links":{"self":[{"href":"https:\/\/www.infomega.ro\/a10a\/wp-json\/wp\/v2\/pages\/264","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.infomega.ro\/a10a\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.infomega.ro\/a10a\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.infomega.ro\/a10a\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.infomega.ro\/a10a\/wp-json\/wp\/v2\/comments?post=264"}],"version-history":[{"count":5,"href":"https:\/\/www.infomega.ro\/a10a\/wp-json\/wp\/v2\/pages\/264\/revisions"}],"predecessor-version":[{"id":286,"href":"https:\/\/www.infomega.ro\/a10a\/wp-json\/wp\/v2\/pages\/264\/revisions\/286"}],"up":[{"embeddable":true,"href":"https:\/\/www.infomega.ro\/a10a\/wp-json\/wp\/v2\/pages\/231"}],"wp:attachment":[{"href":"https:\/\/www.infomega.ro\/a10a\/wp-json\/wp\/v2\/media?parent=264"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}