{"id":24372,"date":"2025-01-31T01:15:49","date_gmt":"2025-01-31T01:15:49","guid":{"rendered":"https:\/\/abexis.es\/index.php\/product\/microsoft-access-2016-intermedio\/"},"modified":"2025-06-16T12:08:36","modified_gmt":"2025-06-16T12:08:36","slug":"microsoft-access-2016-intermedio","status":"publish","type":"product","link":"https:\/\/abexis.es\/index.php\/product\/microsoft-access-2016-intermedio\/","title":{"rendered":"MICROSOFT ACCESS 2016 (INTERMEDIO)"},"content":{"rendered":"

1. INTRODUCCI\u00d3N Y OBJETIVOS DEL NIVEL INTERMEDIO<\/p>\n

2. PROPIEDADES AVANZADAS DE CAMPO
\n 2.1. Formato
\n 2.2. Formatos personalizados
\n 2.3. M\u00e1scara de entrada
\n 2.4. \u00cdndices<\/p>\n

3. TRABAJO AVANZADO CON DATOS
\n 3.1. Propiedades de los campos en la hoja de datos
\n 3.2. Contar los registros
\n 3.3. Campo de b\u00fasqueda
\n 3.4. Filtros
\n 3.5. Campos de tipo Texto largo<\/p>\n

4. CONSULTAS
\n 4.1. Introducci\u00f3n
\n 4.2. Crear consultas
\n 4.3. Asistente de consultas
\n 4.4. Ordenaci\u00f3n y criterios
\n 4.5. Propiedades de una consulta<\/p>\n

5. M\u00c1S CONSULTAS
\n 5.1. Consultas de actualizaci\u00f3n
\n 5.2. Consultas de eliminaci\u00f3n
\n 5.3. Consultas de datos anexados
\n 5.4. Consultas de creaci\u00f3n de tablas
\n 5.5. Consultas de par\u00e1metros<\/p>\n

6. TRABAJO AVANZADO CON CONSULTAS
\n 6.1. Establecer criterios
\n 6.2. Campos calculados
\n 6.3. Consultas de totales<\/p>\n

7. FORMULARIOS
\n 7.1. Asistentes para formularios
\n 7.2. Modos de vista
\n 7.3. Edici\u00f3n de datos
\n 7.4. Los subformularios
\n 7.5. Propiedades del formulario<\/p>\n

8. DISE\u00d1O DE FORMULARIOS (I)
\n 8.1. A\u00f1adir controles
\n 8.2. Propiedades
\n 8.3. Editar controles<\/p>\n

9. DISE\u00d1O DE FORMULARIOS (II)
\n 9.1. Lista de opciones
\n 9.2. Establecer opciones
\n 9.3. Botones de comando
\n 9.4. Efectos de dise\u00f1o
\n 9.5. Colores, efectos y estilos<\/p>\n

10. DISE\u00d1O DE FORMULARIOS (III)
\n 10.1. Organizaci\u00f3n de los controles
\n 10.2. Orden de tabulaci\u00f3n y otras propiedades
\n 10.3. Dise\u00f1o de controles
\n 10.4. Secciones de un formulario
\n 10.5. Formato condicional<\/p>\n

11. CREAR EXPRESIONES
\n 11.1. Introducci\u00f3n
\n 11.2. El Generador de expresiones
\n 11.3. Funciones
\n 11.4. Otros controles
\n 11.5. Formulario de inicio<\/p>\n

12. INFORMES
\n 12.1. Introducci\u00f3n
\n 12.2. Asistentes para informes
\n 12.3. Modos de vista
\n 12.4. Dise\u00f1o de informes
\n 12.5. Secciones de un informe<\/p>\n

13. TRABAJAR CON INFORMES
\n 13.1. Ordenar y agrupar
\n 13.2. Propiedades del grupo
\n 13.3. Subinformes
\n 13.4. Imprimir etiquetas<\/p>\n","protected":false},"excerpt":{"rendered":"

– Describir las funciones intermedias del programa de gesti\u00f3n de bases de datos Microsoft Access 2016.
\n – Introducir los tipos de objetos consulta, formulario e informe: cu\u00e1l es su papel, cu\u00e1ndo se utilizan, etc.
\n – Detallar el dise\u00f1o correcto de estos tipos de objetos en una base de datos Access.<\/p>\n","protected":false},"featured_media":24101,"template":"","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":""},"product_brand":[],"product_cat":[48],"product_tag":[],"class_list":["post-24372","product","type-product","status-publish","has-post-thumbnail","product_cat-informatica-y-comunicaciones","first","instock","virtual","taxable","purchasable","product-type-simple"],"yoast_head":"\nMICROSOFT ACCESS 2016 (INTERMEDIO) -<\/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\/microsoft-access-2016-intermedio\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MICROSOFT ACCESS 2016 (INTERMEDIO) -\" \/>\n<meta property=\"og:description\" content=\"- Describir las funciones intermedias del programa de gesti\u00f3n de bases de datos Microsoft Access 2016. - Introducir los tipos de objetos consulta, formulario e informe: cu\u00e1l es su papel, cu\u00e1ndo se utilizan, etc. - Detallar el dise\u00f1o correcto de estos tipos de objetos en una base de datos Access.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/abexis.es\/index.php\/product\/microsoft-access-2016-intermedio\/\" \/>\n<meta property=\"og:site_name\" content=\"Formaliser\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-16T12:08:36+00:00\" \/>\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=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/abexis.es\\\/index.php\\\/product\\\/microsoft-access-2016-intermedio\\\/\",\"url\":\"https:\\\/\\\/abexis.es\\\/index.php\\\/product\\\/microsoft-access-2016-intermedio\\\/\",\"name\":\"MICROSOFT ACCESS 2016 (INTERMEDIO) -\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/abexis.es\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/abexis.es\\\/index.php\\\/product\\\/microsoft-access-2016-intermedio\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/abexis.es\\\/index.php\\\/product\\\/microsoft-access-2016-intermedio\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/abexis.es\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/INFORMATICA.png\",\"datePublished\":\"2025-01-31T01:15:49+00:00\",\"dateModified\":\"2025-06-16T12:08:36+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/abexis.es\\\/index.php\\\/product\\\/microsoft-access-2016-intermedio\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/abexis.es\\\/index.php\\\/product\\\/microsoft-access-2016-intermedio\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/abexis.es\\\/index.php\\\/product\\\/microsoft-access-2016-intermedio\\\/#primaryimage\",\"url\":\"https:\\\/\\\/abexis.es\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/INFORMATICA.png\",\"contentUrl\":\"https:\\\/\\\/abexis.es\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/INFORMATICA.png\",\"width\":587,\"height\":506},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/abexis.es\\\/index.php\\\/product\\\/microsoft-access-2016-intermedio\\\/#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\":\"MICROSOFT ACCESS 2016 (INTERMEDIO)\"}]},{\"@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":"MICROSOFT ACCESS 2016 (INTERMEDIO) -","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\/microsoft-access-2016-intermedio\/","og_locale":"es_ES","og_type":"article","og_title":"MICROSOFT ACCESS 2016 (INTERMEDIO) -","og_description":"- Describir las funciones intermedias del programa de gesti\u00f3n de bases de datos Microsoft Access 2016. - Introducir los tipos de objetos consulta, formulario e informe: cu\u00e1l es su papel, cu\u00e1ndo se utilizan, etc. - Detallar el dise\u00f1o correcto de estos tipos de objetos en una base de datos Access.","og_url":"https:\/\/abexis.es\/index.php\/product\/microsoft-access-2016-intermedio\/","og_site_name":"Formaliser","article_modified_time":"2025-06-16T12:08:36+00:00","twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/abexis.es\/index.php\/product\/microsoft-access-2016-intermedio\/","url":"https:\/\/abexis.es\/index.php\/product\/microsoft-access-2016-intermedio\/","name":"MICROSOFT ACCESS 2016 (INTERMEDIO) -","isPartOf":{"@id":"https:\/\/abexis.es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/abexis.es\/index.php\/product\/microsoft-access-2016-intermedio\/#primaryimage"},"image":{"@id":"https:\/\/abexis.es\/index.php\/product\/microsoft-access-2016-intermedio\/#primaryimage"},"thumbnailUrl":"https:\/\/abexis.es\/wp-content\/uploads\/2025\/01\/INFORMATICA.png","datePublished":"2025-01-31T01:15:49+00:00","dateModified":"2025-06-16T12:08:36+00:00","breadcrumb":{"@id":"https:\/\/abexis.es\/index.php\/product\/microsoft-access-2016-intermedio\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/abexis.es\/index.php\/product\/microsoft-access-2016-intermedio\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/abexis.es\/index.php\/product\/microsoft-access-2016-intermedio\/#primaryimage","url":"https:\/\/abexis.es\/wp-content\/uploads\/2025\/01\/INFORMATICA.png","contentUrl":"https:\/\/abexis.es\/wp-content\/uploads\/2025\/01\/INFORMATICA.png","width":587,"height":506},{"@type":"BreadcrumbList","@id":"https:\/\/abexis.es\/index.php\/product\/microsoft-access-2016-intermedio\/#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":"MICROSOFT ACCESS 2016 (INTERMEDIO)"}]},{"@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\/24372","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\/24101"}],"wp:attachment":[{"href":"https:\/\/abexis.es\/index.php\/wp-json\/wp\/v2\/media?parent=24372"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/abexis.es\/index.php\/wp-json\/wp\/v2\/product_brand?post=24372"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/abexis.es\/index.php\/wp-json\/wp\/v2\/product_cat?post=24372"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/abexis.es\/index.php\/wp-json\/wp\/v2\/product_tag?post=24372"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}