{"id":23322,"date":"2025-01-24T11:52:21","date_gmt":"2025-01-24T11:52:21","guid":{"rendered":"https:\/\/abexis.es\/index.php\/product\/access-nivel-avanzado\/"},"modified":"2025-06-16T12:08:00","modified_gmt":"2025-06-16T12:08:00","slug":"access-nivel-avanzado","status":"publish","type":"product","link":"https:\/\/abexis.es\/index.php\/product\/access-nivel-avanzado\/","title":{"rendered":"ACCESS. NIVEL AVANZADO"},"content":{"rendered":"<p>1. OPTIMIZACI\u00d3N DE LA INFORMACI\u00d3N EN ACCESS<br \/>\n  1.1. Tipos de datos de los campos<br \/>\n  1.2. Tama\u00f1o de los campos<br \/>\n  1.3. Formato de los campos<br \/>\n  1.4. M\u00e1scara de entrada de los campos<br \/>\n  1.5. Campos de b\u00fasqueda<br \/>\n  1.6. Relaciones entre tablas<br \/>\n  1.7. Tipos de relaciones<br \/>\n  1.8. Integridad referencial<br \/>\n  1.9. Registros relacionados<br \/>\n  1.10. Modificar relaciones<br \/>\n  1.11. Visualizar e imprimir relaciones<br \/>\n  1.12. Importar datos entre tablas<br \/>\n  1.13. Importar datos desde Microsoft Excel<br \/>\n  1.14. Vincular datos entre tablas<br \/>\n  1.15. Vincular datos desde una hoja de Microsoft Excel<br \/>\n  1.16. Exportar datos a Microsoft Word<br \/>\n  1.17. Exportar datos a Microsoft Excel<br \/>\n  1.18. Combinar correspondencia<br \/>\n  1.19. Compactar y reparar una base de datos<\/p>\n<p>  2. FORMULARIOS E INFORMES<br \/>\n  2.1. Crear formularios mediante el Autoformulario<br \/>\n  2.2. Crear formularios mediante el asistente<br \/>\n  2.3. Agregar campos a un formulario<br \/>\n  2.4. Personalizar un formulario<br \/>\n  2.5. Agregar controles dependientes<br \/>\n  2.6. Agregar cuadros de texto independientes<br \/>\n  2.7. Agregar controles de lista a un formulario<br \/>\n  2.8. Secciones de un formulario<br \/>\n  2.9. Agregar y eliminar filtros en un formulario<br \/>\n  2.10. Crear informes mediante el autoinforme<br \/>\n  2.11. Crear informes mediante el asistente<br \/>\n  2.12. Secciones de un informe<br \/>\n  2.13. Encabezado y pie de un informe<br \/>\n  2.14. Etiquetas de un informe<br \/>\n  2.15. Agregar controles dependientes<br \/>\n  2.16. Agregar cuadros de texto independientes<br \/>\n  2.17. Agrupar registros de un informe<br \/>\n  2.18. Crear un subinforme.<br \/>\n  2.19. Crear un subinforme a partir de otro existente<br \/>\n  2.20. Vincular informes y subinformes<br \/>\n  2.21. Propiedades de un subinforme<\/p>\n<p>  3. CONSULTAS, MACROS E INTERNET<br \/>\n  3.1. Crear consultas de selecci\u00f3n sencillas<br \/>\n  3.2. Crear consultas de tabla de referencias cruzadas<br \/>\n  3.3. Personalizar consultas de tabla de referencias cruzadas<br \/>\n  3.4. Crear una consulta de par\u00e1metros<br \/>\n  3.5. Crear una consulta de acci\u00f3n<br \/>\n  3.6. Crear una consulta de eliminaci\u00f3n<br \/>\n  3.7. Crear una consulta de actualizaci\u00f3n<br \/>\n  3.8. Creaci\u00f3n de filtros a partir de consultas<br \/>\n  3.9. Crear una p\u00e1gina de acceso a datos con autop\u00e1gina<br \/>\n  3.10. Crear una p\u00e1gina de acceso a datos con el asistente<br \/>\n  3.11. Combinar una p\u00e1gina de acceso a datos<br \/>\n  3.12. Agrupar registros<br \/>\n  3.13. Crear un HTML est\u00e1tico<br \/>\n  3.14. Publicar una p\u00e1gina de acceso a datos<br \/>\n  3.15. Formularios e informes como p\u00e1ginas de acceso a datos<br \/>\n  3.16. Modificar una p\u00e1gina de acceso a datos<br \/>\n  3.17. Crear una macro sencilla<br \/>\n  3.18. Abrir y modificar una macro existente<br \/>\n  3.19. Agrupar macros<br \/>\n  3.20. Ejecutar una macro<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Adquirir conocimientos sobre las utilidades avanzadas de Microsoft Access y trabajar con campos, relaciones, importar, vincular y combinar correspondencia.<\/p>\n","protected":false},"featured_media":23320,"template":"","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":""},"product_brand":[],"product_cat":[34],"product_tag":[],"class_list":["post-23322","product","type-product","status-publish","has-post-thumbnail","product_cat-administracion-y-gestion","first","instock","virtual","taxable","purchasable","product-type-simple"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>ACCESS. NIVEL AVANZADO -<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/abexis.es\/index.php\/product\/access-nivel-avanzado\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ACCESS. NIVEL AVANZADO -\" \/>\n<meta property=\"og:description\" content=\"Adquirir conocimientos sobre las utilidades avanzadas de Microsoft Access y trabajar con campos, relaciones, importar, vincular y combinar correspondencia.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/abexis.es\/index.php\/product\/access-nivel-avanzado\/\" \/>\n<meta property=\"og:site_name\" content=\"Formaliser\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-16T12:08:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/abexis.es\/wp-content\/uploads\/2025\/01\/AYG-scaled-e1737924816750.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"2000\" \/>\n\t<meta property=\"og:image:height\" content=\"1737\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/abexis.es\\\/index.php\\\/product\\\/access-nivel-avanzado\\\/\",\"url\":\"https:\\\/\\\/abexis.es\\\/index.php\\\/product\\\/access-nivel-avanzado\\\/\",\"name\":\"ACCESS. NIVEL AVANZADO -\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/abexis.es\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/abexis.es\\\/index.php\\\/product\\\/access-nivel-avanzado\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/abexis.es\\\/index.php\\\/product\\\/access-nivel-avanzado\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/abexis.es\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/AYG-scaled-e1737924816750.jpg\",\"datePublished\":\"2025-01-24T11:52:21+00:00\",\"dateModified\":\"2025-06-16T12:08:00+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/abexis.es\\\/index.php\\\/product\\\/access-nivel-avanzado\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/abexis.es\\\/index.php\\\/product\\\/access-nivel-avanzado\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/abexis.es\\\/index.php\\\/product\\\/access-nivel-avanzado\\\/#primaryimage\",\"url\":\"https:\\\/\\\/abexis.es\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/AYG-scaled-e1737924816750.jpg\",\"contentUrl\":\"https:\\\/\\\/abexis.es\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/AYG-scaled-e1737924816750.jpg\",\"width\":2000,\"height\":1737,\"caption\":\"Mockup computer laptop on wooden table\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/abexis.es\\\/index.php\\\/product\\\/access-nivel-avanzado\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/abexis.es\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cursos\",\"item\":\"https:\\\/\\\/abexis.es\\\/index.php\\\/cursos-online-profesionales-y-subvencionados\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"ACCESS. NIVEL AVANZADO\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/abexis.es\\\/#website\",\"url\":\"https:\\\/\\\/abexis.es\\\/\",\"name\":\"Formaliser\",\"description\":\"Formaci\u00f3n\",\"publisher\":{\"@id\":\"https:\\\/\\\/abexis.es\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/abexis.es\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/abexis.es\\\/#organization\",\"name\":\"Formaliser\",\"url\":\"https:\\\/\\\/abexis.es\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/abexis.es\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/abexis.es\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/cropped-LOGO-web.png\",\"contentUrl\":\"https:\\\/\\\/abexis.es\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/cropped-LOGO-web.png\",\"width\":1000,\"height\":295,\"caption\":\"Formaliser\"},\"image\":{\"@id\":\"https:\\\/\\\/abexis.es\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"ACCESS. NIVEL AVANZADO -","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:\/\/abexis.es\/index.php\/product\/access-nivel-avanzado\/","og_locale":"es_ES","og_type":"article","og_title":"ACCESS. NIVEL AVANZADO -","og_description":"Adquirir conocimientos sobre las utilidades avanzadas de Microsoft Access y trabajar con campos, relaciones, importar, vincular y combinar correspondencia.","og_url":"https:\/\/abexis.es\/index.php\/product\/access-nivel-avanzado\/","og_site_name":"Formaliser","article_modified_time":"2025-06-16T12:08:00+00:00","og_image":[{"width":2000,"height":1737,"url":"https:\/\/abexis.es\/wp-content\/uploads\/2025\/01\/AYG-scaled-e1737924816750.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/abexis.es\/index.php\/product\/access-nivel-avanzado\/","url":"https:\/\/abexis.es\/index.php\/product\/access-nivel-avanzado\/","name":"ACCESS. NIVEL AVANZADO -","isPartOf":{"@id":"https:\/\/abexis.es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/abexis.es\/index.php\/product\/access-nivel-avanzado\/#primaryimage"},"image":{"@id":"https:\/\/abexis.es\/index.php\/product\/access-nivel-avanzado\/#primaryimage"},"thumbnailUrl":"https:\/\/abexis.es\/wp-content\/uploads\/2025\/01\/AYG-scaled-e1737924816750.jpg","datePublished":"2025-01-24T11:52:21+00:00","dateModified":"2025-06-16T12:08:00+00:00","breadcrumb":{"@id":"https:\/\/abexis.es\/index.php\/product\/access-nivel-avanzado\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/abexis.es\/index.php\/product\/access-nivel-avanzado\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/abexis.es\/index.php\/product\/access-nivel-avanzado\/#primaryimage","url":"https:\/\/abexis.es\/wp-content\/uploads\/2025\/01\/AYG-scaled-e1737924816750.jpg","contentUrl":"https:\/\/abexis.es\/wp-content\/uploads\/2025\/01\/AYG-scaled-e1737924816750.jpg","width":2000,"height":1737,"caption":"Mockup computer laptop on wooden table"},{"@type":"BreadcrumbList","@id":"https:\/\/abexis.es\/index.php\/product\/access-nivel-avanzado\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/abexis.es\/"},{"@type":"ListItem","position":2,"name":"Cursos","item":"https:\/\/abexis.es\/index.php\/cursos-online-profesionales-y-subvencionados\/"},{"@type":"ListItem","position":3,"name":"ACCESS. NIVEL AVANZADO"}]},{"@type":"WebSite","@id":"https:\/\/abexis.es\/#website","url":"https:\/\/abexis.es\/","name":"Formaliser","description":"Formaci\u00f3n","publisher":{"@id":"https:\/\/abexis.es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/abexis.es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/abexis.es\/#organization","name":"Formaliser","url":"https:\/\/abexis.es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/abexis.es\/#\/schema\/logo\/image\/","url":"https:\/\/abexis.es\/wp-content\/uploads\/2024\/12\/cropped-LOGO-web.png","contentUrl":"https:\/\/abexis.es\/wp-content\/uploads\/2024\/12\/cropped-LOGO-web.png","width":1000,"height":295,"caption":"Formaliser"},"image":{"@id":"https:\/\/abexis.es\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/abexis.es\/index.php\/wp-json\/wp\/v2\/product\/23322","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/abexis.es\/index.php\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/abexis.es\/index.php\/wp-json\/wp\/v2\/types\/product"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/abexis.es\/index.php\/wp-json\/wp\/v2\/media\/23320"}],"wp:attachment":[{"href":"https:\/\/abexis.es\/index.php\/wp-json\/wp\/v2\/media?parent=23322"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/abexis.es\/index.php\/wp-json\/wp\/v2\/product_brand?post=23322"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/abexis.es\/index.php\/wp-json\/wp\/v2\/product_cat?post=23322"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/abexis.es\/index.php\/wp-json\/wp\/v2\/product_tag?post=23322"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}