8520: Modifier with Visual Basic with Applications (VBA) in Microsoft Dynamics GP 9.0

8520: Modifier with Visual Basic with Applications (VBA) in Microsoft Dynamics GP 9.0 Course Description

Intended Audience for the 8520: Modifier with Visual Basic with Applications (VBA) in Microsoft Dynamics GP 9.0 Course

• Individuals desiring to increase their knowledge and the skills necessary to customize Dynamics GP windows and reports.
• Modifier with VBA training is recommended for anyone who plans to customize Microsoft Dynamics GP. The class is targeted toward developers or end users. Some knowledge of programming is helpful but not required.
• Before attending this course, students must have general knowledge of Microsoft Windows, Microsoft Dynamics GP.Basic knowledge of database and programming i.e., experience with database using tools such as Microsoft Visual Basic and Microsoft Access is recommended.

8520: Modifier with Visual Basic with Applications (VBA) in Microsoft Dynamics GP 9.0 Course Objectives

• Modify Dynamics GP windows and reports to expand the functionality of the solutions
• Customize Dynamics GP to suit user needs
• Control security for modified windows and reports to ensure proper access to approved users
• Capture and store additional data within the system while maintaining integration to the financial series
• Integrate external data with Dynamics GP using Active Data Objects (ADO)
• Reference data within Third Party dictionaries

8520: Modifier with Visual Basic with Applications (VBA) in Microsoft Dynamics GP 9.0 Course Outline

1. Modifier Overview
   1. Modifier Features and Benefits
   2. Getting Started
   3. Overview of the Dynamics GP Modifier
2. Modifying Window and Form Properties
   1. Setting Window Properties
   2. Changing the Opening Position of a Window
3. Customizing Window Layouts
   1. Changing Individual Window Displays
   2. Modifying Fields in a Dynamics GP Window
   3. Adding Fields to a Window
   4. Adding Fields to a Scrolling Window
   5. Setting the Tab Sequence
   6. Adding Graphics to a Window
4. Changing Resources
   1. Changing Other Global Resources
   2. Pictures
   3. Native Pictures
   4. Data Types and Formats
   5. Customizing Strings
   6. Customizing Messages
5. VBA Overview
   1. Introduction
   2. Supported VBA 6.0 Features
   3. Dynamics GP VBA Components
   4. Building a User Form
   5. Variable Declarations
   6. Compiling and Debugging VBA
6. Working with Windows and Window Fields
   1. Overview
   2. Adding Windows and Window Fields to your Project
   3. Using Methods and Properties
   4. Using Events
7. Working with Grids and Grid Fields
   1. Adding Grids and Grid Fields to your Project
   2. Using Methods and Properties
   3. Using Events
8. Storing Additional Data
   1. Dynamics User Object Store (DUOS) Overview
   2. Using Methods and Properties for DUOS Objects
   3. Using DUOS Objects with Dynamics GP
9. Working with Reports and Report Fields
   1. Overview
   2. Adding Reports and Report Fields to your VBA Project
   3. Using Methods and Properties for Report Fields
   4. Using VBA Functions in your Project
   5. Using Report Events
10. Accessing Data Using ODBC
    1. Overview
    2. Setup and Installation of ODBC Drivers
    3. Setup and Installation of Data Access Method
11. Working with Multiple Third-Party VBA Projects
    1. Working With Objects in Other Dictionaries
12. Distributing Your VBA Project
    1. Distributing VBA Customizations

Benefits of taking the 8520: Modifier with Visual Basic with Applications (VBA) in Microsoft Dynamics GP 9.0 course at NetCom

• Why choose Microsoft Dynamics Training at NetCom Learning?
  As a recognition for training excellence, NetCom Learning was chosen by Microsoft as the 2007 Worldwide Learning Solutions Partner of the year out of 1400 training companies.

  In addition, we have won numerous other training awards for quality and customer satisfaction by CompTIA, EC-Council and other vendors. We are simply passionate about learning and achieving the highest customer satisfaction in your learning experience!

  See the training value proposition below:

  Why Microsoft Dynamics Training at NetCom? NetCom Information Technology is a Microsoft Gold Certified Partner for Learning Solutions (CPLS). CPLS is the premier training channel and delivery mechanism for Microsoft Dynamics training content. On July 11, NetCom was honored by Microsoft as its Learning Solutions Partner of the Year. Selected as the Number One CPLS, from over 1400 worldwide CPLS's, Microsoft recognized our commitment and ability to deliver high-quality learning services using a consultative engagement model. We could not have achieved this coveted status without the help and support of our customers and well wishers - thank you!! Microsoft Certified Partner for Learning Solutions Value Proposition: Microsoft Certified Partner for Learning Solutions Non-authorized Training Center Only MCT (Microsoft Certified Trainers) are authorized to teach the class Non MCT can teach the course Taught using Microsoft Authorized Courseware (MOC), includes free evaluation software and online training Do not have access to official courseware Partners adhere to stringent Microsoft designated lab requirements Computer and lab equipment may not be up to requirements of course Successful candidates are awarded Certificate of Completion directly from Microsoft for most of the courses Not authorized to issue Certificate of Completion Overall, a better quality training experience Substandard training experience

