• Home
• Course Catalogue
• Certifications
• Onsite Training
• Scheduled Training
• E-Learning
• Managed Services
• Consulting
• Company
• Special Offers
• News
• Links
• Enquiry And Feedback Form

Training Course Outline

IT Vendor Courses   Microsoft Great Plains Training Courses

M8381: Great Plains V8.0 Modifier with VBA

View course dates

Course Duration: 3 days

Course Code: M8381

Course Description:

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.

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.

Prerequisites:

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.

This course includes the following modules:

Modifier Overview

• Modifier Features and Benefits
• Getting Started
• Overview of the Great Plains Modifier
• Test Your Skills - Exercises

Modifying Window and Form Properties

• Setting Window Properties
• Changing the Opening Position of a Window
• Customizing Menus

Customizing Window Layouts

• Changing Individual Window Displays
• Modifying Fields in a Great Plains Window
• Adding Fields to a Window
• Adding Fields to a Scrolling Window
• Setting the Tab Sequence
• Adding Graphics to a Window

Changing Resources

• Changing Other Global Resources
• Pictures
• Native Pictures
• Data Types and Formats
• Customizing Strings
• Customizing Messages

VBA Overview

• Introduction
• Supported VBA 6.0 Features
• Great Plains VBA Components
• Building a User Form
• Variable Declarations
• Compiling and Debugging VBA

Working with Windows and Window Fields

• Overview
• Adding Windows and Window Fields to your Project
• Using Methods and Properties
• Using Events

Working with Grids and Grid Fields

• Adding Grids and Grid Fields to your Project
• Using Methods and Properties
• Using Events

 

To make an enquiry for this course to be run ONSITE at your location, click here or call Sales on +44 (0) 20 7620 0033.

Perpetual Solutions are a global provider of onsite training solutions throughout London, UK and the rest of the world. For scheduled training our UK partner network provides an unrivalled choice of courses.

Save as PDF

Print this course