{"id":14608,"date":"2022-12-29T08:24:28","date_gmt":"2022-12-29T07:24:28","guid":{"rendered":"https:\/\/www.itta.net\/formations\/icdl-advanced-database-am5\/"},"modified":"2023-10-10T11:18:59","modified_gmt":"2023-10-10T09:18:59","slug":"icdl-advanced-database-am5","status":"publish","type":"formations","link":"https:\/\/www.itta.net\/en\/trainings\/office-automation\/office-automation-certifications\/icdl-advanced-database-am5\/","title":{"rendered":"ICDL ADVANCED &#8211; Database &#8211; AM5"},"content":{"rendered":"<p>This course covers the key database concepts necessary to understand a relational database and use an appropriate application to create an advanced database structure and outputs.<\/p>\n","protected":false},"featured_media":0,"parent":0,"menu_order":0,"template":"","editeurs":[1532,1533],"domaine":[1265,1266],"class_list":["post-14608","formations","type-formations","status-publish","hentry","editeurs-ecdl","editeurs-modules-avances-ecdl","domaine-office-automation","domaine-office-automation-certifications"],"acf":{"reference":"ECDL3-AM5","duree_nombre":2,"duree_unite":"jour","prix_virtuel":1200,"prix_presentiel":1300,"prix_blended":"","prix_elearning":"","views":2135,"niveau":["Avanc\u00e9"],"role":"","certifiant":["Certifiant"],"pdus":"","lieux":["Gen\u00e8ve","Lausanne"],"formats_dapprentissage":["presentiel","virtuel"],"examen_inclus":"Optionnel","garanti":[""],"financement":["Temptraining"],"description_temptraining":"","description_caf":"","description_title":"","objectifs":"<ul>\r\n \t<li>Understand key concepts of database development and usage<\/li>\r\n \t<li>Create a relational database using advanced table creation features and complex relationships between tables<\/li>\r\n \t<li>Design and use queries to create a table, update, delete and append data. Refine queries using wildcards, parameters and calculations<\/li>\r\n \t<li>Use controls and subforms to enhance forms and improve functionality<\/li>\r\n \t<li>Create report controls to perform calculations. Create subreports and enhance report presentation<\/li>\r\n \t<li>Enhance productivity by working with macros and use linking and importing features to integrate data<\/li>\r\n<\/ul>","connaissances":"<ul>\r\n \t<li>Advanced knowledge on databases<\/li>\r\n \t<li>Understand key concepts of database development and usage<\/li>\r\n \t<li>Create a relational database using advanced table creation features and complex relationships between tables<\/li>\r\n \t<li>Design and use queries to create a table, update, delete and append data<\/li>\r\n \t<li>Refine queries using wildcards, parameters and calculations<\/li>\r\n \t<li>Use controls and subforms to enhance forms and improve functionality<\/li>\r\n \t<li>Create report controls to perform calculations<\/li>\r\n \t<li>Create subreports and enhance report presentation<\/li>\r\n<\/ul>","profils_participants":"<ul>\r\n \t<li>Individuals wishing to develop their skills and Knowledge about the use of a database<\/li>\r\n<\/ul>","examen":"<ul>\r\n \t<li>This course prepares to the exam ICDL Database Advanced (AM5). If you wish to take this exam, please contact our secretariat who will let you know the cost of the exam and will take care of all the necessary administrative procedures for you<\/li>\r\n<\/ul>","documentation":"<ul>\r\n \t<li>Digital courseware included<\/li>\r\n<\/ul>","lab__exercices":"<ul>\r\n \t<li>Practice exercises will be offered during and at the end of each module<\/li>\r\n<\/ul>","contenu_cours":"<strong>Chapter 1: Database Concepts<\/strong>\r\n<ul>\r\n \t<li>Module 1: Database Development and Use\r\n<ul>\r\n \t<li>Know that different types of database models exist like: hierarchical, relational, object-oriented<\/li>\r\n \t<li>Know the life cycle stages of a database: logical design, database creation, data entry, data maintenance, information retrieval<\/li>\r\n \t<li>Recognize common business applications of databases like: dynamic website, customer relationship management systems, enterprise resource planning systems, website content management systems<\/li>\r\n \t<li>Know the term SQL (structured query language) and understand its main use in querying database content<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<strong>Chapter 2: Tables and Relationships<\/strong>\r\n<ul>\r\n \t<li>Module 1: Fields\/Columns\r\n<ul>\r\n \t<li>Create, modify, delete a lookup in a field\/ column<\/li>\r\n \t<li>Create, modify, delete an input mask in a field\/ column<\/li>\r\n \t<li>Set data entry for a field\/column: required, not required<\/li>\r\n<\/ul>\r\n<\/li>\r\n \t<li>Module 2: Relationships and Joins\r\n<ul>\r\n \t<li>Create, modify, delete a one-to-one, one-tomany relationship between tables<\/li>\r\n \t<li>Create, modify a many-to-many relationship using a junction table<\/li>\r\n \t<li>Apply referential integrity between tables<\/li>\r\n \t<li>Apply automatic update of related fields<\/li>\r\n \t<li>Apply automatic deletion of related records<\/li>\r\n \t<li>Apply, modify an inner join, outer join<\/li>\r\n \t<li>Create, modify a subtract join<\/li>\r\n \t<li>Apply a self join<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<strong>Chapter 3: Queries<\/strong>\r\n<ul>\r\n \t<li>Module 1: Query Types\r\n<ul>\r\n \t<li>Create, run a query to update data in a table<\/li>\r\n \t<li>Create, run a query to append records to a table<\/li>\r\n \t<li>Create, run a query to delete records in a table<\/li>\r\n \t<li>Create, run a query to save selected data as a new table<\/li>\r\n \t<li>Create, run a crosstab query<\/li>\r\n \t<li>Create, run a query to show duplicated records within a table<\/li>\r\n \t<li>Create, run a query to show unmatched records in related tables<\/li>\r\n<\/ul>\r\n<\/li>\r\n \t<li>Module 2: Refining a Query\r\n<ul>\r\n \t<li>Create, modify, run a one, two variable parameter query<\/li>\r\n \t<li>Use wildcards in a query: [ ], !, -, #<\/li>\r\n \t<li>Show highest, lowest range of values in a query<\/li>\r\n \t<li>Create and name a calculated field that performs arithmetic operations<\/li>\r\n \t<li>Group information in a query using functions: sum, count, average, max, min<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<strong>Chapter 4: Forms<\/strong>\r\n<ul>\r\n \t<li>Module 1: Controls\r\n<ul>\r\n \t<li>Create, modify, delete bound controls: text box, combo box, list box, check box, option groups<\/li>\r\n \t<li>Apply, remove bound control properties like: limit to list, distinct values<\/li>\r\n \t<li>Create, modify, delete unbound controls containing arithmetic, logical expressions<\/li>\r\n \t<li>Modify sequential tab order of controls on a form<\/li>\r\n \t<li>Create, delete a linked subform<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<strong>Chapter 5: Reports<\/strong>\r\n<ul>\r\n \t<li>Module 1: Controls\r\n<ul>\r\n \t<li>Format arithmetic calculation controls in a report: percentage, currency, to a specific number of decimal places<\/li>\r\n \t<li>Apply a running sum for a group, over all<\/li>\r\n \t<li>Concatenate fields in a report<\/li>\r\n<\/ul>\r\n<\/li>\r\n \t<li>Module 2: Presentation\r\n<ul>\r\n \t<li>Insert, delete a data field in group, page, report headers and footers<\/li>\r\n \t<li>Sort, group records in a report by field(s)<\/li>\r\n \t<li>Force page breaks for groups in a report<\/li>\r\n \t<li>Create, delete a linked subreport<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<strong>Chapter 6: Enhancing Productivity<\/strong>\r\n<ul>\r\n \t<li>Module 1: Linking, Importing\r\n<ul>\r\n \t<li>Link external data to a database: spreadsheet, text (.txt, .csv), existing database files<\/li>\r\n \t<li>Import spreadsheet, text (.txt, .csv), XML, existing database files into a database<\/li>\r\n<\/ul>\r\n<\/li>\r\n \t<li>Module 2: Automation\r\n<ul>\r\n \t<li>Create a simple macro like: close an object and open another object, open and maximize an object, open and minimize an object, print and close an object<\/li>\r\n \t<li>Assign\/attach a macro to a command button, object, control<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>","cours_recommandes":[14606,14607,14609],"infos_additionnelles":"","inclus_dans_ce_cours_virtuel":"<ul>\r\n \t<li>Training provided by a certified trainer<\/li>\r\n \t<li>Exam fee (Skills Card not included)<\/li>\r\n \t<li>Pre-training level evaluation<\/li>\r\n \t<li>Digital documentation<\/li>\r\n<\/ul>","inclus_dans_ce_cours_presentiel":"<ul>\r\n \t<li>Training provided by a certified trainer<\/li>\r\n \t<li>Exam fee (Skills Card not included)<\/li>\r\n \t<li>Pre-training level evaluation<\/li>\r\n \t<li>Digital documentation<\/li>\r\n<\/ul>","inclus_dans_ce_cours_blended":"","inclus_dans_ce_cours_elearning":"","inclus_dans_ce_cours_surmesure":""},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.5 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Training ICDL ADVANCED - Database AM5 - ITTA<\/title>\n<meta name=\"description\" content=\"This course covers the key database concepts necessary to understand a relational database and to create an advanced database structure and outputs.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.itta.net\/en\/trainings\/office-automation\/office-automation-certifications\/icdl-advanced-database-am5\/\" \/>\n<meta name=\"twitter:label1\" content=\"Estimated reading time\" \/>\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:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/office-automation\\\/office-automation-certifications\\\/icdl-advanced-database-am5\\\/\",\"url\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/office-automation\\\/office-automation-certifications\\\/icdl-advanced-database-am5\\\/\",\"name\":\"Training ICDL ADVANCED - Database AM5 - ITTA\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#website\"},\"datePublished\":\"2022-12-29T07:24:28+00:00\",\"dateModified\":\"2023-10-10T09:18:59+00:00\",\"description\":\"This course covers the key database concepts necessary to understand a relational database and to create an advanced database structure and outputs.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/office-automation\\\/office-automation-certifications\\\/icdl-advanced-database-am5\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/office-automation\\\/office-automation-certifications\\\/icdl-advanced-database-am5\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/office-automation\\\/office-automation-certifications\\\/icdl-advanced-database-am5\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.itta.net\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Office Automation\",\"item\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/office-automation\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Office Automation Certifications\",\"item\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/office-automation\\\/office-automation-certifications\\\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"ICDL ADVANCED &#8211; Database &#8211; AM5\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.itta.net\\\/en\\\/\",\"name\":\"ITTA\",\"description\":\"Formations &amp; Certifications en Suisse Romande\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.itta.net\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":[\"Organization\",\"EducationalOrganization\"],\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#organization\",\"name\":\"ITTA\",\"alternateName\":\"IT TRAINING ACADEMY SA\",\"url\":\"https:\\\/\\\/www.itta.net\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.itta.net\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/Logo-transparent.png\",\"contentUrl\":\"https:\\\/\\\/www.itta.net\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/Logo-transparent.png\",\"width\":1500,\"height\":623,\"caption\":\"ITTA\"},\"image\":{\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/people\\\/ITTA\\\/100063747262936\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/1001738\",\"https:\\\/\\\/www.instagram.com\\\/itta_suisse\\\/\"],\"contactPoint\":{\"@type\":\"ContactPoint\",\"telephone\":\"+41 58 307 73 00\",\"contactType\":\"customer service\",\"availableLanguage\":[\"French\",\"English\"],\"areaServed\":[{\"@type\":\"Country\",\"name\":\"Switzerland\"},{\"@type\":\"Country\",\"name\":\"France\"}]},\"location\":[{\"@type\":\"Place\",\"name\":\"ITTA Geneve\",\"address\":{\"@type\":\"PostalAddress\",\"streetAddress\":\"Route des Jeunes 35\",\"addressLocality\":\"Carouge\",\"postalCode\":\"1227\",\"addressRegion\":\"GE\",\"addressCountry\":\"CH\"},\"geo\":{\"@type\":\"GeoCoordinates\",\"latitude\":46.18274,\"longitude\":6.12922}},{\"@type\":\"Place\",\"name\":\"ITTA Lausanne\",\"address\":{\"@type\":\"PostalAddress\",\"streetAddress\":\"Rue des Cotes-de-Montbenon 16\",\"addressLocality\":\"Lausanne\",\"postalCode\":\"1003\",\"addressRegion\":\"VD\",\"addressCountry\":\"CH\"},\"geo\":{\"@type\":\"GeoCoordinates\",\"latitude\":46.52111,\"longitude\":6.62734}}]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Training ICDL ADVANCED - Database AM5 - ITTA","description":"This course covers the key database concepts necessary to understand a relational database and to create an advanced database structure and outputs.","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:\/\/www.itta.net\/en\/trainings\/office-automation\/office-automation-certifications\/icdl-advanced-database-am5\/","twitter_misc":{"Estimated reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.itta.net\/en\/trainings\/office-automation\/office-automation-certifications\/icdl-advanced-database-am5\/","url":"https:\/\/www.itta.net\/en\/trainings\/office-automation\/office-automation-certifications\/icdl-advanced-database-am5\/","name":"Training ICDL ADVANCED - Database AM5 - ITTA","isPartOf":{"@id":"https:\/\/www.itta.net\/en\/#website"},"datePublished":"2022-12-29T07:24:28+00:00","dateModified":"2023-10-10T09:18:59+00:00","description":"This course covers the key database concepts necessary to understand a relational database and to create an advanced database structure and outputs.","breadcrumb":{"@id":"https:\/\/www.itta.net\/en\/trainings\/office-automation\/office-automation-certifications\/icdl-advanced-database-am5\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.itta.net\/en\/trainings\/office-automation\/office-automation-certifications\/icdl-advanced-database-am5\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.itta.net\/en\/trainings\/office-automation\/office-automation-certifications\/icdl-advanced-database-am5\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.itta.net\/en\/"},{"@type":"ListItem","position":2,"name":"Office Automation","item":"https:\/\/www.itta.net\/en\/trainings\/office-automation\/"},{"@type":"ListItem","position":3,"name":"Office Automation Certifications","item":"https:\/\/www.itta.net\/en\/trainings\/office-automation\/office-automation-certifications\/"},{"@type":"ListItem","position":4,"name":"ICDL ADVANCED &#8211; Database &#8211; AM5"}]},{"@type":"WebSite","@id":"https:\/\/www.itta.net\/en\/#website","url":"https:\/\/www.itta.net\/en\/","name":"ITTA","description":"Formations &amp; Certifications en Suisse Romande","publisher":{"@id":"https:\/\/www.itta.net\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.itta.net\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":["Organization","EducationalOrganization"],"@id":"https:\/\/www.itta.net\/en\/#organization","name":"ITTA","alternateName":"IT TRAINING ACADEMY SA","url":"https:\/\/www.itta.net\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.itta.net\/en\/#\/schema\/logo\/image\/","url":"https:\/\/www.itta.net\/wp-content\/uploads\/2023\/02\/Logo-transparent.png","contentUrl":"https:\/\/www.itta.net\/wp-content\/uploads\/2023\/02\/Logo-transparent.png","width":1500,"height":623,"caption":"ITTA"},"image":{"@id":"https:\/\/www.itta.net\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/people\/ITTA\/100063747262936\/","https:\/\/www.linkedin.com\/company\/1001738","https:\/\/www.instagram.com\/itta_suisse\/"],"contactPoint":{"@type":"ContactPoint","telephone":"+41 58 307 73 00","contactType":"customer service","availableLanguage":["French","English"],"areaServed":[{"@type":"Country","name":"Switzerland"},{"@type":"Country","name":"France"}]},"location":[{"@type":"Place","name":"ITTA Geneve","address":{"@type":"PostalAddress","streetAddress":"Route des Jeunes 35","addressLocality":"Carouge","postalCode":"1227","addressRegion":"GE","addressCountry":"CH"},"geo":{"@type":"GeoCoordinates","latitude":46.18274,"longitude":6.12922}},{"@type":"Place","name":"ITTA Lausanne","address":{"@type":"PostalAddress","streetAddress":"Rue des Cotes-de-Montbenon 16","addressLocality":"Lausanne","postalCode":"1003","addressRegion":"VD","addressCountry":"CH"},"geo":{"@type":"GeoCoordinates","latitude":46.52111,"longitude":6.62734}}]}]}},"_links":{"self":[{"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/formations\/14608","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/formations"}],"about":[{"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/types\/formations"}],"acf:post":[{"embeddable":true,"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/formations\/14609"},{"embeddable":true,"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/formations\/14607"},{"embeddable":true,"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/formations\/14606"}],"wp:attachment":[{"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/media?parent=14608"}],"wp:term":[{"taxonomy":"editeurs","embeddable":true,"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/editeurs?post=14608"},{"taxonomy":"domaine","embeddable":true,"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/domaine?post=14608"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}