{"id":9827,"date":"2024-05-23T10:49:06","date_gmt":"2024-05-23T13:49:06","guid":{"rendered":"https:\/\/playcomp.cl\/?post_type=product&#038;p=9827"},"modified":"2024-10-24T15:57:58","modified_gmt":"2024-10-24T18:57:58","slug":"access-nivel-intermedio-2","status":"publish","type":"product","link":"https:\/\/playcomp.cl\/index.php\/producto\/access-nivel-intermedio-2\/","title":{"rendered":"ACCESS, nivel Intermedio"},"content":{"rendered":"<p><strong>OBJETIVO<\/strong><\/p>\n<p>Al t\u00e9rmino del curso los participantes estar\u00e1n en condiciones de administrar grandes vol\u00famenes de informaci\u00f3n, registros en Bases de Datos, vinculados en diferentes tablas, para realizar filtros y consultas en base a criterios, con la factibilidad de actualizar la informaci\u00f3n de estas, creando formularios e informes con los correspondientes controles y filtros, apoyando sus resultados con sub formularios, con conocimientos de nivel intermedio que faciliten el trabajo rutinario o sistem\u00e1tico.<\/p>\n<p><strong>CONTENIDO<\/strong><\/p>\n<p><strong>1. Consultas<\/strong><\/p>\n<ul>\n<li>Objetivos<\/li>\n<li>Concepto de consultas<\/li>\n<li>Consultas de Selecci\u00f3n<\/li>\n<li>Consultas de Acci\u00f3n<\/li>\n<li>Consultas sobre varios objetos<\/li>\n<li>Consultas avanzadas<\/li>\n<li>Trabajar con campos, criterios, ordenamientos<\/li>\n<li>Ejecutar una consulta<\/li>\n<li>Modificar el dise\u00f1o de una consulta<\/li>\n<\/ul>\n<p><strong>2. Autoformularios y formularios<\/strong><\/p>\n<ul>\n<li>Introducci\u00f3n<\/li>\n<li>Crear autoformularios<\/li>\n<li>Crear un formulario utilizando el asistente<\/li>\n<li>Asistente para formularios y subformularios en pr\u00e1ctica<\/li>\n<li>Elementos b\u00e1sicos de un formulario<\/li>\n<li>Vista de dise\u00f1o de Formularios<\/li>\n<li>Mostrar lista de campos<\/li>\n<li>Manejar formularios<\/li>\n<li>Propiedades de los formularios<\/li>\n<li>Buscar datos<\/li>\n<li>Personalizar formularios<\/li>\n<\/ul>\n<p><strong>3. Modificar el dise\u00f1o del formulario<\/strong><\/p>\n<ul>\n<li>Introducci\u00f3n<\/li>\n<li>Formulario en presentaci\u00f3n de dise\u00f1o<\/li>\n<li>Controles<\/li>\n<li>Controles especiales<\/li>\n<li>Seleccionar y mover controles<\/li>\n<li>Ajustar el tama\u00f1o de los controles<\/li>\n<li>Dar formato al texto<\/li>\n<li>Formato condicional<\/li>\n<li>Propiedades de los controles y formularios<\/li>\n<li>Alinear, ajustar tama\u00f1o y controles de espacio<\/li>\n<li>Dar formato a los subformularios<\/li>\n<li>Insertar im\u00e1genes a un formulario<\/li>\n<li>Orden de tabulaci\u00f3n<\/li>\n<\/ul>\n<p><strong>4. Trabajar con controles y formularios<\/strong><\/p>\n<ul>\n<li>Trabajar y activar un formulario<\/li>\n<li>Hacer un formulario sea de s\u00f3lo lectura<\/li>\n<\/ul>\n<p><strong>5. Trabajar con Informes<\/strong><\/p>\n<ul>\n<li>Creaci\u00f3n de informes.<\/li>\n<li>Auto informes.<\/li>\n<li>Crear informes utilizando el Asistente<\/li>\n<li>Pr\u00e1ctica de entorno con el asistente<\/li>\n<li>Vista de dise\u00f1o<\/li>\n<li>Pr\u00e1ctica de entorno con Vista Dise\u00f1o<\/li>\n<li>Modificar un informe<\/li>\n<li>Secciones de un informe<\/li>\n<li>Fecha y n\u00famero de p\u00e1ginas<\/li>\n<li>Trabajar con controles<\/li>\n<li>Imprimir un informe<\/li>\n<li>Presentaci\u00f3n de datos mediante otras aplicaciones Office<\/li>\n<li>Guardar un informe como una instant\u00e1nea<\/li>\n<li>Basar un informe en una consulta<\/li>\n<li>Creaci\u00f3n de informes algo m\u00e1s complejos<\/li>\n<li>Crear sub informes<\/li>\n<li>Asistente para sub informes<\/li>\n<li>A\u00f1adir un sub informe en otro<\/li>\n<li>Crear plantillas para formularios e informes<\/li>\n<li>Crear plantillas para formularios e informes<\/li>\n<li>Numerar cada registro de detalle<\/li>\n<\/ul>\n<p><strong>6. Anexo<\/strong><\/p>\n<ul>\n<li>Datos t\u00e9cnicos de Access<\/li>\n<li>Especificaciones generales acerca de la base de datos de Microsoft Access<\/li>\n<li>Especificaciones generales de un proyecto de Microsoft Access<\/li>\n<li>Especificaciones acerca de la tabla de base de datos de Microsoft Access<\/li>\n<li>Especificaciones de formularios e informes<\/li>\n<li>Informaci\u00f3n de Soporte T\u00e9cnico<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>OBJETIVO Al t\u00e9rmino del curso los participantes estar\u00e1n en condiciones de administrar grandes vol\u00famenes de informaci\u00f3n, registros en Bases de Datos, vinculados en diferentes tablas, para realizar filtros y consultas en base a criterios, con la factibilidad de actualizar la informaci\u00f3n de estas, creando formularios e informes con los correspondientes controles y filtros, apoyando sus&#8230;<\/p>\n","protected":false},"featured_media":10377,"template":"","meta":{"_acf_changed":false},"product_brand":[],"product_cat":[134],"product_tag":[],"class_list":{"0":"post-9827","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-administradores-de-base-de-datos","8":"first","9":"instock","10":"shipping-taxable","11":"product-type-simple"},"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.8.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>ACCESS, nivel Intermedio - Play Comp<\/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:\/\/playcomp.cl\/index.php\/producto\/access-nivel-intermedio-2\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ACCESS, nivel Intermedio - Play Comp\" \/>\n<meta property=\"og:description\" content=\"OBJETIVO Al t\u00e9rmino del curso los participantes estar\u00e1n en condiciones de administrar grandes vol\u00famenes de informaci\u00f3n, registros en Bases de Datos, vinculados en diferentes tablas, para realizar filtros y consultas en base a criterios, con la factibilidad de actualizar la informaci\u00f3n de estas, creando formularios e informes con los correspondientes controles y filtros, apoyando sus...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/playcomp.cl\/index.php\/producto\/access-nivel-intermedio-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Play Comp\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/playcompchile\/\" \/>\n<meta property=\"article:modified_time\" content=\"2024-10-24T18:57:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/playcomp.cl\/wp-content\/uploads\/2024\/05\/Imagen1-5-1-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"463\" \/>\n\t<meta property=\"og:image:height\" content=\"463\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\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:\/\/playcomp.cl\/index.php\/producto\/access-nivel-intermedio-2\/\",\"url\":\"https:\/\/playcomp.cl\/index.php\/producto\/access-nivel-intermedio-2\/\",\"name\":\"ACCESS, nivel Intermedio - Play Comp\",\"isPartOf\":{\"@id\":\"https:\/\/playcomp.cl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/playcomp.cl\/index.php\/producto\/access-nivel-intermedio-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/playcomp.cl\/index.php\/producto\/access-nivel-intermedio-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/playcomp.cl\/wp-content\/uploads\/2024\/05\/Imagen1-5-1-1.png\",\"datePublished\":\"2024-05-23T13:49:06+00:00\",\"dateModified\":\"2024-10-24T18:57:58+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/playcomp.cl\/index.php\/producto\/access-nivel-intermedio-2\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/playcomp.cl\/index.php\/producto\/access-nivel-intermedio-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/playcomp.cl\/index.php\/producto\/access-nivel-intermedio-2\/#primaryimage\",\"url\":\"https:\/\/playcomp.cl\/wp-content\/uploads\/2024\/05\/Imagen1-5-1-1.png\",\"contentUrl\":\"https:\/\/playcomp.cl\/wp-content\/uploads\/2024\/05\/Imagen1-5-1-1.png\",\"width\":463,\"height\":463},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/playcomp.cl\/index.php\/producto\/access-nivel-intermedio-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\/\/playcomp.cl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tienda\",\"item\":\"https:\/\/playcomp.cl\/index.php\/tienda\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"ACCESS, nivel Intermedio\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/playcomp.cl\/#website\",\"url\":\"https:\/\/playcomp.cl\/\",\"name\":\"Play Comp\",\"description\":\"Organismo T\u00e9cnico de Capacitaci\u00f3n\",\"publisher\":{\"@id\":\"https:\/\/playcomp.cl\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/playcomp.cl\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/playcomp.cl\/#organization\",\"name\":\"Play Comp\",\"url\":\"https:\/\/playcomp.cl\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/playcomp.cl\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/playcomp.cl\/wp-content\/uploads\/2017\/07\/Artboard-36.png\",\"contentUrl\":\"https:\/\/playcomp.cl\/wp-content\/uploads\/2017\/07\/Artboard-36.png\",\"width\":423,\"height\":112,\"caption\":\"Play Comp\"},\"image\":{\"@id\":\"https:\/\/playcomp.cl\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/playcompchile\/\",\"https:\/\/www.instagram.com\/playcomp_capacitacion?igsh=OGtwZzBsYW5qbTF5\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"ACCESS, nivel Intermedio - Play Comp","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:\/\/playcomp.cl\/index.php\/producto\/access-nivel-intermedio-2\/","og_locale":"es_ES","og_type":"article","og_title":"ACCESS, nivel Intermedio - Play Comp","og_description":"OBJETIVO Al t\u00e9rmino del curso los participantes estar\u00e1n en condiciones de administrar grandes vol\u00famenes de informaci\u00f3n, registros en Bases de Datos, vinculados en diferentes tablas, para realizar filtros y consultas en base a criterios, con la factibilidad de actualizar la informaci\u00f3n de estas, creando formularios e informes con los correspondientes controles y filtros, apoyando sus...","og_url":"https:\/\/playcomp.cl\/index.php\/producto\/access-nivel-intermedio-2\/","og_site_name":"Play Comp","article_publisher":"https:\/\/www.facebook.com\/playcompchile\/","article_modified_time":"2024-10-24T18:57:58+00:00","og_image":[{"width":463,"height":463,"url":"https:\/\/playcomp.cl\/wp-content\/uploads\/2024\/05\/Imagen1-5-1-1.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/playcomp.cl\/index.php\/producto\/access-nivel-intermedio-2\/","url":"https:\/\/playcomp.cl\/index.php\/producto\/access-nivel-intermedio-2\/","name":"ACCESS, nivel Intermedio - Play Comp","isPartOf":{"@id":"https:\/\/playcomp.cl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/playcomp.cl\/index.php\/producto\/access-nivel-intermedio-2\/#primaryimage"},"image":{"@id":"https:\/\/playcomp.cl\/index.php\/producto\/access-nivel-intermedio-2\/#primaryimage"},"thumbnailUrl":"https:\/\/playcomp.cl\/wp-content\/uploads\/2024\/05\/Imagen1-5-1-1.png","datePublished":"2024-05-23T13:49:06+00:00","dateModified":"2024-10-24T18:57:58+00:00","breadcrumb":{"@id":"https:\/\/playcomp.cl\/index.php\/producto\/access-nivel-intermedio-2\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/playcomp.cl\/index.php\/producto\/access-nivel-intermedio-2\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/playcomp.cl\/index.php\/producto\/access-nivel-intermedio-2\/#primaryimage","url":"https:\/\/playcomp.cl\/wp-content\/uploads\/2024\/05\/Imagen1-5-1-1.png","contentUrl":"https:\/\/playcomp.cl\/wp-content\/uploads\/2024\/05\/Imagen1-5-1-1.png","width":463,"height":463},{"@type":"BreadcrumbList","@id":"https:\/\/playcomp.cl\/index.php\/producto\/access-nivel-intermedio-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/playcomp.cl\/"},{"@type":"ListItem","position":2,"name":"Tienda","item":"https:\/\/playcomp.cl\/index.php\/tienda\/"},{"@type":"ListItem","position":3,"name":"ACCESS, nivel Intermedio"}]},{"@type":"WebSite","@id":"https:\/\/playcomp.cl\/#website","url":"https:\/\/playcomp.cl\/","name":"Play Comp","description":"Organismo T\u00e9cnico de Capacitaci\u00f3n","publisher":{"@id":"https:\/\/playcomp.cl\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/playcomp.cl\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/playcomp.cl\/#organization","name":"Play Comp","url":"https:\/\/playcomp.cl\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/playcomp.cl\/#\/schema\/logo\/image\/","url":"https:\/\/playcomp.cl\/wp-content\/uploads\/2017\/07\/Artboard-36.png","contentUrl":"https:\/\/playcomp.cl\/wp-content\/uploads\/2017\/07\/Artboard-36.png","width":423,"height":112,"caption":"Play Comp"},"image":{"@id":"https:\/\/playcomp.cl\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/playcompchile\/","https:\/\/www.instagram.com\/playcomp_capacitacion?igsh=OGtwZzBsYW5qbTF5"]}]}},"_links":{"self":[{"href":"https:\/\/playcomp.cl\/index.php\/wp-json\/wp\/v2\/product\/9827","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/playcomp.cl\/index.php\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/playcomp.cl\/index.php\/wp-json\/wp\/v2\/types\/product"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/playcomp.cl\/index.php\/wp-json\/wp\/v2\/media\/10377"}],"wp:attachment":[{"href":"https:\/\/playcomp.cl\/index.php\/wp-json\/wp\/v2\/media?parent=9827"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/playcomp.cl\/index.php\/wp-json\/wp\/v2\/product_brand?post=9827"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/playcomp.cl\/index.php\/wp-json\/wp\/v2\/product_cat?post=9827"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/playcomp.cl\/index.php\/wp-json\/wp\/v2\/product_tag?post=9827"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}