| |
Microsoft
Certified Solution Developer (MCSD) - Mastering
Web Site Fundamentals
|
|
More Resources by
Google: |
|
|
|
|
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
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:
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:
|
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:
|
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
|
|
|
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.
|
|
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
|
|
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.
|
|
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.
|
|
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.
|
|
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.
|
|
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.
|
|
| |
|