{"id":122,"date":"2021-10-10T20:42:51","date_gmt":"2021-10-10T18:42:51","guid":{"rendered":"http:\/\/declick.be\/?page_id=122"},"modified":"2022-02-06T17:53:07","modified_gmt":"2022-02-06T16:53:07","slug":"access-avance","status":"publish","type":"page","link":"https:\/\/declick.be\/index.php\/access-avance\/","title":{"rendered":"Access avanc\u00e9"},"content":{"rendered":"\n<p>Ce cours met en \u00e9vidence des notions plus avanc\u00e9es d\u2019Access&nbsp;:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Requ\u00eates actions, propri\u00e9t\u00e9s des jointures dans les requ\u00eates<\/li><li>Formulaires complexes associ\u00e9s \u00e0 plusieurs tables<\/li><li>Automatisation des formulaires par l\u2019utilisation des macros<\/li><li>\u00c9tats et regroupements dans les \u00e9tats<\/li><\/ul>\n\n\n\n<p>Ceci se fera par l\u2019exemple en cr\u00e9ant et utilisant les applications suivantes&nbsp;:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/12\/Ex01_Intro.mdb\">Ex01_Intro.mdb<\/a>\u00a0et <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/12\/Ex01_Intro_corriges.mdb\">Ex01_Intro_corriges.mdb<\/a> : base de donn\u00e9es \u00e0 partir de laquelle sont r\u00e9alis\u00e9s les exercices d\u2019introduction (exercice 01) et ses corrig\u00e9s<\/li><li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/12\/Ex01_Intro_Enonces.pdf\">Ex01_Intro_Enonces.pdf<\/a> et <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/12\/Ex01_Intro_Corriges.pdf\">Ex01_Intro_Corriges.pdf<\/a>\u00a0: \u00e9nonc\u00e9s et corrig\u00e9s des exercices d\u2019introduction<\/li><li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2022\/02\/Ex02_Livres.mdb\">Ex02_Livres.mdb<\/a>, <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2022\/02\/Ex02_Membres.mdb\">Ex02_Membres.mdb<\/a>, <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2022\/02\/Ex02_Locations.mdb\">Ex02_Locations.mdb<\/a> et <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2022\/02\/Ex02_Locations_corriges.mdb\">Ex02_Locations_corriges.mdb<\/a>\u00a0: bases de donn\u00e9es utilis\u00e9es pour l\u2019exercice02 et les corrig\u00e9s s&rsquo;y rapportant. L\u2019application consiste en la r\u00e9alisation d\u2019une base de donn\u00e9es permettant la gestion des locations de livres dans une biblioth\u00e8que<\/li><li><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2022\/02\/Ex02_Access_perf_20xx_def.pdf\">Ex02_Access_perf_20xx_def.pdf<\/a>\u00a0: syllabus contenant le descriptif des exercices et les mises en situation par rapport \u00e0 cette gestion de locations de livres, ainsi que des copies d\u2019\u00e9cran de r\u00e9solution des exercices<\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Ce cours met en \u00e9vidence des notions plus avanc\u00e9es d\u2019Access&nbsp;: Requ\u00eates actions, propri\u00e9t\u00e9s des jointures dans les requ\u00eates Formulaires complexes associ\u00e9s \u00e0 plusieurs tables Automatisation des formulaires par l\u2019utilisation des macros \u00c9tats et regroupements&#46;&#46;&#46;<\/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-122","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/pages\/122","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/comments?post=122"}],"version-history":[{"count":8,"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/pages\/122\/revisions"}],"predecessor-version":[{"id":964,"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/pages\/122\/revisions\/964"}],"wp:attachment":[{"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/media?parent=122"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}