[{"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":"<p>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 a user friendly forms and reports for your needs. The participant will also learn how to work with table relationships, controlling data and working query design and application. This course is perfect for those new to Microsoft Access.<\/p>\r\n","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 \t<li>Overview of Microsoft Access<\/li>\r\n \t<li>Understanding Relational Databases<\/li>\r\n \t<li>Your first Database<\/li>\r\n \t<li>Creating and Updating a Table<\/li>\r\n \t<li>Linking Tables<\/li>\r\n \t<li>Controlling Data Input<\/li>\r\n \t<li>Create and Use a Query<\/li>\r\n \t<li>Modifying Queries<\/li>\r\n \t<li>Create and use Forms<\/li>\r\n \t<li>Create and Use 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":"1585910854839"}},"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":[]}},"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":"Excel Essentials","panels":[{"title":"Course Description","content_text":"<p>In the Excel Foundation Training Course the student will learn all the essentials in Excel, from Formatting, Cells, Data and Numbes to working with Rows and Columns. Gain ground level understanding of Formulas and Functions that will hold you in good stead, in creating more complex calculations in the future. This course is a must not only for newbies to Excel, but even for those who have been using this Amazing Application for a while.<\/p>\r\n","content_text_selected_editor":"tinymce","initial_state":"closed"},{"title":"Prerequisites","content_text":"","content_text_selected_editor":"tinymce","initial_state":"closed"},{"title":"Learning Outcomes","content_text":"","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":"1585565406898"}},"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}]