• NetCom provides Authorized Training
  NetCom Learning is a Microsoft Gold Certified Partner for Learning Solutions (CPLS), Cisco Learning Partner, CompTIA Platinum Partner, EC-Council Accredited Training Center, Adobe Authorized Training Center, Autodesk Authorized Training Center and many others. We are proud to offer the highest quality, authorized training solutions from our many partners for our customers.

  See our comprehensive list of partner authorizations.

• Award winning, world-class Instructors

  Ginger M. - Bachelor's Degree in Accounting and a Masters of Business Administration from Rutgers University. - Over 9 years of experience as a Master Certified Trainer. Expert in MS Dynamics GP Financials, Installation, HR/Payroll, Project Accounting, Inventory and Integration Manager. - Project Manager to various MS Dynamics Great Plains implementations. Bio: Ginger holds a Bachelor's Degree in Accounting and a Masters of Business Administration from Rutgers University. Her career started as an Auditor for Deloitte & Touché and over the years she developed her passion for Microsoft Dynamics, implementing Dynamics GP and Project Cost in the Professional Services, Commercial Real Estate and Medical Facilities vertical markets. Ginger's experience with Microsoft Dynamics is unparalleled. As a Certified Master Dynamics trainer, she stays abreast of the latest Dynamics modules and shares experience with a very hands-on training technique at NetCom Learning.

  Ignacio J. - Designs and architects Microsoft IT solutions since the early 1990s. - Hands-on experience in multiple Microsoft Dynamics products including CRM, GP, SL, AX and NAV since 2004. - Taught over 250 courses at NetCom Learning. Bio: Ignacio is a Senior Solutions Architect, Civil Engineer and Certified Expert Trainer. He has been designing and architecting Microsoft IT solutions since the early 1990s, and has extensive experience developing scalable and high performance integration solutions. In 2004, Ignacio expanded into business management and accounting software as well, where he gained hands-on experience in many Microsoft Dynamics products including CRM, GP, SL, AX and NAV. Ignacio holds a library of industry-wide certifications from Microsoft and other leading IT vendors. He has taught over 250 courses at NetCom Learning and is revered by students for his wide-ranging IT expertise.

  Lynn D. - Over 25 years of experience working as Senior Financial Analyst and Senior Auditor. - Professor of Graduate Management and Business School at the University of Phoenix since 2007. - Microsoft Certifications in Financials, Trade & Logistics, Production and Human Resources Management as well as Microsoft Certified Trainer (MCT) since 2009. Bio: Lynn is a very accomplished Senior Financial Analyst and Senior Auditor with over 25 years of experience. She has been a Microsoft Certified Trainer since 2009 and a Professor of Graduate Management and Business School at University of Phoenix since 2007. In addition to several other Microsoft certifications, she is also a specialist in Microsoft Dynamics AX. Lynn has taught several Microsoft Dynamics AX courses at NetCom Learning and is described by her students as very knowledgeable, qualified, and patient with her approach. Her classes are very dynamic and energetic, just as the course per se.

  Ramesh P. Ramesh holds a Masters Degree in Computer Science with specialization in Information Security and is pursuing his Doctoral degree in IT from the University of South Australia (UniSA). He is a one of a kind trainer - he has been working in the IT field since 1995 and is an expert in C#, VB.NET, ASP.NET, Java/J2EE, PL/SQL, VB, ASP, and XML technologies. Ramesh also has extensive experience developing and implementing BizTalk and SharePoint in large corporations, as well as more than 10 years experience working with Oracle and SQL server/Sybase databases. With more than 19 certifications, Ramesh is an IT guru and trainer with worldwide experience, which includes presentations and trainings across US, Asia, and Middle East. He is a full time instructor at NetCom Learning and we couldn't be happier in having him as one of our Subject Matter Experts.

  See more...  
