|
|
|
Introduction to VBA
|
| Price: |
$99.00 |
| Business Focus: |
Database Management & Programming |
| Instructor: |
Ruth Hadad |
| Course Code: |
vba |
| Delivery Method: |
Instructor-led Online Course |
| Frequently Asked Questions |
|
|
| Course Overview: |
Introduction to VBA is designed to pick up where most advanced Microsoft Word courses leave off—the study of Visual Basic for Applications, the powerful macro programming language of Microsoft Word.
This course will introduce you to computer programming through a simple document automation exercise. Working hand-in-hand with your instructor and fellow students, you'll use this exercise to investigate the basics of object-oriented programming, the Microsoft Word object model, and the logical structures of the Visual Basic for Applications language. You will learn to write code to control the text and data content and to automate production of your documents.
By the fifth lesson, you will know enough to begin writing a VBA program that you will be adding functionality to lesson by lesson. By the last lesson, your macro will be ready to execute on a template document and data source. In seconds, your macro will produce a set of documents which before would have taken days to complete!
This course is ideal for you if you're a Microsoft Word user and you're responsible for producing high-quality, data-dependent documents in volume, or you need customizable document automation on a budget. It is also highly useful if you want to begin learning the Visual Basic for Applications programming language in a familiar environment.
|
| Instructor Biography: |
| With a love of writing and a Bachelor of Arts degree in English, Ruth Hadad has written in a variety of fields. At every, turn she has found ways to increase efficiency from programming automated report templates with Microsoft Word to creating custom client-server applications. Her zest for saving time has led her to utilize expertly all aspects of the Visual Basic for Applications programming language. Ruth is not content keeping knowledge to herself, however. She has taught the Microsoft Office suite in a variety of situations--most recently to single mothers in a welfare-to-work program. In addition to client-server programming, Ruth is webmaster for several non-profit organizations and works as an independent programming consultant. |
| Course Syllabus: |
| Lesson 1 Syllabus |
VBA Design Environment |
| Lesson 2 Syllabus |
Declaration and Use of Variables |
| Lesson 2 Objective |
Navigate the VBA programming environment and identify basic code structures. You also will learn how to get information from your end-user. |
| Lesson 3 Syllabus |
Building Expressions with Operators |
| Lesson 3 Objective |
Define why we use variables and how to declare them, how to determine and set a variable's scope, how to choose a data type and create a user-defined data type, when and how to use arrays and constants, and the rules of variable declaration and naming conventions. |
| Lesson 4 Syllabus |
Using Objects and Object Variables |
| Lesson 4 Objective |
Explore mathematical, logical, and string operators, their precedence, and how to use them to construct meaningful expressions in VBA. |
| Lesson 5 Syllabus |
Using VBA Code to Make Decisions |
| Lesson 5 Objective |
Get acquainted with syntax, then look at common data type conversion, date manipulation, and mathematical and string formatting functions. |
| Lesson 6 Syllabus |
Debugging Code |
| Lesson 6 Objective |
Determine ways of making decisions with your code. You will learn about conditional statements and loops, and ways to nest decision structures and stop program execution. |
| Lesson 7 Syllabus |
Application Object |
| Lesson 7 Objective |
Learn to handle errors in your programs effectively. |
| Lesson 8 Syllabus |
Document Object Events and Properties |
| Lesson 8 Objective |
Evaluate Microsoft Word Object Model and how it is used for document automation. You will learn about the commonly used properties and methods of the Application object. |
| Lesson 9 Syllabus |
Document Object Methods |
| Lesson 9 Objective |
Peruse the Document object's Open and Close Events. You also will look at the Paragraph and Bookmark properties, and various properties identifying the document and the template it is based on. |
| Lesson 10 Syllabus |
Selection Object and UserForms |
| Lesson 10 Objective |
Understand major methods of the Document object. You will use code to activate a document, check spelling, save, and print and close documents. You will learn how to move your cursor around using code. |
| Lesson 11 Syllabus |
Connecting to a Data Source with ADO |
| Lesson 11 Objective |
Grasp how to select text using code and how to create and format UserForms. |
| Lesson 12 Syllabus |
Data Manipulation with ADO |
| Lesson 12 Objective |
Examine the ADO Object Model and learn to establish a connection, define your queries, and open and navigate a recordset. |
