|
Provided by: RAMCO Software Training VBA Programming for Microsoft Office ApplicationsTraining, Instruction and Documentation |
 |
Certificate Program
Provided by RAMCO Software Training
This course is intended for the person who has a strong familiarity with Microsoft Word, Excel, and Access and who would like to begin learning how to automate these programs. It introduces the audience to the programming concepts involved in the Visual Basic language while applying those concepts to the Microsoft Office programs.
The course uses a combination of lecture, hands-on practice, and independent exercises to introduce Visual Basic for Applications, a subset of the Visual Basic programming language. This course teaches how to create simple and complex applications from within the Microsoft Office programs. We will deal with both the visual part of Visual Basic and the language features. Not only do we cover how to write programming code for each of the Office programs, but also how to start and control Office applications from other applications. This enables the student to create single applications, which take advantage of the power of each of the Microsoft Office programs.
Related Software Programs or Products: Microsoft Office, Visual Basic
Related Awards, Degrees or Certifications: MCSD
Related Jobs or Careers: Programmer, IT Support, Help Desk, Software Development
|
|
||||||||||||||||||||||||
VBA Programming for Microsoft Office Applications
This course is intended for the person who has a strong familiarity with Microsoft Word, Excel, and Access and who would like to begin learning how to automate these programs. It introduces the audience to the programming concepts involved in the Visual Basic language while applying those concepts to the Microsoft Office programs.
Upon successful completion of the class, students should be able to:
understand the Visual Basic environment inside Microsoft Office,
create Sub Routines and Functions,
understand the concepts of Object Oriented Programming and Object Models,
use the Object Browser tool,
understand and work with all of the different kinds of Variables and Constants, which exist in the Visual Basic language,
read, write and edit Visual Basic loop structures and decision constructs,
create custom dialog boxes and utilize built-in dialog boxes,
work with Form controls such as Option Buttons, Check Boxes, and List Boxes,
understand and utilize Automation,
write robust error trapping code.
Upon successful completion of the class, students should be able to:
understand the Visual Basic environment inside Microsoft Office,
create Sub Routines and Functions,
understand the concepts of Object Oriented Programming and Object Models,
use the Object Browser tool,
understand and work with all of the different kinds of Variables and Constants, which exist in the Visual Basic language,
read, write and edit Visual Basic loop structures and decision constructs,
create custom dialog boxes and utilize built-in dialog boxes,
work with Form controls such as Option Buttons, Check Boxes, and List Boxes,
understand and utilize Automation,
write robust error trapping code.
About The Training Provider: RAMCO Software Training
RAMCO Software Training - RAMCO Software Training is a leader in innovative solutions for corporate computer software training on business software programs such as Microsoft Windows, Office, Project, Adobe Photoshop, InDesign, Acrobat, and Dreamweaver. Whether at your facility or in one of our conveniently located training centers in Seattle, Tacoma, or Tukwila, RAMCO Software Training delivers a comprehensive...
