{"id":120,"date":"2021-10-10T20:42:51","date_gmt":"2021-10-10T18:42:51","guid":{"rendered":"http:\/\/declick.be\/?page_id=120"},"modified":"2025-06-17T11:09:40","modified_gmt":"2025-06-17T09:09:40","slug":"access-bases","status":"publish","type":"page","link":"https:\/\/declick.be\/index.php\/access-bases\/","title":{"rendered":"Access bases"},"content":{"rendered":"\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-f392129b-322d-4899-a65e-5a0f45ebd5e4\" href=\"https:\/\/declick.be\/wp-content\/uploads\/2025\/06\/SMA29_Examen.mdb\">_SMA29_Examen<\/a><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2025\/06\/SMA29_Examen.mdb\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-f392129b-322d-4899-a65e-5a0f45ebd5e4\">T\u00e9l\u00e9charger<\/a><\/div>\n\n\n\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-69c869ae-80f5-426b-9d12-61123bdd3abe\" href=\"https:\/\/declick.be\/wp-content\/uploads\/2025\/06\/Excel-ExerciceSup-SMA29.xlsx\">_Excel-ExerciceSup-SMA29<\/a><a href=\"https:\/\/declick.be\/wp-content\/uploads\/2025\/06\/Excel-ExerciceSup-SMA29.xlsx\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-69c869ae-80f5-426b-9d12-61123bdd3abe\">T\u00e9l\u00e9charger<\/a><\/div>\n\n\n\n<p>Le cours de Access bases va mettre en \u00e9vidence les diff\u00e9rents objets d\u2019Access: les tables, les requ\u00eates, les formulaires et les \u00c9tats avec une br\u00e8ve introduction aux relations dans une base de donn\u00e9es et aux macros.<\/p>\n\n\n\n<p>L\u2019\u00e9tude de ces diff\u00e9rents points se fera par l&rsquo;utilisation des supports t\u00e9l\u00e9chargeables d\u00e9crits ci-dessous :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Un syllabus :                         <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/10\/Access20xx.pdf\">Acces2000XX.PDF<\/a>                       <\/li>\n\n\n\n<li>Des exercices se rapportant \u00e0 ce syllabus&nbsp;:\n<ul class=\"wp-block-list\">\n<li>                             <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/10\/EmployesBases.accdb\">EmployesBases.accdb<\/a> : base de donn\u00e9es \u00ab&nbsp;vierge&nbsp;\u00bb de gestion des employ\u00e9s d&rsquo;un centre de formation                         <\/li>\n\n\n\n<li>                             <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/10\/EmployesBases_Solution.accdb\">EmployesBases_solution.accdb<\/a> : solutions des exercices propos\u00e9 dans le syllabus                       <\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Divers exercices de r\u00e9vision et de renforcement sur les th\u00e8mes \u00e9voqu\u00e9s ci-dessus :                         <ul><li>EX03 : requ\u00eates \u00e0 partir de donn\u00e9es concernant la location de livres dans une biblioth\u00e8que et ses fichiers :                             <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/10\/Ex03_Questions.doc\">EX03Questions <\/a>&#8211;                             <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/10\/Ex03_Locations.mdb\">EX03Locations <\/a>&#8211;                             <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/10\/Ex03_LocationsSolutions.mdb\">EX03LocationsSolutions<\/a>                                                    <\/li><li>EX04 : requ\u00eates, publipostage, formulaires et \u00e9tats \u00e0 partir d&rsquo;une liste de restaurants connus et ses fichiers :                             <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/10\/Ex04_Questions.doc\">EX04Questions <\/a>&#8211;                             <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/10\/Ex04_Lettre.docx\">EX04Lettre <\/a>&#8211;                             <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/10\/Ex04_Restaurants.mdb\">EX04Restaurants <\/a>&#8211;                             <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/10\/Ex04_RestaurantsSolution.mdb\">EX04RestaurantsSolutions<\/a>                                                    <\/li><\/ul>\n<ul class=\"wp-block-list\">\n<li>EX05 : requ\u00eate, publipostage, formulaire et \u00e9tat \u00e0 partir d&rsquo;une liste correspondant au classement ATP (association des joueurs de tennis professionnel) datant de janvier 2007. H\u00e9las, depuis Federer a perdu sa premi\u00e8re place. Les                             fichiers sont disponibles ici :                             <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/10\/Ex05_Questions.doc\">EX05Questions <\/a>&#8211;                             <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/10\/Ex05_ATP.mdb\">EX05ATP&nbsp;<\/a>                           <\/li>\n\n\n\n<li>EX06 : cr\u00e9ation de tables, listes, requ\u00eates, formulaires et \u00e9tats pour une base de donn\u00e9es de gestion du stock d&rsquo;une papeterie et ses fichiers :                             <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/10\/Ex06_Questions.doc\">EX06Questions <\/a>&#8211;                             <a href=\"https:\/\/declick.be\/wp-content\/uploads\/2021\/10\/Ex06_Stock.accdb\">EX06Stock<\/a>                                                  <\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p>&#8230;<\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n<\/p>","protected":false},"excerpt":{"rendered":"<p>Le cours de Access bases va mettre en \u00e9vidence les diff\u00e9rents objets d\u2019Access: les tables, les requ\u00eates, les formulaires et les \u00c9tats avec une br\u00e8ve introduction aux relations dans une base de donn\u00e9es et&#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-120","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/pages\/120","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=120"}],"version-history":[{"count":29,"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/pages\/120\/revisions"}],"predecessor-version":[{"id":2049,"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/pages\/120\/revisions\/2049"}],"wp:attachment":[{"href":"https:\/\/declick.be\/index.php\/wp-json\/wp\/v2\/media?parent=120"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}