{"id":4366,"date":"2023-06-09T11:59:41","date_gmt":"2023-06-09T09:59:41","guid":{"rendered":"https:\/\/controlc.fr\/?post_type=lp_course&#038;p=4366"},"modified":"2025-06-11T09:26:56","modified_gmt":"2025-06-11T07:26:56","slug":"access-perfectionnement-melun-cpf-qualiopi","status":"publish","type":"lp_course","link":"https:\/\/controlc.fr\/index.php\/courses\/access-perfectionnement-melun-cpf-qualiopi\/","title":{"rendered":"ACCESS PERFECTIONNEMENT"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"4366\" class=\"elementor elementor-4366\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2c5c0c41 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2c5c0c41\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-34355a46\" data-id=\"34355a46\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5e49b2df elementor-widget elementor-widget-text-editor\" data-id=\"5e49b2df\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div id=\"detailles-objectif\"><h2 id=\"detailles-objectif\">Programme<\/h2><p><strong>Rappel des connaissances<\/strong><br \/>Conception d\u2019une base de donn\u00e9es relationnelles<br \/>Les relations entre les tables<br \/>L\u2019int\u00e9grit\u00e9 des donn\u00e9es<br \/>Les propri\u00e9t\u00e9s des champs<\/p><p><strong>Les requ\u00eates S\u00e9lection \u2013 Les sous-requ\u00eates<\/strong><br \/>Les fonctions de regroupement<br \/>Les calculs avanc\u00e9s<br \/>Les fonctions VraiFaux, Partition, AjDate, PartDate, <br \/>ExtractCha\u00eene, DansCha\u00eene, etc.<\/p><p><strong>Les requ\u00eates actions et analyses crois\u00e9es<\/strong><br \/>Requ\u00eate Ajout de donn\u00e9es<br \/>Requ\u00eate Suppression de donn\u00e9es<br \/>Requ\u00eate Mise \u00e0 jour<br \/>Requ\u00eate Cr\u00e9ation de tables<br \/>Analyse crois\u00e9e<br \/>Le SQL<br \/>Le langage de manipulation des donn\u00e9es<br \/>Les requ\u00eates Union<\/p><p><strong>Les formulaires \u00e9volu\u00e9s<\/strong><br \/>Les types de formulaire<br \/>Utilisation des diff\u00e9rents contr\u00f4les<br \/>Les sous-formulaires<\/p><p><strong>Les macros<\/strong><br \/>Automatiser des actions dans les formulaires<\/p><p><a href=\"https:\/\/www.moncompteformation.gouv.fr\/espace-prive\/html\/#\/formation\/recherche\/37973507900053_Accessperf\/37973507900053_Accessperf?contexteFormation=ACTIVITE_PROFESSIONNELLE\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" class=\"alignnone wp-image-5075 size-thumbnail\" src=\"https:\/\/controlc.fr\/wp-content\/uploads\/2024\/02\/Logo-officiel-cpf-150x150.png\" alt=\"\" width=\"150\" height=\"150\" srcset=\"https:\/\/controlc.fr\/wp-content\/uploads\/2024\/02\/Logo-officiel-cpf-150x150.png 150w, https:\/\/controlc.fr\/wp-content\/uploads\/2024\/02\/Logo-officiel-cpf.png 300w\" sizes=\"(max-width: 150px) 100vw, 150px\" \/><\/a><\/p><\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f2e979f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f2e979f\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-33 elementor-top-column elementor-element elementor-element-b74c8eb\" data-id=\"b74c8eb\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c1a74cf elementor-button-danger elementor-align-center animated-slow elementor-invisible elementor-widget elementor-widget-button\" data-id=\"c1a74cf\" data-element_type=\"widget\" data-settings=\"{&quot;_animation&quot;:&quot;fadeInDown&quot;}\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm\" href=\"https:\/\/controlc.fr\/wp-content\/uploads\/2023\/06\/ACCESS-PERF.pdf\" target=\"_blank\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">La fiche formation<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-33 elementor-top-column elementor-element elementor-element-ce32191\" data-id=\"ce32191\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-99a1f45 elementor-button-info elementor-align-center elementor-widget elementor-widget-button\" data-id=\"99a1f45\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm\" href=\"https:\/\/controlc.fr\/wp-content\/uploads\/2025\/02\/ControlC_Tarifs_pack-office-PAO-DAO_2025.pdf\" target=\"_blank\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">Nos tarifs<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-33 elementor-top-column elementor-element elementor-element-716c061\" data-id=\"716c061\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4924622 elementor-align-center elementor-widget elementor-widget-button\" data-id=\"4924622\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm\" href=\"https:\/\/controlc.fr\/wp-content\/uploads\/2024\/10\/ControlC_planning-interentreprises_bureautique_PAO_DAO_2025.pdf\" target=\"_blank\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">Le planning<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Programme Rappel des connaissancesConception d\u2019une base de donn\u00e9es relationnellesLes relations entre les tablesL\u2019int\u00e9grit\u00e9 des donn\u00e9esLes propri\u00e9t\u00e9s des champs Les requ\u00eates S\u00e9lection \u2013 Les sous-requ\u00eatesLes fonctions de regroupementLes calculs avanc\u00e9sLes fonctions VraiFaux, Partition, AjDate, PartDate, ExtractCha\u00eene, DansCha\u00eene, etc. Les requ\u00eates actions et analyses crois\u00e9esRequ\u00eate Ajout de donn\u00e9esRequ\u00eate Suppression de donn\u00e9esRequ\u00eate Mise&hellip;<\/p>\n","protected":false},"author":6,"featured_media":6077,"comment_status":"closed","ping_status":"closed","template":"","course_category":[37,10],"course_tag":[],"class_list":["post-4366","lp_course","type-lp_course","status-publish","has-post-thumbnail","hentry","course_category-base-de-donnees","course_category-bureautique","course"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>ACCESS PERFECTIONNEMENT - formation Melun Access<\/title>\n<meta name=\"description\" content=\"La formation &quot;Perfectionnement ACCESS&quot; dure 3 jours. Vous pourrez vous perfectionner sur le logiciel de base de donn\u00e9es Access. Eligible CPF\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/controlc.fr\/index.php\/courses\/access-perfectionnement-melun-cpf-qualiopi\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ACCESS PERFECTIONNEMENT - formation Melun Access\" \/>\n<meta property=\"og:description\" content=\"La formation &quot;Perfectionnement ACCESS&quot; dure 3 jours. Vous pourrez vous perfectionner sur le logiciel de base de donn\u00e9es Access. Eligible CPF\" \/>\n<meta property=\"og:url\" content=\"https:\/\/controlc.fr\/index.php\/courses\/access-perfectionnement-melun-cpf-qualiopi\/\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-11T07:26:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/controlc.fr\/wp-content\/uploads\/2025\/02\/icons8-ms-access-200.png\" \/>\n\t<meta property=\"og:image:width\" content=\"200\" \/>\n\t<meta property=\"og:image:height\" content=\"200\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@controlcmelun\" \/>\n<meta name=\"twitter:label1\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/controlc.fr\/index.php\/courses\/access-perfectionnement-melun-cpf-qualiopi\/\",\"url\":\"https:\/\/controlc.fr\/index.php\/courses\/access-perfectionnement-melun-cpf-qualiopi\/\",\"name\":\"ACCESS PERFECTIONNEMENT - formation Melun Access\",\"isPartOf\":{\"@id\":\"https:\/\/controlc.fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/controlc.fr\/index.php\/courses\/access-perfectionnement-melun-cpf-qualiopi\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/controlc.fr\/index.php\/courses\/access-perfectionnement-melun-cpf-qualiopi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/controlc.fr\/wp-content\/uploads\/2025\/02\/icons8-ms-access-200.png\",\"datePublished\":\"2023-06-09T09:59:41+00:00\",\"dateModified\":\"2025-06-11T07:26:56+00:00\",\"description\":\"La formation \\\"Perfectionnement ACCESS\\\" dure 3 jours. Vous pourrez vous perfectionner sur le logiciel de base de donn\u00e9es Access. Eligible CPF\",\"breadcrumb\":{\"@id\":\"https:\/\/controlc.fr\/index.php\/courses\/access-perfectionnement-melun-cpf-qualiopi\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/controlc.fr\/index.php\/courses\/access-perfectionnement-melun-cpf-qualiopi\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/controlc.fr\/index.php\/courses\/access-perfectionnement-melun-cpf-qualiopi\/#primaryimage\",\"url\":\"https:\/\/controlc.fr\/wp-content\/uploads\/2025\/02\/icons8-ms-access-200.png\",\"contentUrl\":\"https:\/\/controlc.fr\/wp-content\/uploads\/2025\/02\/icons8-ms-access-200.png\",\"width\":200,\"height\":200,\"caption\":\"MS Access ic\u00f4ne par Icons8\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/controlc.fr\/index.php\/courses\/access-perfectionnement-melun-cpf-qualiopi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/controlc.fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cours\",\"item\":\"https:\/\/controlc.fr\/index.php\/cours-2\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"ACCESS PERFECTIONNEMENT\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/controlc.fr\/#website\",\"url\":\"https:\/\/controlc.fr\/\",\"name\":\"Controlc.fr\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/controlc.fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/controlc.fr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/controlc.fr\/#organization\",\"name\":\"Control^C\",\"url\":\"https:\/\/controlc.fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/controlc.fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/controlc.fr\/wp-content\/uploads\/2020\/12\/cropped-cropped-cropped-logo-melun.png\",\"contentUrl\":\"https:\/\/controlc.fr\/wp-content\/uploads\/2020\/12\/cropped-cropped-cropped-logo-melun.png\",\"width\":427,\"height\":100,\"caption\":\"Control^C\"},\"image\":{\"@id\":\"https:\/\/controlc.fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/x.com\/controlcmelun\",\"https:\/\/www.linkedin.com\/company\/8009384\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"ACCESS PERFECTIONNEMENT - formation Melun Access","description":"La formation \"Perfectionnement ACCESS\" dure 3 jours. Vous pourrez vous perfectionner sur le logiciel de base de donn\u00e9es Access. Eligible CPF","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:\/\/controlc.fr\/index.php\/courses\/access-perfectionnement-melun-cpf-qualiopi\/","og_locale":"fr_FR","og_type":"article","og_title":"ACCESS PERFECTIONNEMENT - formation Melun Access","og_description":"La formation \"Perfectionnement ACCESS\" dure 3 jours. Vous pourrez vous perfectionner sur le logiciel de base de donn\u00e9es Access. Eligible CPF","og_url":"https:\/\/controlc.fr\/index.php\/courses\/access-perfectionnement-melun-cpf-qualiopi\/","article_modified_time":"2025-06-11T07:26:56+00:00","og_image":[{"width":200,"height":200,"url":"https:\/\/controlc.fr\/wp-content\/uploads\/2025\/02\/icons8-ms-access-200.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_site":"@controlcmelun","twitter_misc":{"Dur\u00e9e de lecture estim\u00e9e":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/controlc.fr\/index.php\/courses\/access-perfectionnement-melun-cpf-qualiopi\/","url":"https:\/\/controlc.fr\/index.php\/courses\/access-perfectionnement-melun-cpf-qualiopi\/","name":"ACCESS PERFECTIONNEMENT - formation Melun Access","isPartOf":{"@id":"https:\/\/controlc.fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/controlc.fr\/index.php\/courses\/access-perfectionnement-melun-cpf-qualiopi\/#primaryimage"},"image":{"@id":"https:\/\/controlc.fr\/index.php\/courses\/access-perfectionnement-melun-cpf-qualiopi\/#primaryimage"},"thumbnailUrl":"https:\/\/controlc.fr\/wp-content\/uploads\/2025\/02\/icons8-ms-access-200.png","datePublished":"2023-06-09T09:59:41+00:00","dateModified":"2025-06-11T07:26:56+00:00","description":"La formation \"Perfectionnement ACCESS\" dure 3 jours. Vous pourrez vous perfectionner sur le logiciel de base de donn\u00e9es Access. Eligible CPF","breadcrumb":{"@id":"https:\/\/controlc.fr\/index.php\/courses\/access-perfectionnement-melun-cpf-qualiopi\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/controlc.fr\/index.php\/courses\/access-perfectionnement-melun-cpf-qualiopi\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/controlc.fr\/index.php\/courses\/access-perfectionnement-melun-cpf-qualiopi\/#primaryimage","url":"https:\/\/controlc.fr\/wp-content\/uploads\/2025\/02\/icons8-ms-access-200.png","contentUrl":"https:\/\/controlc.fr\/wp-content\/uploads\/2025\/02\/icons8-ms-access-200.png","width":200,"height":200,"caption":"MS Access ic\u00f4ne par Icons8"},{"@type":"BreadcrumbList","@id":"https:\/\/controlc.fr\/index.php\/courses\/access-perfectionnement-melun-cpf-qualiopi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/controlc.fr\/"},{"@type":"ListItem","position":2,"name":"Cours","item":"https:\/\/controlc.fr\/index.php\/cours-2\/"},{"@type":"ListItem","position":3,"name":"ACCESS PERFECTIONNEMENT"}]},{"@type":"WebSite","@id":"https:\/\/controlc.fr\/#website","url":"https:\/\/controlc.fr\/","name":"Controlc.fr","description":"","publisher":{"@id":"https:\/\/controlc.fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/controlc.fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/controlc.fr\/#organization","name":"Control^C","url":"https:\/\/controlc.fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/controlc.fr\/#\/schema\/logo\/image\/","url":"https:\/\/controlc.fr\/wp-content\/uploads\/2020\/12\/cropped-cropped-cropped-logo-melun.png","contentUrl":"https:\/\/controlc.fr\/wp-content\/uploads\/2020\/12\/cropped-cropped-cropped-logo-melun.png","width":427,"height":100,"caption":"Control^C"},"image":{"@id":"https:\/\/controlc.fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/controlcmelun","https:\/\/www.linkedin.com\/company\/8009384"]}]}},"_links":{"self":[{"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/lp_course\/4366","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/lp_course"}],"about":[{"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/types\/lp_course"}],"author":[{"embeddable":true,"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/comments?post=4366"}],"version-history":[{"count":30,"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/lp_course\/4366\/revisions"}],"predecessor-version":[{"id":6335,"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/lp_course\/4366\/revisions\/6335"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/media\/6077"}],"wp:attachment":[{"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/media?parent=4366"}],"wp:term":[{"taxonomy":"course_category","embeddable":true,"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/course_category?post=4366"},{"taxonomy":"course_tag","embeddable":true,"href":"https:\/\/controlc.fr\/index.php\/wp-json\/wp\/v2\/course_tag?post=4366"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}