{"id":1305,"date":"2024-05-27T20:10:13","date_gmt":"2024-05-27T17:10:13","guid":{"rendered":"https:\/\/jelizavetaostapjuk.wordpress.com\/?page_id=1305"},"modified":"2024-05-27T20:10:13","modified_gmt":"2024-05-27T17:10:13","slug":"arvestustoo-andmebaas-movies","status":"publish","type":"page","link":"https:\/\/jelizavetaostapjuk23.thkit.ee\/wp\/eng\/arvestustoo-andmebaas-movies\/","title":{"rendered":"ARVESTUST\u00d6\u00d6: andmebaas MOVIES"},"content":{"rendered":"\n<p><a href=\"https:\/\/support.microsoft.com\/en-us\/office\/use-a-command-button-to-start-an-action-or-a-series-of-actions-c7bf2827-2f3e-42b8-83d6-6c4f0de78990\">MC Access nuppid<\/a><\/p>\n\n\n\n<p>ARVESTUST\u00d6\u00d6: andmebaas MOVIES<\/p>\n\n\n\n<p>K\u00e4sunupu kasutamine on Accessi vorm toimingu v\u00f5i toimingukomplekti k\u00e4ivitamiseks. N\u00e4iteks saate luua k\u00e4sunupu, mis avab teise vormi. K\u00e4sunupu perforatsiooni toimingu tegemiseks kirjutate makro v\u00f5i s\u00fcndmuse protseduuri ja kinnitate selle k\u00e4sunupu atribuudile On Click. Makro saate sisestada ka otse k\u00e4sunupu On Click Propertysse. See v\u00f5imaldab kopeerida k\u00e4sunupu teistesse vormidesse, mis kaotavad nupu funktsionaalsuse.<\/p>\n\n\n\n<p><strong>Tabelid loomine:<\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nCREATE TABLE Person (\n    id COUNTER PRIMARY KEY,\n    person_name TEXT(100),\n    last_name TEXT(100),\n    birth_date DATE\n);\n<\/pre><\/div>\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nCREATE TABLE Picture (\n    id COUNTER PRIMARY KEY,\n    picture_file_name varchar(100),\n    person_id int,\n    FOREIGN KEY (person_id) REFERENCES Person(id)\n);\n<\/pre><\/div>\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nCREATE TABLE Position (\n    id COUNTER PRIMARY KEY,\n    position_name varchar (50),\n    description longtext\n);\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large is-resized wp-duotone-unset-1\"><img decoding=\"async\" src=\"https:\/\/jelizavetaostapjuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/05\/image-49.png?w=1024\" alt=\"\" class=\"wp-image-1310\" style=\"width:681px;height:auto\" \/><\/figure>\n\n\n\n<p>Jne.<\/p>\n\n\n\n<p><strong>K\u00f5ik tabelid on loodud, \u00fchendatud ja t\u00e4idetud:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized wp-duotone-unset-2\"><img decoding=\"async\" src=\"https:\/\/jelizavetaostapjuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/05\/image-57.png?w=1024\" alt=\"\" class=\"wp-image-1325\" style=\"width:982px;height:auto\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-resized wp-duotone-unset-3\"><img decoding=\"async\" src=\"https:\/\/jelizavetaostapjuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/05\/image-51.png?w=1024\" alt=\"\" class=\"wp-image-1314\" style=\"width:1394px;height:auto\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-resized wp-duotone-unset-4\"><img decoding=\"async\" src=\"https:\/\/jelizavetaostapjuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/05\/image-52.png?w=1020\" alt=\"\" class=\"wp-image-1315\" style=\"width:967px;height:auto\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-resized wp-duotone-unset-5\"><img decoding=\"async\" src=\"https:\/\/jelizavetaostapjuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/05\/image-53.png?w=1024\" alt=\"\" class=\"wp-image-1317\" style=\"width:1229px;height:auto\" \/><\/figure>\n\n\n\n<p>Jne.<\/p>\n\n\n\n<p>5 vormi loomine:<\/p>\n\n\n\n<p>Lisa Personi tabelisse uus inimene andmebaas MOVIES<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized wp-duotone-unset-6\"><img decoding=\"async\" src=\"https:\/\/jelizavetaostapjuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/05\/image-54.png?w=1024\" alt=\"\" class=\"wp-image-1319\" style=\"width:1234px;height:auto\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-resized wp-duotone-unset-7\"><img decoding=\"async\" src=\"https:\/\/jelizavetaostapjuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/05\/image-55.png?w=1024\" alt=\"\" class=\"wp-image-1320\" style=\"width:704px;height:auto\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-resized wp-duotone-unset-8\"><img decoding=\"async\" src=\"https:\/\/jelizavetaostapjuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/05\/image-56.png?w=799\" alt=\"\" class=\"wp-image-1322\" style=\"width:724px;height:auto\" \/><\/figure>\n\n\n\n<p>\u00dclej\u00e4\u00e4nud on tehtud samal p\u00f5him\u00f5ttel<\/p>\n\n\n\n<p><strong>5 vormi tehtud<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized wp-duotone-unset-9\"><img decoding=\"async\" src=\"https:\/\/jelizavetaostapjuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/05\/image-58.png?w=266\" alt=\"\" class=\"wp-image-1326\" style=\"width:293px;height:auto\" \/><\/figure>\n\n\n\n<p><strong>Kasutajatunnuse vorm:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized wp-duotone-unset-10\"><img decoding=\"async\" src=\"https:\/\/jelizavetaostapjuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/05\/image-59.png?w=1024\" alt=\"\" class=\"wp-image-1328\" style=\"width:788px;height:auto\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-resized wp-duotone-unset-11\"><img decoding=\"async\" src=\"https:\/\/jelizavetaostapjuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/05\/image-60.png?w=1024\" alt=\"\" class=\"wp-image-1330\" style=\"width:1329px;height:auto\" \/><\/figure>\n\n\n\n<p><strong>Peamen\u00fc\u00fc loomine:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized wp-duotone-unset-12\"><img decoding=\"async\" src=\"https:\/\/jelizavetaostapjuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/05\/image-61.png?w=1024\" alt=\"\" class=\"wp-image-1332\" style=\"width:652px;height:auto\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>MC Access nuppid ARVESTUST\u00d6\u00d6: andmebaas MOVIES K\u00e4sunupu kasutamine on Accessi vorm toimingu v\u00f5i toimingukomplekti k\u00e4ivitamiseks. N\u00e4iteks saate luua k\u00e4sunupu, mis avab teise vormi. K\u00e4sunupu perforatsiooni toimingu tegemiseks kirjutate makro v\u00f5i s\u00fcndmuse protseduuri ja kinnitate selle k\u00e4sunupu atribuudile On Click. Makro saate sisestada ka otse k\u00e4sunupu On Click Propertysse. See v\u00f5imaldab kopeerida k\u00e4sunupu teistesse vormidesse, mis &hellip; <a href=\"https:\/\/jelizavetaostapjuk23.thkit.ee\/wp\/eng\/arvestustoo-andmebaas-movies\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;ARVESTUST\u00d6\u00d6: andmebaas MOVIES&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1305","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>ARVESTUST\u00d6\u00d6: andmebaas MOVIES - Jelizaveta Ostapjuk Portfolio<\/title>\n<meta name=\"description\" content=\"ARVESTUST\u00d6\u00d6: andmebaas MOVIES - tehtud andmebaas MC Acceses. Tehtud andmebaas MC Acesses. Nuppude ja funktsioonide lisamine nendele nuppudele\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jelizavetaostapjuk23.thkit.ee\/wp\/eng\/arvestustoo-andmebaas-movies\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ARVESTUST\u00d6\u00d6: andmebaas MOVIES - Jelizaveta Ostapjuk Portfolio\" \/>\n<meta property=\"og:description\" content=\"ARVESTUST\u00d6\u00d6: andmebaas MOVIES - tehtud andmebaas MC Acceses. Tehtud andmebaas MC Acesses. Nuppude ja funktsioonide lisamine nendele nuppudele\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jelizavetaostapjuk23.thkit.ee\/wp\/eng\/arvestustoo-andmebaas-movies\/\" \/>\n<meta property=\"og:site_name\" content=\"Jelizaveta Ostapjuk Portfolio\" \/>\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=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/jelizavetaostapjuk23.thkit.ee\\\/wp\\\/eng\\\/arvestustoo-andmebaas-movies\\\/\",\"url\":\"https:\\\/\\\/jelizavetaostapjuk23.thkit.ee\\\/wp\\\/eng\\\/arvestustoo-andmebaas-movies\\\/\",\"name\":\"ARVESTUST\u00d6\u00d6: andmebaas MOVIES - Jelizaveta Ostapjuk Portfolio\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/jelizavetaostapjuk23.thkit.ee\\\/wp\\\/eng\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/jelizavetaostapjuk23.thkit.ee\\\/wp\\\/eng\\\/arvestustoo-andmebaas-movies\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/jelizavetaostapjuk23.thkit.ee\\\/wp\\\/eng\\\/arvestustoo-andmebaas-movies\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/jelizavetaostapjuk23.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2024\\\/05\\\/image-49.png?w=1024\",\"datePublished\":\"2024-05-27T17:10:13+00:00\",\"description\":\"ARVESTUST\u00d6\u00d6: andmebaas MOVIES - tehtud andmebaas MC Acceses. Tehtud andmebaas MC Acesses. Nuppude ja funktsioonide lisamine nendele nuppudele\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/jelizavetaostapjuk23.thkit.ee\\\/wp\\\/eng\\\/arvestustoo-andmebaas-movies\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/jelizavetaostapjuk23.thkit.ee\\\/wp\\\/eng\\\/arvestustoo-andmebaas-movies\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/jelizavetaostapjuk23.thkit.ee\\\/wp\\\/eng\\\/arvestustoo-andmebaas-movies\\\/#primaryimage\",\"url\":\"https:\\\/\\\/jelizavetaostapjuk23.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2024\\\/05\\\/image-49.png?w=1024\",\"contentUrl\":\"https:\\\/\\\/jelizavetaostapjuk23.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2024\\\/05\\\/image-49.png?w=1024\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/jelizavetaostapjuk23.thkit.ee\\\/wp\\\/eng\\\/arvestustoo-andmebaas-movies\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/jelizavetaostapjuk23.thkit.ee\\\/wp\\\/eng\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ARVESTUST\u00d6\u00d6: andmebaas MOVIES\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/jelizavetaostapjuk23.thkit.ee\\\/wp\\\/eng\\\/#website\",\"url\":\"https:\\\/\\\/jelizavetaostapjuk23.thkit.ee\\\/wp\\\/eng\\\/\",\"name\":\"Jelizaveta Ostapjuk Portfolio\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/jelizavetaostapjuk23.thkit.ee\\\/wp\\\/eng\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"ARVESTUST\u00d6\u00d6: andmebaas MOVIES - Jelizaveta Ostapjuk Portfolio","description":"ARVESTUST\u00d6\u00d6: andmebaas MOVIES - tehtud andmebaas MC Acceses. Tehtud andmebaas MC Acesses. Nuppude ja funktsioonide lisamine nendele nuppudele","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:\/\/jelizavetaostapjuk23.thkit.ee\/wp\/eng\/arvestustoo-andmebaas-movies\/","og_locale":"en_US","og_type":"article","og_title":"ARVESTUST\u00d6\u00d6: andmebaas MOVIES - Jelizaveta Ostapjuk Portfolio","og_description":"ARVESTUST\u00d6\u00d6: andmebaas MOVIES - tehtud andmebaas MC Acceses. Tehtud andmebaas MC Acesses. Nuppude ja funktsioonide lisamine nendele nuppudele","og_url":"https:\/\/jelizavetaostapjuk23.thkit.ee\/wp\/eng\/arvestustoo-andmebaas-movies\/","og_site_name":"Jelizaveta Ostapjuk Portfolio","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/jelizavetaostapjuk23.thkit.ee\/wp\/eng\/arvestustoo-andmebaas-movies\/","url":"https:\/\/jelizavetaostapjuk23.thkit.ee\/wp\/eng\/arvestustoo-andmebaas-movies\/","name":"ARVESTUST\u00d6\u00d6: andmebaas MOVIES - Jelizaveta Ostapjuk Portfolio","isPartOf":{"@id":"https:\/\/jelizavetaostapjuk23.thkit.ee\/wp\/eng\/#website"},"primaryImageOfPage":{"@id":"https:\/\/jelizavetaostapjuk23.thkit.ee\/wp\/eng\/arvestustoo-andmebaas-movies\/#primaryimage"},"image":{"@id":"https:\/\/jelizavetaostapjuk23.thkit.ee\/wp\/eng\/arvestustoo-andmebaas-movies\/#primaryimage"},"thumbnailUrl":"https:\/\/jelizavetaostapjuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/05\/image-49.png?w=1024","datePublished":"2024-05-27T17:10:13+00:00","description":"ARVESTUST\u00d6\u00d6: andmebaas MOVIES - tehtud andmebaas MC Acceses. Tehtud andmebaas MC Acesses. Nuppude ja funktsioonide lisamine nendele nuppudele","breadcrumb":{"@id":"https:\/\/jelizavetaostapjuk23.thkit.ee\/wp\/eng\/arvestustoo-andmebaas-movies\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jelizavetaostapjuk23.thkit.ee\/wp\/eng\/arvestustoo-andmebaas-movies\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jelizavetaostapjuk23.thkit.ee\/wp\/eng\/arvestustoo-andmebaas-movies\/#primaryimage","url":"https:\/\/jelizavetaostapjuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/05\/image-49.png?w=1024","contentUrl":"https:\/\/jelizavetaostapjuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/05\/image-49.png?w=1024"},{"@type":"BreadcrumbList","@id":"https:\/\/jelizavetaostapjuk23.thkit.ee\/wp\/eng\/arvestustoo-andmebaas-movies\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jelizavetaostapjuk23.thkit.ee\/wp\/eng\/"},{"@type":"ListItem","position":2,"name":"ARVESTUST\u00d6\u00d6: andmebaas MOVIES"}]},{"@type":"WebSite","@id":"https:\/\/jelizavetaostapjuk23.thkit.ee\/wp\/eng\/#website","url":"https:\/\/jelizavetaostapjuk23.thkit.ee\/wp\/eng\/","name":"Jelizaveta Ostapjuk Portfolio","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jelizavetaostapjuk23.thkit.ee\/wp\/eng\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/jelizavetaostapjuk23.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages\/1305","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jelizavetaostapjuk23.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/jelizavetaostapjuk23.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/jelizavetaostapjuk23.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jelizavetaostapjuk23.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/comments?post=1305"}],"version-history":[{"count":0,"href":"https:\/\/jelizavetaostapjuk23.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages\/1305\/revisions"}],"wp:attachment":[{"href":"https:\/\/jelizavetaostapjuk23.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/media?parent=1305"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}