[{"id":"58ad1fd","elType":"section","settings":[],"elements":[{"id":"3fc8ad1","elType":"column","settings":{"_column_size":100,"_inline_size":null},"elements":[{"id":"0841872","elType":"widget","settings":{"title":"Access Coaching Courses","header_size":"h1"},"elements":[],"widgetType":"heading"}],"isInner":false}],"isInner":false},{"id":"13802ab","elType":"section","settings":[],"elements":[{"id":"09d9fca","elType":"column","settings":{"_column_size":100,"_inline_size":null},"elements":[{"id":"940a213","elType":"widget","settings":{"editor":"<p>[rank_math_breadcrumb]<\/p>"},"elements":[],"widgetType":"text-editor"},{"id":"edf2802","elType":"widget","settings":{"title":"Learn how to build a relational database from Scratch. Create Tables, Queries, Forms and Reports to create a powerful System for your needs...","size":"large"},"elements":[],"widgetType":"heading"},{"id":"20f4e27","elType":"widget","settings":{"text":"Divider"},"elements":[],"widgetType":"divider"},{"id":"ce6c451","elType":"widget","settings":{"image":{"url":"https:\/\/www.flexicoach.com.au\/wp-content\/uploads\/2019\/06\/AccessPic.png","id":1247},"image_size":"full"},"elements":[],"widgetType":"image"},{"id":"c86a020","elType":"widget","settings":{"title":"FlexiCoach courses help you to really understand and use Excel. From Creating Formulas and Charts to Managing and Analyzing Data use the range of Excel tools available.","link":{"url":"https:\/\/products.office.com\/en-us\/excel","is_external":"","nofollow":"","custom_attributes":""},"size":"medium","header_size":"span","title_color":"#000000","text_shadow_text_shadow_type":"yes","text_shadow_text_shadow":{"horizontal":0,"vertical":0,"blur":0,"color":""}},"elements":[],"widgetType":"heading"}],"isInner":false}],"isInner":false},{"id":"77db696","elType":"section","settings":[],"elements":[{"id":"2a816ed","elType":"column","settings":{"_column_size":100,"_inline_size":null},"elements":[{"id":"cbf6cf2","elType":"widget","settings":{"wp":{"title":"Access Foundation","panels":[{"title":"Course Description","content_text":"In this course the participant will learn Database principles and concepts needed to simplify database creation and management. From creating tables and queries to designing user friendly forms and reports for your needs. The participant will also learn how to work with table relationships, controlling data. The course also covers creating and using queries. Perfect for those new to Microsoft Access.","content_text_selected_editor":"tinymce","initial_state":"closed"},{"title":"Prerequisites","content_text":"<p>This course has no specific requirements other than a working knowledge of Windows. It will be helpful to have used other Office applications to some degree.<\/p>\r\n","content_text_selected_editor":"tinymce","initial_state":"closed"},{"title":"Learning Outcomes","content_text":"<ul>\r\n<li>Overview of Microsoft Access<\/li>\r\n<li>Understanding Relational Databases<\/li>\r\n<li>Your first Database<\/li>\r\n<li>Creating and Updating a Table<\/li>\r\n<li>Linking Tables<\/li>\r\n<li>Controlling Data Input<\/li>\r\n<li>Create and Use a Query<\/li>\r\n<li>Modifying Queries<\/li>\r\n<li>Create and use Forms<\/li>\r\n<li>Create and Use Reports<\/li>\r\n<\/ul>\r\n","content_text_selected_editor":"tinymce","initial_state":"closed"}],"design":{"heading":{"background_color":"#828282","background_hover_color":"#8C8C8C","title_color":"#ffffff","title_hover_color":"","border_color":"","border_hover_color":"","border_width":"","border_width_unit":"px","so_field_container_state":"open"},"panels":{"background_color":"#F9F9F9","font_color":"","border_color":"","border_width":"","border_width_unit":"px","margin_bottom":"10","margin_bottom_unit":"px","so_field_container_state":"open"},"so_field_container_state":"open"},"_sow_form_id":"20354485685e8092f3e0786941441042","_sow_form_timestamp":"1585914251081"}},"elements":[],"widgetType":"wp-widget-sow-accordion"},{"id":"85bcd7d","elType":"widget","settings":{"button_type":"info","text":"Click to View Outline                      ","align":"center","selected_icon":{"value":"fab fa-adobe","library":"fa-brands"},"size":"md","icon_indent":{"unit":"px","size":5,"sizes":[]},"background_color":"#6EC1E4","hover_animation":"bounce-in","_background_background":"classic","_background_hover_transition":{"unit":"px","size":0.6,"sizes":[]},"link":{"url":"https:\/\/www.flexicoach.com.au\/wp-content\/uploads\/2020\/04\/Microsoft-Access-Foundation.pdf","is_external":"","nofollow":"","custom_attributes":""}},"elements":[],"widgetType":"button"}],"isInner":false}],"isInner":false},{"id":"fa99296","elType":"section","settings":[],"elements":[{"id":"9c06f17","elType":"column","settings":{"_column_size":100,"_inline_size":null},"elements":[{"id":"10ee7ce","elType":"widget","settings":{"wp":{"title":"Access Database Designer","panels":[{"title":"Course Description","content_text":"<p>In this course the participant will go beyond Access basics, and implement more sophistication to the database. This course covers, planning and scaling a database. Additional features to forms. and Creating and designing information specific reports.<\/p>\r\n","content_text_selected_editor":"tinymce","initial_state":"closed"},{"title":"Prerequisites","content_text":"<p>This course requires an understanding of Database concepts, and a basic knowledge of the Access application. For those new to Access, it is advisable to first consider the Access Foundation Course.<\/p>\r\n","content_text_selected_editor":"tinymce","initial_state":"closed"},{"title":"Learning Outcomes","content_text":"<ul>\r\n \t<li>Relational Database Theory<\/li>\r\n \t<li>Planning a Database<\/li>\r\n \t<li>Data Normalization<\/li>\r\n \t<li>Table Relationships<\/li>\r\n \t<li>Select Queries<\/li>\r\n \t<li>Query Techniques<\/li>\r\n \t<li>Query Joins<\/li>\r\n \t<li>Calculated Queries<\/li>\r\n \t<li>Parameter Queries<\/li>\r\n \t<li>Design a Form<\/li>\r\n \t<li>Form Controls<\/li>\r\n \t<li>Form Properties<\/li>\r\n \t<li>Custom Reports<\/li>\r\n<\/ul>","content_text_selected_editor":"tinymce","initial_state":"closed"}],"design":{"heading":{"background_color":"#828282","background_hover_color":"#8C8C8C","title_color":"#ffffff","title_hover_color":"","border_color":"","border_hover_color":"","border_width":"","border_width_unit":"px","so_field_container_state":"open"},"panels":{"background_color":"#F9F9F9","font_color":"","border_color":"","border_width":"","border_width_unit":"px","margin_bottom":"10","margin_bottom_unit":"px","so_field_container_state":"open"},"so_field_container_state":"open"},"_sow_form_id":"20354485685e8092f3e0786941441042","_sow_form_timestamp":"1585910775771"}},"elements":[],"widgetType":"wp-widget-sow-accordion"},{"id":"ec2e3ac","elType":"widget","settings":{"button_type":"info","text":"Click to View Outline                      ","align":"center","selected_icon":{"value":"fab fa-adobe","library":"fa-brands"},"size":"md","icon_indent":{"unit":"px","size":5,"sizes":[]},"background_color":"#6EC1E4","hover_animation":"bounce-in","_background_background":"classic","_background_hover_transition":{"unit":"px","size":0.6,"sizes":[]}},"elements":[],"widgetType":"button"}],"isInner":false}],"isInner":false},{"id":"1bb03a3","elType":"section","settings":[],"elements":[{"id":"d9a1f87","elType":"column","settings":{"_column_size":100,"_inline_size":null},"elements":[{"id":"8c4dce9","elType":"widget","settings":{"wp":{"title":"Access Developer","panels":[{"title":"Course Description","content_text":"<p>Access is an organic platform in that all the parts are interconnected. This course focuses on using Forms in conjunction with Queries and Tables in a way that the database is developed to use fewer queries and reports to output information for the user. This course takes databases to the next level, Also included are other query types, Macros, and an introduction to VBA for Access.<\/p>\r\n","content_text_selected_editor":"tinymce","initial_state":"closed"},{"title":"Prerequisites","content_text":"This course focuses on complex Access features, and requires a good understanding of Access Database Design.","content_text_selected_editor":"tinymce","initial_state":"closed"},{"title":"Learning Outcomes","content_text":"<ul>\r\n \t<li>Working with Unbound Forms<\/li>\r\n \t<li>Controls and Parameter Queries<\/li>\r\n \t<li>Action Queries<\/li>\r\n \t<li>Design a Macro<\/li>\r\n \t<li>Relating Macros to Controls<\/li>\r\n \t<li>Design Multi action Macros<\/li>\r\n \t<li>Introduction to Access VBA<\/li>\r\n \t<li>Running a VBA Basic Procedure<\/li>\r\n \t<li>Coding Conventions<\/li>\r\n \t<li>Access Object Model<\/li>\r\n \t<li>Variables<\/li>\r\n \t<li>Decision Making<\/li>\r\n \t<li>Loops<\/li>\r\n \t<li>Error Handling<\/li>\r\n \t<li>Database Maintenance<\/li>\r\n \t<li>Splitting the Database<\/li>\r\n \t<li>Database Security<\/li>\r\n<\/ul>","content_text_selected_editor":"tinymce","initial_state":"closed"}],"design":{"heading":{"background_color":"#828282","background_hover_color":"#8C8C8C","title_color":"#ffffff","title_hover_color":"","border_color":"","border_hover_color":"","border_width":"","border_width_unit":"px","so_field_container_state":"open"},"panels":{"background_color":"#F9F9F9","font_color":"","border_color":"","border_width":"","border_width_unit":"px","margin_bottom":"10","margin_bottom_unit":"px","so_field_container_state":"open"},"so_field_container_state":"open"},"_sow_form_id":"20354485685e8092f3e0786941441042","_sow_form_timestamp":"1585913898252"}},"elements":[],"widgetType":"wp-widget-sow-accordion"},{"id":"c4a3072","elType":"widget","settings":{"button_type":"info","text":"Click to View Outline                      ","align":"center","selected_icon":{"value":"fab fa-adobe","library":"fa-brands"},"size":"md","icon_indent":{"unit":"px","size":5,"sizes":[]},"background_color":"#6EC1E4","hover_animation":"bounce-in","_background_background":"classic","_background_hover_transition":{"unit":"px","size":0.6,"sizes":[]}},"elements":[],"widgetType":"button"}],"isInner":false}],"isInner":false},{"id":"0d70b78","elType":"section","settings":{"structure":"20"},"elements":[{"id":"680ca54","elType":"column","settings":{"_column_size":50,"_inline_size":52.436},"elements":[{"id":"4e378c9","elType":"widget","settings":{"title":"Included with Course:","size":"large","header_size":"h1","title_color":"#54595F"},"elements":[],"widgetType":"heading"},{"id":"aba8035","elType":"widget","settings":{"text":"Divider"},"elements":[],"widgetType":"divider"},{"id":"62dd0a3","elType":"widget","settings":{"image":{"url":"https:\/\/www.flexicoach.com.au\/wp-content\/uploads\/2020\/04\/CourseBenefits3.png","id":1583}},"elements":[],"widgetType":"image"}],"isInner":false},{"id":"ccc69d5","elType":"column","settings":{"_column_size":50,"_inline_size":47.459},"elements":[{"id":"ff7ca63","elType":"widget","settings":{"title":"For More Information:","size":"small","title_color":"#54595F"},"elements":[],"widgetType":"heading"},{"id":"5a6137f","elType":"widget","settings":{"editor":"<p>[everest_form id=\"1561\"]<\/p>","_background_background":"classic","_background_color":"#FFFFFF"},"elements":[],"widgetType":"text-editor"}],"isInner":false}],"isInner":false},{"id":"6dc7472c","elType":"section","settings":{"structure":"30","background_background":"classic","background_color":"#54595F"},"elements":[{"id":"412d418b","elType":"column","settings":{"_column_size":33,"_inline_size":null},"elements":[{"id":"5ec79832","elType":"widget","settings":{"title":"Business Apps","header_size":"h5"},"elements":[],"widgetType":"heading"},{"id":"55f5e965","elType":"section","settings":[],"elements":[{"id":"70a69adc","elType":"column","settings":{"_column_size":100,"_inline_size":null},"elements":[{"id":"36357d27","elType":"widget","settings":{"title":"Microsoft Excel<br>Microsoft Project<br>Microsoft Visio<br>Microsoft Access<br>Microsoft Word<br>Microsoft PowerPoint<br>Microsoft Publisher<br>Microsoft Outlook","header_size":"span"},"elements":[],"widgetType":"heading"}],"isInner":true}],"isInner":true}],"isInner":false},{"id":"7c9d278f","elType":"column","settings":{"_column_size":33,"_inline_size":null},"elements":[{"id":"4d53e0a3","elType":"widget","settings":{"title":"Analysis and Tech","header_size":"h5"},"elements":[],"widgetType":"heading"},{"id":"70bdb8cb","elType":"section","settings":[],"elements":[{"id":"6a98320","elType":"column","settings":{"_column_size":100,"_inline_size":null},"elements":[{"id":"2b5c47cc","elType":"widget","settings":{"title":"Microsoft Power Bi<br>Google Data Studio<br>Microsoft Power Pivot<br>Microsoft Power Automate<br>Microsoft Power Apps<br>Microsoft VBA<br>Microsoft Sharepoint","header_size":"span"},"elements":[],"widgetType":"heading"}],"isInner":true}],"isInner":true}],"isInner":false},{"id":"71d05780","elType":"column","settings":{"_column_size":33,"_inline_size":null},"elements":[{"id":"3a7cbfcd","elType":"widget","settings":{"title":"Additional","header_size":"h5"},"elements":[],"widgetType":"heading"},{"id":"2dfecbd8","elType":"section","settings":[],"elements":[{"id":"28764d14","elType":"column","settings":{"_column_size":100,"_inline_size":null},"elements":[{"id":"64ee14b9","elType":"widget","settings":{"title":"Training Files<br>Flexi-Blog<br>Submit a Review<br>Helpdesk Request<br>Learning Portal<br>Whats New","header_size":"span"},"elements":[],"widgetType":"heading"}],"isInner":true}],"isInner":true}],"isInner":false}],"isInner":false}]