{"id":7477,"date":"2018-08-03T00:47:25","date_gmt":"2018-08-02T22:47:25","guid":{"rendered":"https:\/\/www.auditsi.eu\/?p=7477"},"modified":"2018-08-03T00:47:25","modified_gmt":"2018-08-02T22:47:25","slug":"acceder-a-lenvironnement-de-developpement-vba-daccess","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=7477","title":{"rendered":"Acc\u00e9der \u00e0 l\u2019environnement de d\u00e9veloppement VBA d&#8217;ACCESS"},"content":{"rendered":"<p style=\"text-align: justify;\">VBA (pour Visual Basic for Application) est un langage de programmation puissant qui permet d\u2019automatiser des traitements avec les logiciels de la suite Office de Microsoft (EXCEL, ACCESS, WORD\u2026), d\u2019ajouter de nouvelles fonctions \u00e0&nbsp;ces logiciels&nbsp;et m\u00eame de transf\u00e9rer des donn\u00e9es d\u2019une application \u00e0 l\u2019autre (publipostage Word \u00e0 partir de donn\u00e9es Excel ou ACCESS\u2026). Les possibilit\u00e9s offertes par les d\u00e9veloppements VBA sont sans limite et offrent de nouvelles perspectives \u00e0 l\u2019utilisateur notamment en mati\u00e8re d\u2019analyse de donn\u00e9es.<\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2018\/08\/ACCESS-EDI.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1242\" height=\"510\" class=\"aligncenter size-full wp-image-5196\" alt=\"EDI d'ACCESS\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2018\/08\/ACCESS-EDI.png\"><\/a><\/p>\n<p>Alli\u00e9 \u00e0 ACCESS, VBA traite&nbsp;inlassablement des volumes de donn\u00e9es cons\u00e9quents.<\/p>\n<p style=\"text-align: justify;\">Afin de prendre en main le module Visual Basic, il est n\u00e9cessaire&nbsp;:<\/p>\n<ul>\n<li style=\"text-align: justify;\">De d\u00e9couvrir l\u2019environnement de d\u00e9veloppement VBA&nbsp;(EDI) : ce module, semblable sur l\u2019ensemble des applications de la suite Office, assure l\u2019\u00e9dition des programmes VBA,<\/li>\n<li style=\"text-align: justify;\">De ma\u00eetriser les mots-clefs et la syntaxe du langage,<\/li>\n<li style=\"text-align: justify;\">De comprendre la logique de programmation.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Les deux premiers items sont d\u00e9taill\u00e9s sur ce blog et dans une litt\u00e9rature sp\u00e9cialis\u00e9e tr\u00e8s abondante, le dernier s\u2019acquiert, pour beaucoup, par l\u2019exp\u00e9rience.<\/p>\n<p style=\"text-align: justify;\">L\u2019acc\u00e8s \u00e0 l\u2019environnement de d\u00e9veloppement (EDI) d&#8217;ACCESS s\u2019effectue \u00e0 partir du menu Outils de base de donn\u00e9es du ruban puis Visual Basic :<\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2018\/08\/ACCESS-Outils-BDD.png\"><img loading=\"lazy\" decoding=\"async\" width=\"475\" height=\"120\" class=\"aligncenter size-full wp-image-5196\" alt=\"ACCESS - Menu Outils de base de donn\u00e9es\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2018\/08\/ACCESS-Outils-BDD.png\"><\/a><\/p>\n<p style=\"text-align: justify;\">Le langage VBA d&#8217;ACCESS est le m\u00eame que celui d\u2019Excel, avec quelques sp\u00e9cificit\u00e9s propres \u00e0 la gestion de bases de donn\u00e9es. Par exemple, l&#8217;assertion &#8220;Option Compare Database&#8221; plac\u00e9e au d\u00e9but d&#8217;un programme VBA ACCESS indique que les ordres de tri sont d\u00e9finis par les param\u00e8tres r\u00e9gionaux de la base de donn\u00e9es.&nbsp;<\/p>\n<p style=\"text-align: justify;\">Pour ex\u00e9cuter des requ\u00eates SQL&nbsp;\u00e0 partir d\u2019un programme VBA, il faut activer la biblioth\u00e8que de fonctions &#8220;Microsoft Office Access Database engine Object (ADO)&#8221;&nbsp;; pour ce faire, \u00e0 partir de l\u2019EDI, aller dans le menu Outils puis R\u00e9f\u00e9rences, enfin, cocher la biblioth\u00e8que&nbsp;:<\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2018\/08\/ACCESS-R\u00e9f\u00e9rences.png\"><img loading=\"lazy\" decoding=\"async\" width=\"445\" height=\"364\" class=\"aligncenter size-full wp-image-5196\" alt=\"ACCESS - R\u00e9f\u00e9rences\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2018\/08\/ACCESS-R\u00e9f\u00e9rences.png\"><\/a><\/p>\n<p>Approfondir le sujet : <a href=\"https:\/\/www.auditsi.eu\/?tag=access\">Ma\u00eetriser ACCESS<\/a> \/&nbsp;<a href=\"https:\/\/www.auditsi.eu\/?cat=1569\">Ma\u00eetriser le langage VBA<\/a> \/&nbsp;<a href=\"https:\/\/www.auditsi.eu\/?cat=1820\">Ma\u00eetriser le langage de requ\u00eate SQL<\/a>&nbsp;\/ <a href=\"https:\/\/www.auditsi.eu\/?cat=50\">Analyse de donn\u00e9es<\/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 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=\"Acc%C3%A9der%20%C3%A0%20l%E2%80%99environnement%20de%20d%C3%A9veloppement%20VBA%20d%27ACCESS\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"<p>VBA (pour Visual Basic for Application) est un langage de programmation puissant qui permet d\u2019automatiser des traitements avec les logiciels de la suite Office de Microsoft (EXCEL, ACCESS, WORD\u2026), d\u2019ajouter de nouvelles fonctions \u00e0&nbsp;ces logiciels&nbsp;et m\u00eame de transf\u00e9rer des donn\u00e9es d\u2019une application \u00e0 l\u2019autre (publipostage Word \u00e0 partir de donn\u00e9es Excel ou ACCESS\u2026). Les possibilit\u00e9s &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=7477\" class=\"more-link\">Continue reading &lsquo;Acc\u00e9der \u00e0 l\u2019environnement de d\u00e9veloppement VBA d&#8217;ACCESS&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=\"Acc%C3%A9der%20%C3%A0%20l%E2%80%99environnement%20de%20d%C3%A9veloppement%20VBA%20d%27ACCESS\";<\/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":[1569],"tags":[60,1913,1914,254,1915,1719,1641],"class_list":["post-7477","post","type-post","status-publish","format-standard","hentry","category-programmer-en-vba","tag-access","tag-ado","tag-bibliotheque-de-fonctions","tag-edi","tag-option-compare-database","tag-references","tag-vba"],"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\/7477","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=7477"}],"version-history":[{"count":11,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/7477\/revisions"}],"predecessor-version":[{"id":7490,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/7477\/revisions\/7490"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7477"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=7477"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=7477"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}