• 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 Dynamics Training Courses

M8520: Microsoft Dynamics GP 9.0 Modifier with VBA

View course dates

Course Duration: 3 days

Course Code: M8520

Course Description:

The three-day Microsoft DynamicsT GP Modifier with VBA course explores using the Modifier and VBA tool to customize Microsoft Dynamics GP 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 Dynamics GP windows and reports.

 

A thorough understanding of these tools allows you to integrate data from Dynamics GP 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 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.

Prerequisites:

Before attending this course, students must have:

- General knowledge of Microsoft Windows
- Working knowledge of 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.

Relevant Certifications:

Microsoft Certified Business Management Solutions Specialist: For Dynamics GP

This course includes the following modules:

Modifier Overview

• This chapter gives students a general overview of the features and benefits of using Modifier. It also informs the student how to locate and store the customized windows and forms.

Modifying Window and Form Properties

• This chapter focuses on the procedures used to customize window and form properties. You examine in detail the options available to customize windows and forms to reflect the way your organization does business. Time is spent discussing the benefits of using changing window properties.

Customizing Window Layouts

• This chapter explores how to customize window displays. Learn how to modify fields in the window layout. Time is spent discussing how to create and add fields to an existing Dynamics GP window. Time is also spent learning how to work with scrolling windows. Learn how to set the tab sequence and how to add graphics to a window.

Changing Resources

• This chapter examines the steps necessary to change global resources. This process includes making a change to global resources and having that change displayed throughout the entire dictionary. Time is spent discussing resources that can be customized globally and what affect the change might have.

VBA Overview

• This chapter examines the available VBA components. Methods, Properties and Events are introduced in this section. Time is spent discussing how and why to create User Forms. Time is also spent discussing what variables are and how to use them. You will also learn how to compile and debug code within VBA.

Working with Windows and Window Fields

• This chapter examines the steps necessary to add window and window fields to the VBA project. Time is spent discussing what methods and events are useful to customize displays or change the business logic of a window. Events will be used to execute VBA code you write. This section is filled with hands-on exercises to improve VBA skills.

Working with Grids and Grid Fields

• This chapter examines the steps necessary to add grids and grid fields to the VBA project. Time is spent discussing the different events used to execute VBA code for grids. This section is filled with hands-on exercises to improve VBA skills.

 

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