{"id":10984,"date":"2023-01-31T20:39:19","date_gmt":"2023-01-31T19:39:19","guid":{"rendered":"https:\/\/www.auditsi.eu\/?p=10984"},"modified":"2023-11-01T19:41:02","modified_gmt":"2023-11-01T18:41:02","slug":"analyse-de-donnees-et-automatisation-avec-excel-et-access-8eme-volet","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=10984","title":{"rendered":"Analyse de donn\u00e9es et automatisation avec Excel et Access (8\u00e8me volet)"},"content":{"rendered":"<p style=\"text-align: justify;\">Les quatre premiers volets de cette formation ont \u00e9t\u00e9 consacr\u00e9s \u00e0 Excel, les trois suivants au langage VBA et l\u2019automatisation. Ce huiti\u00e8me volet propose une d\u00e9couverte du syst\u00e8me de gestion de base de donn\u00e9es relationnelle (SGBDR) ACCESS \u00e9dit\u00e9 par Microsoft.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10995\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/01\/Volet-8-ACCESS.png\" alt=\"Volet 8 ACCESS\" width=\"1058\" height=\"780\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/01\/Volet-8-ACCESS.png 1058w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/01\/Volet-8-ACCESS-300x221.png 300w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/01\/Volet-8-ACCESS-1024x755.png 1024w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/01\/Volet-8-ACCESS-768x566.png 768w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/01\/Volet-8-ACCESS-730x538.png 730w\" sizes=\"auto, (max-width: 1058px) 100vw, 1058px\" \/><\/p>\n<p style=\"text-align: justify;\">Un SGBDR assure la gestion de tables de donn\u00e9es, de leurs relations entre elles et permet l\u2019interrogation de ces tables de donn\u00e9es \u00e0 l\u2019aide d\u2019un langage de requ\u00eates (le langage SQL dans le cas d\u2019ACCESS). ACCESS est dot\u00e9 d\u2019un langage de programmation, le VBA, permettant d\u2019automatiser des t\u00e2ches.<\/p>\n<p style=\"text-align: justify;\">Au programme :<\/p>\n<ul>\n<li style=\"text-align: justify;\">Introduction \u00e0 ACCESS<\/li>\n<li style=\"text-align: justify;\">Rechercher des donn\u00e9es dans une table ou le r\u00e9sultat d\u2019une requ\u00eate<\/li>\n<li style=\"text-align: justify;\">Cr\u00e9er sa premi\u00e8re requ\u00eate<\/li>\n<li style=\"text-align: justify;\">Copier le contenu d\u2019une table (ou le r\u00e9sultat d\u2019une requ\u00eate) vers Excel<\/li>\n<li style=\"text-align: justify;\">Exporter le contenu d\u2019une table (ou le r\u00e9sultat d\u2019une requ\u00eate) vers Excel<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Une base de donn\u00e9es (BDD) ACCESS comporte principalement trois types d\u2019objets :<\/p>\n<ul>\n<li style=\"text-align: justify;\">Des tables : une table stocke des donn\u00e9es organis\u00e9es de mani\u00e8re homog\u00e8ne ; une table comprend des enregistrements (lignes) compos\u00e9s de champs de donn\u00e9es (colonne)<\/li>\n<li style=\"text-align: justify;\">Des requ\u00eates : instructions permettant une recherche dans une base de donn\u00e9es<\/li>\n<li style=\"text-align: justify;\">Du code VBA<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Le support de formation est t\u00e9l\u00e9chargeable ci-apr\u00e8s.<\/p>\n<p style=\"text-align: justify;\">Le prochain volet s&#8217;attaque aux requ\u00eates SQL.<\/p>\n<p style=\"text-align: justify;\">___<\/p>\n<p style=\"text-align: justify;\">Retrouver&nbsp;<a href=\"https:\/\/www.auditsi.eu\/?cat=2765\">tous les volets de cette s\u00e9rie<\/a> d\u00e9di\u00e9e \u00e0 l\u2019analyse de donn\u00e9es et \u00e0 l\u2019automatisation avec Excel et Access<\/p>\n<div id=\"sconnect-is-installed\" style=\"display: none; text-align: justify;\">2.13.0.0<\/div>\n<div id=\"sconnect-is-installed\" style=\"display: none;\">2.13.0.0<\/div>\n<div id=\"sconnect-is-installed\" style=\"display: none;\">2.13.0.0<\/div>\n<div id=\"sconnect-is-installed\" style=\"display: none;\">2.13.0.0<\/div>\n<div id=\"sconnect-is-installed\" style=\"display: none;\">2.13.0.0<\/div>\n<div id=\"sconnect-is-installed\" style=\"display: none;\">2.13.0.0<\/div>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img decoding=\"async\" src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"Analyse%20de%20donn%C3%A9es%20et%20automatisation%20avec%20Excel%20et%20Access%20%288%C3%A8me%20volet%29\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"<p>Les quatre premiers volets de cette formation ont \u00e9t\u00e9 consacr\u00e9s \u00e0 Excel, les trois suivants au langage VBA et l\u2019automatisation. Ce huiti\u00e8me volet propose une d\u00e9couverte du syst\u00e8me de gestion de base de donn\u00e9es relationnelle (SGBDR) ACCESS \u00e9dit\u00e9 par Microsoft. Un SGBDR assure la gestion de tables de donn\u00e9es, de leurs relations entre elles et &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=10984\" class=\"more-link\">Continue reading &lsquo;Analyse de donn\u00e9es et automatisation avec Excel et Access (8\u00e8me volet)&rsquo; &raquo;<\/a><\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"Analyse%20de%20donn%C3%A9es%20et%20automatisation%20avec%20Excel%20et%20Access%20%288%C3%A8me%20volet%29\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"ngg_post_thumbnail":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[2765,641],"tags":[60,1378,2719,682,1643],"class_list":["post-10984","post","type-post","status-publish","format-standard","hentry","category-analyse-de-donnees-et-automatisation-avec-excel-et-access","category-formation-professionnelle","tag-access","tag-export","tag-requete","tag-sgbdr","tag-sql"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_likes_enabled":false,"_links":{"self":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/10984","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=10984"}],"version-history":[{"count":7,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/10984\/revisions"}],"predecessor-version":[{"id":11001,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/10984\/revisions\/11001"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=10984"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=10984"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=10984"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}