1335 Rockville Pike
Rockville, MD 20852
(301) 424-0044
(301) 424-1693 (fax)
COMPUTER
INSTITUTE
Thursday, August 28, 2008
 
Microsoft Certified Solution Developer (MCSD)
Mastering Web Site Fundamentals
Course No.      
Course Length: 		1009
5 Days
This course teaches new Web developers how to create static and dynamic hypertext markup language (HTML) pages. Students will learn basic Internet and intranet concepts. They will also learn about the technologies and Microsoft tools that enable Web development. Students will learn how to create Web documents by using the Microsoft FrontPage Web authoring and management tool and by editing the HTML tags directly. Students will create HTML documents that contain forms, standard controls, ActiveX controls, Java applets, and client-side script. They will also learn how to use the dynamic HTML and data binding features supported by Microsoft Internet Explorer version 4.0. Finally, students will learn how to publish and test Web pages on a Web server.

At Course Completion

At the end of the course, students will be able to:
  • Identify technologies and supporting tools that enable Web development.
  • Create HTML documents that contain standard controls, ActiveX controls, Java applets, tables, forms, frames, images, and client script.
  • Use dynamic HTML.
  • Create an HTML page that uses data binding to read data from a database.
  • Use Microsoft Office 97 to create and publish documents on a Web server.
  • Use FrontPage 98 to publish HTML documents on a Web server.
Prerequisites

Before beginning this course, students should be able to:

  • Use a Web browser
  • Understand event-driven programming concepts such as:
    • Variables, looping statements, and procedures
    • Objects, properties, methods, and events
The course materials, lectures, and lab exercises are in English. To benefit fully from our instruction, students need an understanding of the English language and completion of the prerequisites.

Course Outline

Chapter 1: Internet Concepts

Topics:

Introduction
Internet addressing schemes
Connecting to the Internet
Architecture of the Internet

Skills:

Students will be able to:
  • Describe Internet concepts such as the World Wide Web, FTP, protocols, and HTML.
  • List the tools and technologies provided by Microsoft that enable Web development, and describe the purpose of each tool.
Chapter 2: Using Microsoft Internet Explorer 4.0

Topics:

Microsoft Internet Explorer 4.0 features
Installing Internet Explorer
Configuring Internet Explorer
Using the Integrated Desktop
Subscriptions
Channels
Offline content viewing
Using the Active Desktop

Skills:

Students will be able to:

  • Install and configure Internet Explorer 4.0.
  • Subscribe to a Web site.
  • View content offline.
  • Add and remove items from the Active Desktop
Chapter 3: Creating Basic Web Pages
Topics:

Designing a Web site
Using Microsoft FrontPage
Introduction to HTML
Working with images
Creating tables
Creating frames

Labs:

Importing and creating Web sites
Creating Web pages

Skills:

Students will be able to:
  • List the basic HTML tags required in a Web document.
  • Use FrontPage to create a new Web site.
  • Use FrontPage to create an HTML document that contains hyperlinks, frames, tables, and images.
Chapter 4: Creating Forms
Topics:

 Overview of forms
Creating a form with FrontPage
Setting form field properties
Form and control tags

Lab:

 Creating forms

Skills:

 Students will be able to:
  • Use FrontPage to create a Web form.
  • Add fields to a form and list the differences between the form fields.
  • Set form and form field properties.
  • List the HTML tags used to create a form.
  • List the HTML tags used to define form fields.
Chapter 5: Adding Client-Side Script
Topics:

Object-oriented programming
Overview of scripting
Microsoft Visual Basic Scripting Edition language syntax
Writing script
Debugging

Lab:

Adding client-side script

Skills:

Students will be able to:
  • Describe the differences between client-side and server-side script.
  • Describe the differences between VBScript and JScript.
  • Add VBScript to a Web page to initialize the page, respond to events, and validate data in a Web form
Chapter 6: Adding Active Components
Topics:

Overview
Using ActiveX controls
Using Java applets

Lab:

Adding ActiveX controls

Skills:

Students will be able to:
  • Add ActiveX controls and Java applets to a Web page.
  • Add a licensed control to a Web page.
  • Write script to manipulate an ActiveX control or Java applet.
Chapter 7: Using Dynamic HTML
Topics:

Overview
Dynamic HTML events
Using collections
Manipulating text and HTML
Dynamic styles
Transitions and visual filters
Positioning

Lab:
Using dynamic HTML

Skills:

Students will be able to:
  • Describe the benefits of dynamic HTML and how it works.
  • Write script to dynamically change attributes of elements, change content, change styles, position elements, and use visual filters and transitions.
  • Describe how events and event bubbling work.
Chapter 8: Accessing a Database
Topics:

Data access methods
Using the Tabular Data Control
Using the Advanced Data Control
Binding elements to the Data Source Object
Interacting with the Recordset

Lab:

Accessing a database

Skills:

Students will be able to:
  • Describe the various ways to display data from a database on a Web page.
  • Use data binding features supported in Internet Explorer 4.0.
