• Overview
• Outline
• Schedule

About This Course

The three-day Microsoft Business Solutions Great Plains Modifier with VBA course explores using the Modifier and VBA tool to customize Microsoft Great Plains windows and reports. This course shows you how to modify windows based on user needs, make global changes to graphics and text, and add fields to forms. This course will also show you how to add VBA programming code to enhance the functionality of Microsoft Great Plains windows and reports.

A thorough understanding of these tools allows you to integrate data from Great Plains to external applications. You will learn how to work with third-party dictionaries within the VBA project. This course also teaches you how to change default values, populate data fields, and store and retrieve data saved in your own tables.

Audience Profile

Individuals desiring to increase their knowledge and the skills necessary to customize Great Plains windows and reports

Modifier with VBA training is recommended for anyone who plans to customize Microsoft Great Plains. The class is targeted toward developers or end users. Some knowledge of programming is helpful but not required.

Prerequites

Before attending this course, students must have:

• General knowledge of Microsoft Windows
• Working knowledge of Microsoft Business Solutions Great Plains
• Basic knowledge of database and programming i.e., experience with database using tools such as Microsoft Visual Basic and Microsoft Access is recommended.

At Course Completion

After completing this course, students will be able to:

• Modify Great Plains windows and reports to expand the functionality of the solutions
• Customize Great Plains to suite 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 Great Plains using Active Data Objects (ADO)
• Integrate Great Plains with external Microsoft applications
• Reference data within Third Party dictionaries