• Actual Client Testimonials

  May 21 2012 The lecturer is quite personable and is quite helpful with making sure we understand the material we have covered. He is also quite knowledge in the subject area. This training has cleaned up a lot of areas that I have been having issues with in my work environment and I will surely be able to put a lot of it in to practice. -Candice C. Course(s) Taken Microsoft Dynamics GP 2010 - Financials and SQL Reporting - Accelerated (MCTS)

  
  

  May 21 2012 Good course. Good service. Good instructor. -Raman T. Course(s) Taken Microsoft Dynamics AX 2012 - Financials and Trade and Logistics - Accelerated

  
  

  May 21 2012 The instructor did an incredible job of presenting. -Kelly D. Course(s) Taken Microsoft Dynamics AX 2012 - Financials and Trade and Logistics - Accelerated

  
  

  May 21 2012 The class provided the background I will need to build upon upcoming responsibilities. Satisfactory on all counts. -John B. Course(s) Taken Microsoft Dynamics AX 2012 - Financials and Trade and Logistics - Accelerated

  
  

  May 21 2012 Stan is an excellent instructor. He made the course very informative and kept it interesting. Sebastian S. Course(s) Taken Microsoft Dynamics GP 2010 - Installation and Configuration - Accelerated (MCTS)

  
  

  May 21 2012 Classes were awesome! Our teacher, Mr. Smith, was entertaining and kept us motivated. -Lily L. Course(s) Taken Microsoft Dynamics GP 2010 - Financials and SQL Reporting - Accelerated (MCTS)

  
  

  May 07 2012 It was a good experience. It will help me in my new position loading the CRM practices. -Adolfo R. Course(s) Taken Microsoft Dynamics CRM 2011 - Accelerated

  
  

  Mar 12 2012 Ramesh our instructor was amazing. He has been the second amazing instructor through you guys!!! Nice, Knowledgeable and fun. -Kyle P. Course(s) Taken Microsoft Dynamics CRM 2011 - Accelerated

  
  
• Awards won by NetCom
  NetCom Learning is an award winning, customer focused company. We are simply Passionate About Learning!

  See our list of awards.

• Specialized Boot Camp Training

  

  This training is also available as a boot camp. NetCom is world famous for delivering specialized boot camp training to our clients.

  For answers to questions regarding our boot camp training delivery format, please refer to our Boot Camp FAQ section.

Enrollment Options for the 8520: Modifier with Visual Basic with Applications (VBA) in Microsoft Dynamics GP 9.0 course

• Contact us to customize this class with your own dates, times and location. You can also call 1-888-563-8266 or chat live with an Educational Consultant.

Training Delivery Methods

• Classroom Training
  NetCom’s classroom training ensures that you have state-of-the-art tools, techniques and practices you need to succeed on the job. Our instructors are active practitioners and true masters in their fields. With convenient classes at multiple learning centers across the US, you never have to go far to get ahead.

• Live Online Training (LOT)
  NetCom’s premium Live Online Training (we call it LOT) is the ultimate in convenience and cost-effectiveness. LOT combines interactive video instruction via the latest web conference technology, and post-class access to learning labs for a best-in-class learning experience.
  Learn more about LOT

• Boot Camp Training
  NetCom’s intensive boot camps are designed to advance your skills in the shortest possible amount of time and get you certified. Boot camps go at a faster pace and often run for longer days, so you must have some level of subject matter experience before enrolling. Boot camps have mandatory assessment tests to ensure no one will slow down the class for other students. Learn more about Boot Camps

• Private Onsite Training
  With NetCom’s private training programs, you decide where and when courses are held. Tailor the training to reflect your industry, corporate culture, goals and schedule. You pick the course content, length of training and instructional technique. Save money by doing bulk customized training.
  Learn more about Private Onsite Training

• Private 1-on-1 Training
  NetCom’s private 1-on-1 training focuses on the highest quality training possible. You get individualized, full attention from the instructor and you decide where and when courses are held. The training is custom tailored to reflect your industry, corporate culture, goals and schedule. You pick the course content, length of training and instructional technique.
  Learn more about Private 1-on-1 Training

Call us Toll-free at 1-888-563-8266 FREE Training Inquiry form Website Live Chat Contact us via Email: info@netcomlearning.com