Chapter 9: Using Microsoft Office Internet Features
Topics:

Overview
Using Microsoft Word
Using Microsoft Excel
Using Microsoft Access
Using Microsoft PowerPoint

Lab:

Using Internet features in Microsoft Word, Excel, and Access

Skills:

Students will be able to:
  • Publish native Office documents on the Internet.
  • Convert existing Office documents to HTML format.
  • Create new HTML documents with Office.
  • Use hyperlinks in Office documents.
Chapter 10: Publishing a Web Site
Topics:

Using FrontPage management tools
Managing the production process
Publishing Web pages

Lab:

Publishing a Web site

Skills:

Students will be able to:
  • Describe the difference between staging and production Web sites.
  • Publish Web documents to an intranet or the Internet.
  • Use FrontPage to identify broken links and spelling errors within a Web site.

 


Microsoft Certified Solution Developer (MCSD)

Mastering Microsoft Visual Basic 6 Fundamentals
Course No.
Course Length:
 		1303
5 Days
This course teaches programmers the skills necessary to create Microsoft Visual Basic programming system desktop applications and satisfies the Visual Basic prerequisites for course 1013, Mastering Visual Basic 6 Development.

At Course Completion

 At the end of the course, students will be able to:
  • Build custom, multiple-form applications.
  • Incorporate dynamic menus, pop-up menus, status bars, and custom toolbars into applications.
  • Implement form-level and field-level input validation.
  • Debug applications using debugging tools provided in Visual Basic 6.
  • Use standard controls, control arrays, and create controls dynamically.
  • Execute centralized error-handling in applications.
  • Use the data control for database access.
  • Implement drag and drop in Visual Basic-based applications.
  • Use Microsoft ActiveX controls in Visual Basic-based applications.
  • Create setup programs to distribute applications.
    •

Prerequisites
  • Working knowledge of programming concepts.
    •
Course Outline
Day 1
Module 1: Introduction to Application Development Using Visual Basic
Topics:

 Features of Visual Basic
Editions of Visual Basic
Visual Basic terminology
Working in the development environment
Event-driven programming
Creating a program in Visual Basic
Project and executable files
Visual Basic reference materials
Self-check questions

 Lab:

 Creating a simple application

Skills:

Students will be able to:
  • Identify the elements in the Visual Basic development environment.
  • Explain the difference between design time and run time.
  • Explain the concept of event-driven programming.
  • Describe the purpose of a project file.
  • List the file types that can be included in a project.
Module 2: Visual Basic Fundamentals
Topics:

 Introduction to objects
Controlling objects
Properties, methods, and events
Working with forms
Introduction to controls
Basic controls
Self-check questions

Lab:

 Creating a Visual Basic-based application

Skills:

Students will be able to:
  • Create a simple application using Visual Basic.
  • Define and provide examples of each of the following: object, property, method, and event.
  • Describe some of the properties and events associated with a form.
  • Set properties for command buttons, text boxes, and labels.
  • Use the WithEnd With statement to set multiple property values for a single object.
  • Assign code to a control to respond to the Click event.
Module 3: Working with Code and Forms
Topics:

 Understanding modules
Using the code editor window
Other code navigation features
Code documentation and formatting
Setting environment options
Setting code formatting options
Automatic code completion features
Interacting with the user
Using the MsgBox function
Using the InputBox function
Working with code statements
Managing forms
Self-check questions

Lab:

 Working with forms

Skills:

Students will be able to:
  • Use the editing tools in the Visual Basic Code Editor window to write organized and well-documented code.
  • Control the Visual Basic environment and customize it to their needs.
  • Display message boxes.
  • Use Visual Basic constants and named arguments.
  • Differentiate between the Load/Unload statements and use the Show/Hide methods.
  • Set the startup form for an application.
  • Control a program's closing routine.
Day 2
Module 4: Variables and Procedures
Topics:

 Overview of variables
Declaring variables
Variable scope
Using arrays
User-defined data types
Converting data types
Using constants
Working with procedures
Working with dates and times
Using the Format function
Manipulating text strings
Self-check questions

Lab:

 Writing procedures

Skills:

Students will be able to:
  • Explain the various data types used when declaring variables.
  • Declare private and public variables.
  • Use public variables to use data in multiple forms.
  • Describe the difference between a variable and a constant.
  • Differentiate between a Sub procedure and a Function procedure.
  • Create a Function procedure that accepts arguments and returns a value.
  • Describe how a Standard module differs from a Form module.
  • Add a Standard module to a project to store general procedures and variables.
  • Use Visual Basic functions to manipulate text strings and return the current date and time.
Module 5: Controlling Program Execution

Topics:

 Comparison and logical operators
Using IfThen statements
Using Select Case statements
Overview of looping structures
Using DoLoop structures
ForNext statement
Exiting a loop
Self-check questions

Lab:

 Controlling program flow

Skills:

