Technical Education College Macro Course

Course Description

If you perform a task repeatedly in Microsoft Office Applications, you can automate the task by using macros. A macro is a series of commands and instructions that you group together as a single command in the Visual Basic Editor to accomplish a repetitive task automatically. This course is designed for those seeking add to their Office 2000 Application skills by learning to use macros within Microsoft Word, Excel and Access.

Upon successful completion of this course the student receives the certification of Desktop Application Macro Specialist

Desktop Application Macro Specialist CSP-103 General Syllabus

Course Prerequisites:

Computer skills, including knowledge of a Windows Application environment, be able to type and use a mouse. Basic math skills

Course Length:

4 Days

Course Objectives:

Introducing the Visual Basic Editor

Using the Visual Basic Editor in Excel, Word and Access

Working with the Object Model

Using the Object Model in Excel, Word and Access

Working with the Object Variables

Using the Object Variables in Excel, Word and Access

Working with String Variables

Using the String Variables in Excel, Word and Access

Working with Data Variables

Using the Data Variables in Excel, Word and Access

Working with Numeric Variables

Using the Numeric Variables in Excel, Word and Access

Working Selection Structure

Using the Selection Structure in Excel, Word and Access

Working with the Select Case statement and the MsgBox Function

Using the Select Case statement and the MsgBox Function in Excel, Word and Access

Working with repetition structure and the With statement basic and advanced

Using with repetition structure and the With statement in Excel, Word and Access basic and advanced

Working with built-in and custom dialog boxes and with the Office Assistant

Communicating with the user. Using built-in and custom dialog boxes and with the Office Assistant in Excel, Word and Access

Working with option button, check box and list box controls

Using option button, check box and list box controls in Excel, Word and Access

Automation

Understanding the Automation process in Excel, Word and Access

Advanced Automation and error trapping

Discussing and using Automation and error trapping in Excel, Word and Access

Student Labs:

Hands on portion of the course includes lab exercises building and utilizing macros in a Visual Basic Editor environment to be imported into Excel, Word and Access.

Instructional Methods:

This course combines lecture, presentation, laboratory hands-on exercises, discussions and problem solving. Assessments will be made by practical exercises and examinations/quizzes.

Resources:

Textbooks, exercises and readings that accompany the text, web site resources, electronic mail mentoring opportunities and computer-based training materials.

Course Price:

$690.00
includes Desktop Application Macro Specialist Certificate, 1 student textbooks (454 pages), book tote and class supplies a $150 value.