Duration 1 Days 6 CPD hours This course is intended for To ensure success, students should have completed Excel Essentials and Excel Functions Including Pivot Tables and Lookups or have the equivalent knowledge and experience. Overview Upon successful completion of this course, students will understand the programming environment of Visual Basic for applications and know how to create custom procedures and functions that can expand their ability to use Excel more effectively. This course is intended for the experienced Excel users that want to gain knowledge of visual basic for applications (VBA). Introduction to Macros Recording Macros Absolute and Relative How to Run a Macro Basics of Code Writing The VBA Environment (the ?VBE? window) Essential Tips, Tricks, Shortcuts Understanding VBA and Best Practice Crucial VBA Objects and Structures Variables and Data Types Conditionals (If, Select Case) Loops (For, Do) Interaction Interact with Data, Sheets, the Excel Application Interact with User (Message Box, Input Box) Errors Run Editing Debuging Handeling Errors Additional course details: Nexus Humans Excel - VBA Bootcamp training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Excel - VBA Bootcamp course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.
Duration 2 Days 12 CPD hours This course is intended for The primary audience for this course are persons who are new to reporting with Microsoft© SQL Server© Report Builder and SSRS, persons who are transitioning from another reporting software application, and persons who are existing Report Builder and SSRS report authors. The secondary audience for this course are persons who are using Report Designer (SSRS). Course participants may be business analysts, programmer analysts, data analysts, database administrators, or IT professionals and may or may not have experience with Microsoft© SQL Server© Report Builder and SSRS, programming (Visual Basic), and/or Transact-Structured Query Language (T-SQL) experience. Overview After completing this course, students will be able to: Create parameter reports. Create list reports. Format reports with complex expressions. Add images and subreports. Add drilldown and drillthrough functionality. Add sparklines, data bars, and indicators. In this course, students will continue their learning on the foundations of report writing with Microsoft© SQL Server© Report Builder and SSRS. The focus will be on report creation by connecting to a database and manipulating the data. 1 - Parameter Reports Parameterized Reporting Create Report Parameters Modify Report Parameters Provide Default Parameter Values Provide Available Values for Parameters Lab: Creating Parameterized Reports 2 - List Data Regions Introducing the List Data Region Create Reports Using List Data Regions Modify Reports Which Use List Data Regions Lab: Creating List Reports 3 - Enhancing Reports with Complex Expressions Formatting Reports Top N Reports Running Values Lab: Enhancing Reports with Complex Expressions 4 - Enhance Reports with Images and Subreports Add Images to Reports Retrieve Images from a Database Introducing SSRS (SQL Server Reporting Services) Report Server Add Subreports to Reports Lab: Working With Images and Subreports 5 - Drilldown and Drillthrough Reports Add and Configure Drilldown Reporting Add and Configure Drillthrough Reporting Lab: Add Drilldown and Drillthrough Functionality to Reports 6 - Sparklines, Data Bars, and Indicators Sparklines Data Bars Indicators Lab: Adding Sparklines, Data Bars, and Indicators to Reports Additional course details: Nexus Humans 55128 Writing Reports with Report Builder and SSRS Level 2 training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the 55128 Writing Reports with Report Builder and SSRS Level 2 course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.
Complete VB.Net training course description A hands on introduction to programming in Visual BASIC .Net. What will you learn Build Visual BASIC applications. Build simple components Debug Visual BASIC programs. Examine existing code and determine its function. Complete VB.Net training course details Who will benefit: Anyone wishing to program in Visual BASIC. Anyone wishing to build Windows based applications. Prerequisites: None although experience in another high level language would be useful. Duration 5 days Complete VB.Net training course contents Writing your first program Visual Studio, forms designer, running VB programs, the UI, properties, writing the code. Toolbox Controls Basic use, input controls, ActiveX controls. Menus and Dialog Boxes Menus, Dialog Box controls, event procedures. Visual Basic .NET variables and operators Variables, I/O, data types, constants, operators, Math Methods, precedence. Decision Structures and Loops and Timers Event-Driven programming, Ifâ¦Then, Select Case, Forâ¦Next Loops, Timer Control. Debugging Visual Basic .NET Programs Break Mode, watch & command windows. Structured Error Handling Try...Catch, Finally, Err Object, retry periods. Modules and Procedures Standard modules, public variables, procedures. Arrays and Collections to Manage Data Fixed-Size & dynamic Arrays, ReDim Preserve, object collections, Controls Collection. Text Files and String Processing Text Box object, Text String methods, sorting. Automating Office Applications Application objects, automation in VB, the Object Browser, the Process Component. Deploying Visual Basic .NET Applications Planning a deployment, ways to deploy an application, deployment projects, options. Managing Windows Forms Forms, positioning, manipulation, adding controls, organizing controls, Startup Object. Adding Graphics and Animation Effects System.Drawing namespace, coordinates, SystemPaint Event, animation, transparency. Inheriting Forms and Creating Base Classes Inheriting forms, inheritance picker, base classes and inheritance, classes in projects. Working with Printers PrintDocument class, Text Box object, Print Preview and Page Setup Dialog Boxes. Database programming with ADO.NET Databases, ADO.NET, Data Adapters, Datasets, Bound & Navigation Controls. Displaying database records, formatting DataGrid cells, updating the database. Displaying HTML Documents Using IE IE Object, Internet Controls, IE Events. Web Forms for Interactive Web Applications ASP.NET, Web Forms vs. Windows Forms, HTML controls, web applications, event procedures for web forms controls.
Automate your Excel workflow, accelerate your productivity, and master the fundamentals of programming with VBA!
Duration 1 Days 6 CPD hours This course is intended for To ensure success, students should have completed Excel Essentials and Excel Functions Including Pivot Tables and Lookups or have the equivalent knowledge and experience. Overview Upon successful completion of this course, students will be able to enhance productivity and efficiency by streamlining workflow, collaborate with others, and audit and analyse data. This course is designed for students desiring to gain skills necessary to create macros, collaborate with others, audit and analyse data, incorporate multiple data sources, and import data. Working with Multiple Worksheets and Workbooks Working with Named Ranges Link Cells Across Worksheets and Workbooks Use 3D References to Calculate Across Worksheets Consolidate Data Use Formula Auditing and Error Checking Reveal Formulas Trace Cell Precedents and Dependents Locate Errors in Formulas Watch and Evaluate Formulas Reviewing and Protecting Workbooks Control Data Entry via Data Validation Protect Workbook Access Protect Worksheets and Cell Content Add and Edit Comments Prepare a Workbook for Distribution Modify Excel's Default Settings Using Macros to Automate Workbook Functionality Create Macros via Recording Run Macros via Buttons and Shortcuts Assign Macros to the Quick Access Toolbar and Ribbon Assign Macros to Objects View Macro Code Forecasting and Analysis Data Use Conditional Formatting to Highlight, Sort and Filter Key Data Advanced Conditional Formatting using Formulas Create Sparklines to Visualise Data Add Trendlines to Charts to Visualise and Forecast Trends Use Data Tables and Scenarios to Project Potential Outcomes Use Goal Seek to Calculate Outcomes Forecast Data Trends Using Solver
Description Register on the AutoCAD Plugin Development Using VB.NET and Windows Forms today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a certificate as proof of your course completion. The AutoCAD Plugin Development Using VB.NET and Windows Forms course is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablets, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With This Course Receive a digital certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Certificate of Achievement After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for 9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for 15.99, which will reach your doorsteps by post. Method of Assessment You need to attend an assessment right after the completion of this course to evaluate your progression. For passing the assessment, you need to score at least 60%. After submitting your assessment, you will get feedback from our experts immediately. Who Is This Course For The course is ideal for those who already work in this sector or are aspiring professionals. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Course Content Course Outline Landing Page 00:02:00 Course Outline 00:03:00 Introduction Introduction 00:05:00 Who is this course for? 00:04:00 Tools Needed for this Course 00:01:00 What will you learn from this Course? What will you learn from this Course - Overview 00:06:00 Windows Form and Controls Windows Form and Controls - Overview 00:04:00 ControlsDemo Project - Overview 00:03:00 ControlsDemo Project - Creating the Project 00:04:00 Controls Demo Project - Designing the Form 00:19:00 ControlsDemo Project - Creating the Utility Class 00:10:00 ControlsDemo Project - Coding the Combobox Control 00:15:00 ControlsDemo Project - Coding the Textbox Control 00:10:00 ControlsDemo Project - Coding the Radiobutton Control 00:08:00 ControlsDemo Project - Coding the Checkbox Control 00:17:00 Developing Projects Draw Rectangle Project - Overview 00:03:00 Creating the DrawRectangle Project 00:04:00 DrawRectangle Project - Creating the Utility Class 00:20:00 DrawRectangle Project - Designing the Form 00:15:00 DrawRectangle Project - Coding the User Interface Part 1 00:24:00 DrawRectangle Project - Coding the User Interface Part 2 00:18:00 DrawRectangle Project - Running the Program 00:06:00 Automate Update Layer Project - Overview 00:02:00 Creating the AutomateUpdateLayer Project 00:03:00 AutomateUpdateLayer Project - Creating the Utility Class 00:17:00 AutomateUpdateLayer Project - Designing the User Interface 00:07:00 AutomateUpdateLayer Project - Coding the Form 00:18:00 AutomateUpdateLayer Project - Running the Program 00:07:00 Automatic Block Extractor Project - Overview 00:03:00 AutomaticBlockExtractor Project - Creating the Project 00:03:00 AutomaticBlockExtractor Project - Creating the User Interface 00:09:00 AutomaticBlockExtractor Project - Coding the Form 00:27:00 AutomaticBlockExtractor Project - Creating the Utility Class 00:27:00 AutomaticBlockExtractor Project - Running the Program 00:10:00 AutomateUpdateTextStyles Project - Overview 00:03:00 AutomateUpdateTextStyle Project - Creating the Project 00:02:00 AutomateUpdateTextStyle Project - Creating the User Interface 00:09:00 AutomateUpdateTextStyle Project - Coding the Form 00:20:00 AutomateUpdateTextStyle Project - Coding the Utility Class 00:16:00 AutomateUpdateTextStyle Project - Running the Program 00:08:00 Multiple Plot DWG to PDF Project - Overview 00:03:00 MultiplePlotDWGtoPDF Project - Creating the Project 00:04:00 MultiplePlotDWGtoPDF Project - Creating the User Interface 00:09:00 MultiplePlotDWGtoPDF Project - Coding the Form 00:20:00 MultiplePlotDWGtoPDF Project - Creating the Utility Class 00:30:00 MultiplePlotDWGtoPDF Project - Running the Program 00:13:00 Multiple Object Extractor Project - Overview 00:03:00 MultipleObjectExtractor Project - Creating the Project 00:02:00 MultipleObjectExtractor Project - Creating the User Interface 00:15:00 MultipleObjectExtractor Project - Coding the Form Load Event 00:05:00 MultipleObjectExtractor Project - Coding the Browse Buttons 00:10:00 MultipleObjectExtractor Project - Coding the Extract Button 00:20:00 MultipleObjectExtractor Project - Coding the ProcessDrawing Method 00:09:00 MultipleObjectExtractor Project - Coding the ProcessObjectExtraction Method 00:11:00 MultipleObjectExtractor Project - Coding the ExtractCircle Method 00:03:00 MultipleObjectExtractor Project - Coding the ExtractPolyline Method 00:09:00 MultipleObjectExtractor Project - Coding the ExtractMText Method 00:05:00 MultipleObjectExtractor Project - Coding the ExtractBlock Method 00:05:00 MultipleObjectExtractor Project - Running the Program 00:15:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.
Register on the Microsoft Excel: Excel Sheet Comparison with VBA today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a digital certificate as a proof of your course completion. The Microsoft Excel: Excel Sheet Comparison with VBA is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Microsoft Excel: Excel Sheet Comparison with VBA Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Microsoft Excel: Excel Sheet Comparison with VBA, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Introduction to Compare Data Workbook Introduction to Compare Data Workbook 00:06:00 Download Resources 00:00:00 Key requirements for Comparing any Datasets or Worksheets 00:03:00 Tool to Compare Datasets or Worksheets 00:06:00 Comprehensive Introduction to Compare Data Excel VBA Workbook Overview of Compare Data Workbook 00:09:00 Most Important things to remember before you use compare data workbook 00:03:00 IMPORTANT - First Column as KEY Column with UNIQUE Values 00:09:00 Deep Dive into Compare Data Workbook's Environment 00:10:00 How to Change Header Rows for your data 00:06:00 Modify VBA Codes to Suit Your Needs Basics of Using macro enabled Excel files and Code Modules 00:04:00 Changing the Main two sheets name, variance tags in VBA Code 00:05:00 Changing various elements across VBA Code modules 00:05:00 Clear Sheet data button VBA Code 00:04:00 Data Cleaning, Format and Structure Your Datasets with Power Query Convert Row data into Structured, clean and formatted data with Power Query 1 00:07:00 Convert Row data into Structured, clean and formatted data with Power Query 2 00:07:00 Practical and Real world application of Compare Data Workbook Mutual Funds Portfolio - Finding Variances at two different times 00:07:00 Comprehensive Payroll Analysis - Creating Powerful Dashboard 1 00:05:00 Comprehensive Payroll Analysis - Creating Powerful Dashboard 2 00:07:00 Comprehensive Payroll Analysis - Creating Powerful Dashboard 3 00:08:00 Comprehensive Payroll Analysis - Creating Powerful Dashboard 4 00:07:00 Comprehensive Payroll Analysis - Creating Powerful Dashboard 5 00:08:00 Conclusion IMPORTANT Facts and Limitation of Compare Data Workbook 00:03:00 Conclusion 00:01:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.
Course Overview How great would it be if you could create designs and VBA applications that can interact with users? Learn AutoCAD techniques from this Fundamental of AutoCAD VBA Programming course and be able to create VBA applications and graphical user interface that interacts with users effectively. This Fundamental of AutoCAD VBA Programming course will teach you VBA integrated development environment and AutoCAD VBA object model through presentation and examples. You will learn about the AutoCAD database dictionary, conditions and decisions, applications, drawing techniques, debugging and handling errors and many other techniques that will help you to design using AutoCAD. by the end of the course you will be able to create small to medium complexity applications. Learning Outcomes Understand the functions of AutoCAD VBA programming Develop web applications and graphical user interface using AutoCAD Manipulate AutoCAD objects and automate repetitive tasks Draw different AutoCAD objects using VBS Learn what user control is Learn VBS Syntax and be able to use it with Microsoft Office applications Who is this course for? This course is for anyone who wants to learn about the functions of AutoCAD and use AutoCAD for designing. This course will teach you AutoCAD VBA programming step by step. Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path Fundamental of AutoCAD VBA Programming is a useful qualification to possess and would be beneficial for any related profession or industry such as: AutoLISP Programmers Designers Engineers Unit 01: Introduction Module 01: Introduction 00:04:00 Module 02: Course Content Identified 00:06:00 Unit 02: VBA Integrated Development Environment (IDE) Module 01: Setting-up the Environment (Installing VBA IDE) 00:01:00 Module 02: Downloading and Installing AutoCAD VBA IDE 00:04:00 Module 03: Identify and Understand VBA IDE Components (Toolbars and Windows) 00:03:00 Module 04: VBA IDE Walkthrough 00:14:00 Unit 03: Understanding AutoCAD Object Model in VBA Module 01: Examining AutoCAD VBA Object Model Structure 00:07:00 Module 02: Examining AutoCAD Object Model Structure Part 2 00:06:00 Unit 04: Using Variables in VBA Module 01: Working on Variables 00:01:00 Module 02: Using Variables in the Program 00:14:00 Unit 05: User Forms and Controls Module 01: User Forms and Controls Topic Breakdown 00:02:00 Module 02: Using Label, Textbox and Command Button Controls 00:10:00 Module 03: Using ListBox Control 00:06:00 Module 04: Using ComboBox Control 00:09:00 Module 05: Using CheckBox Control 00:08:00 Module 06: Using OptionButton Control 00:03:00 Module 07: Using MultiPage Control 00:10:00 Module 08: Using MultiPage Control Continued 00:14:00 Module 09: Using Frame Control 00:03:00 Unit 06: Conditionals and Decisions in VBA Module 01: Conditions and Decisions Course Outline 00:01:00 Module 02: IF-THEN-ELSE Condition 00:02:00 Module 03: IF-THEN-ELSEIF Condition 00:04:00 Module 04: Conditional Operators in VBA 00:04:00 Module 05: Logical Operators in VBA 00:07:00 Module 06: SELECT CASE Statement in VBA 00:05:00 Unit 07: Looping and Iterations in VBA Module 01: Looping and Iterations Overview 00:02:00 Module 02: Using DO-WHILE Loop in VBA 00:04:00 Module 03: Using DO-UNTIL Loop in VBA 00:02:00 Module 04: Using FORNEXT Loop in VBA 00:02:00 Module 05: Using FOREACHNEXT Loop in VBA 00:03:00 Unit 08: Drawings Objects in VBA Module 01: Drawing Objects Overview 00:01:00 Module 02: Draw a Line Object using Utility Function 00:03:00 Module 03: Draw a Line Object using Points from User's Input 00:07:00 Module 04: Draw a Circle Object Using Utility Functions 00:03:00 Module 05: Draw a Text Object using Utility Functions 00:05:00 Module 06: Draw a LWPolyline and Polyline Objects 00:06:00 Unit 09: Code Debugging in VBA Module 01: Code Debugging Overview 00:01:00 Module 02: Code Debugging in VBA Demo 00:12:00 Module 03: Code Debugging in VBA Demo Continued 00:02:00 Unit 10: Error Handling in VBA Module 01: Error Handling Course Outline 00:02:00 Module 02: Error Handling in VBA Demo 00:13:00 Unit 11: Conclusion Module 01: Conclusion and Thank you! 00:01:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
Overview This comprehensive course on AutoCAD Programming using VB.NET with Windows Forms will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This AutoCAD Programming using VB.NET with Windows Forms comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this AutoCAD Programming using VB.NET with Windows Forms. It is available to all students, of all academic backgrounds. Requirements Our AutoCAD Programming using VB.NET with Windows Forms is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 6 sections • 61 lectures • 09:51:00 total length •Module 01: Course Outline: 00:03:00 •Module 02: Introduction: 00:05:00 •Module 03: Who is this course for?: 00:04:00 •Module 04: Tools Needed for this Course: 00:01:00 •Module 01: What will you learn from this Course - Overview: 00:06:00 •Module 01: Windows Form and Controls - Overview: 00:04:00 •Module 02: ControlsDemo Project - Overview: 00:03:00 •Module 03: ControlsDemo Project - Creating the Project: 00:04:00 •Module 04: Controls Demo Project - Designing the Form: 00:19:00 •Module 05: ControlsDemo Project - Creating the Utility Class: 00:10:00 •Module 06: ControlsDemo Project - Coding the Combobox Control: 00:15:00 •Module 07: ControlsDemo Project - Coding the Textbox Control: 00:10:00 •Module 08: ControlsDemo Project - Coding the Radiobutton Control: 00:08:00 •Module 09: ControlsDemo Project - Coding the Checkbox Control: 00:17:00 •Module 01: Draw Rectangle Project - Overview: 00:03:00 •Module 02: Creating the DrawRectangle Project: 00:04:00 •Module 03: DrawRectangle Project - Creating the Utility Class: 00:20:00 •Module 04: DrawRectangle Project - Designing the Form: 00:15:00 •Module 05: DrawRectangle Project - Coding the User Interface Part 1: 00:24:00 •Module 06: DrawRectangle Project - Coding the User Interface Part 2: 00:18:00 •Module 07: DrawRectangle Project - Running the Program: 00:06:00 •Module 08: Automate Update Layer Project - Overview: 00:02:00 •Module 09: Creating the AutomateUpdateLayer Project: 00:03:00 •Module 10: Automate Update Layer Project - Creating the Utility Class: 00:17:00 •Module 11: AutomateUpdateLayer Project - Designing the User Interface: 00:07:00 •Module 12: AutomateUpdateLayer Project - Coding the Form: 00:18:00 •Module 13: AutomateUpdateLayer Project - Running the Program: 00:07:00 •Module 14: Automatic Block Extractor Project - Overview: 00:03:00 •Module 15: AutomaticBlockExtractor Project - Creating the Project: 00:03:00 •Module 16: AutomaticBlockExtractor Project - Creating the User Interface: 00:09:00 •Module 17: AutomaticBlockExtractor Project - Coding the Form: 00:27:00 •Module 18: AutomaticBlockExtractor Project - Creating the Utility Class: 00:27:00 •Module 19: AutomaticBlockExtractor Project - Running the Program: 00:10:00 •Module 20: AutomateUpdateTextStyles Project - Overview: 00:03:00 •Module 21: AutomateUpdateTextStyle Project - Creating the Project: 00:02:00 •Module 22: AutomateUpdateTextStyle Project - Creating the User Interface: 00:09:00 •Module 23: AutomateUpdateTextStyle Project - Coding the Form: 00:20:00 •Module 24: AutomateUpdateTextStyle Project - Coding the Utility Class: 00:16:00 •Module 25: AutomateUpdateTextStyle Project - Running the Program: 00:08:00 •Module 26: Multiple Plot DWG to PDF Project - Overview: 00:03:00 •Module 27: MultiplePlotDWGtoPDF Project - Creating the Project: 00:04:00 •Module 28: MultiplePlotDWGtoPDF Project - Creating the User Interface: 00:09:00 •Module 29: MultiplePlotDWGtoPDF Project - Coding the Form: 00:20:00 •Module 30: MultiplePlotDWGtoPDF Project - Creating the Utility Class: 00:30:00 •Module 31: MultiplePlotDWGtoPDF Project - Running the Program: 00:13:00 •Module 32: Multiple Object Extractor Project - Overview: 00:03:00 •Module 33: MultipleObjectExtractor Project - Creating the Project: 00:02:00 •Module 34: MultipleObjectExtractor Project - Creating the User Interface: 00:15:00 •Module 35: MultipleObjectExtractor Project - Coding the Form Load Event: 00:05:00 •Module 36: MultipleObjectExtractor Project - Coding the Browse Buttons: 00:10:00 •Module 37: MultipleObjectExtractor Project - Coding the Extract Button: 00:20:00 •Module 38: MultipleObjectExtractor Project - Coding the ProcessDrawing Method: 00:09:00 •Module 39: MultipleObjectExtractor Project - Coding the ProcessObjectExtraction Method: 00:11:00 •Module 40: MultipleObjectExtractor Project - Coding the ExtractLine Method: 00:09:00 •Module 41: MultipleObjectExtractor Project - Coding the ExtractCircle Method: 00:03:00 •Module 42: MultipleObjectExtractor Project - Coding the ExtractPolyline Method: 00:09:00 •Module 43: MultipleObjectExtractor Project - Coding the ExtractMText Method: 00:05:00 •Module 44: MultipleObjectExtractor Project - Coding the ExtractBlock Method: 00:05:00 •Module 45: MultipleObjectExtractor Project - Running the Program: 00:15:00 •Module 01: Conclusion: 00:01:00 •Assignment - AutoCAD Programming using VB.NET with Windows Forms: 00:00:00