Students will be able to:

  • List techniques for comparing variables and object properties using Visual Basic code.
  • Explain the difference between IfThen and Select Case statements and describe the circumstances in which you use each statement.
  • Explain the difference between the ForNext and DoLoop statements.
  • Choose the appropriate conditional or looping structure to control program flow
Module 6: Debugging
Topics:

 Types of errors
Break mode
Using the Debug toolbar
Using the Watch window
Using the Immediate window
Using the Locals window
Tracing program flow with the Call Stack
Self-check questions

Lab:

 Using the Visual Basic debugging tools

Skills:

Students will be able to:
  • Stop program execution using breakpoints and watch expressions.
  • Monitor variable values in the Watch window.
  • Test data and a procedure's results in the Immediate window.
  • Evaluate variable values in the Locals window. Distinguish among Run, Design, and Debug modes in Visual Basic.
  • Trace the program execution sequence using the Call Stack.
Day 3
Module 7: Working with Controls
Topics:

 Types of controls
Overview of standard controls
Using ComboBox and ListBox controls
Using OptionButton and Frame controls
Working with selected text
Advanced standard controls
ActiveX controls
Insertable objects
Self-check questions

Lab:

 Working with controls

Skills:

 Students will be able to:
  • Identify and use the standard controls in Visual Basic.
  • Define how an ActiveX control differs from a standard control.
  • Add ActiveX controls to a project and use these controls in a program.
Module 8: Data Access Using the ADO Data Control
Topics:

 Overview of ActiveX data objects
Visual Basic data access features
Relational database concepts
Using the ADO Data control to access data
Structured query language (SQL)
Manipulating data
Using Data Form Wizard
Self-check questions

Lab:

 Accessing databases

Skills:

 Students will be able to:
  • Define the following terms: database, table, field, record, and key.
  • Use the ADO Data control to view records in a database.
  • Use the ADO Data control to find, modify, delete, and add records.
  • List the standard bound controls.
  • Define Structured Query Language (SQL).
  • Describe the purpose of the SELECT statement in SQL.
  • Use Data Form Wizard to design a simple data-entry form.
    •
Module 9: Input Validation
Topics:

 Field-level validation
Using text box properties to restrict data entry
Using the Masked Edit control
Form-level validation
Form events used when validating data
Self-check questions

Lab:

 Input validation

Skills:

 Students will be able to:
  • Create an application that validates user data at the field level and at the form level.
  • Create an application that uses the Masked Edit control.
  • Create an application that enables or disables controls based on field values.
Day 4
Module 10: Error Trapping
Topics:

Overview of run-time errors
Overview of the error handling process
The Err object
Errors and the calling chain
Errors in an error-handling routine
Inline error handling
Error-handling styles
General error-trapping options in Visual Basic
Self-check questions

 Lab:

 Error trapping

Skills:

 Students will be able to:
  • Trap run-time errors.
  • Create error handlers.
  • See how errors are handled in the calling chain.
  • Handle errors in an error-handling routine.
  • Handle inline errors.
  • Describe some common error-handling styles.
  • Describe error-trapping options in the Visual Basic development environment.
Module 11: Enhancing the User Interface
Topics:

 Menus
Status bars
Toolbars

Lab:

 Adding menus

Skills:

Students will be able to:
  • Create and edit custom menu bars, menus, submenus, and menu items using the Menu Editor.
  • Identify the menu properties that can be set in the Menu Editor dialog box.
  • Create a pop-up menu using the Menu Editor.
  • Assign code to menu items that respond to the Click event.
  • Create a status bar on a form that provides users with feedback.
  • Create a toolbar using the Toolbar control.
Module 12: Drag and Drop
Topics:

 Overview of drag and drop
Mouse events
Drag-and-drop basics
Self-check questions

Lab:

 Adding drag and drop

Skills:

Students will be able to:
  • Describe the role of mouse events in implementing drag-and-drop features.
  • Perform the steps required to add drag-and-drop features to an application.
  • Identify the source control and target form or control in a drag-and-drop operation.
  • Implement OLE drag-and-drop features.
    •
Day 5
Module 13: More About Controls
Topics:

 Collections
Using control arrays
Self-check questions

Lab:

 Using control arrays

Skills:

 Students will be able to:
  • Define and describe the use of control arrays.
  • Create an array of controls.
  • Build an application for Visual Basic that dynamically adds and deletes controls.
  • Use the Visual Basic Controls collection.
  • Create and use object variables.
Module 14: Finishing Touches
Topics:

 User interface design principles
Distributing an application
Creating a default project
Review: Steps to creating a Visual Basic program
Development resources
Self-check questions

Lab:

 Using the Package and Deployment Wizard

Skills:

 Students will be able to:
  • Create applications that incorporate basic principles of user interface design.
  • Create a setup program for an application by using Package and Deployment Wizard.
  • Create custom projects.
    •

Top of this Page

Page 2

 
 
Copyright Computer Institute 1999
Last Updated: Thursday, August 28, 2008