Microsoft Certified
Solution Developer Exam Training
And
Visual Basic 6.0 Client/Server
Application
(7 Days Course, Specialize in MCSD Exam
and Real Project)
MCSD Exam: 70-175
Twenty-two MCSD exam samples and two VB
applications source codes will be given to the students. We will demonstrate
and discuss some financial systems in class! Plus a lot of hands on experience!
Day Topics
-
MCSD book’s Chap 1, 2, 3, 6, 8 / QUE Book’s
Chap 2, 3, 7, 8
Introduction to Visual Basic 6.0
Demos:
Introduction to the Development Environmen
Working with Forms and Controls:
-
Three Demos and Labs: Loan Calculation, Temperature
Conversion
Input Dialog Box:
Programming Fundamental 1: Data types and
variables
Using setup wizards to create your installation
disks
Homework#1
-
MCSD book’s Chap 8, 5, 7, 4, 9 / QUE Book’s
Chap 8, 5, 4, 6, 9, 10
Comments for Homework#1
Working with Graphics
Build a toolbar: demo and lab
Create menus: demo and lab
Programming Fundamental 2: a lot of examples
-
Array
-
Strings
-
If statement, Select Case
-
For Loops, Do While Loop, Do Until Loop
Debugging your programs
Homework#2
-
MCSD book’s Chap 10, 11, 19, 20, 21, 22/
QUE Book’s Chap 24, 25, 28, 29
Comments for Homework#2
Managing your project
Programming Fundamental 3: a lot of examples
-
Variables (Cont’d)
-
Parameters: a lot of examples
RDBM
-
Create a device, database and table
-
Define primary key and foreign keys
-
Index a table for efficiency
-
Access data with the JET Engine and the Data
Contro
Homework#3
-
MCSD book’s Chap 9, 10, 11, 17 / QUE Book’s
Chap 30, 31
RDBM (Cont’d)
-
Access data with ODBC
-
Getting connected to Oracle and MS SQL Server
7.0
-
DAO vs. RDO vs. ADO
Database Design and SQL Query:
-
Designing database tables and defining their
relations.
-
Normalized and unnormalized
-
Use an RDO to insert, update and delete records
Demos:
-
Inventory system
Select a final project topic: Inventory
System, or Accounting System, or Finance System
Homework#4
-
MCSD book’s Chap 12, 13, 14, 15, 16 / QUE
Book’s Chap 15-19, 20 - 23
ActiveX Controls:
-
The Registry
-
Setup ActiveX business objects
-
ActiveX DLL vs. Active EXE
-
How to use very useful ActiveX controls: TreeView,
ListView, …(many examples with source codes will be given)
-
Animation
Object-Oriented Design:
-
Objects, Class Model
-
Utilize a collection of Classes
-
Implement an object model
-
QUE Book’s Chap 11, 12, 13, 14, 32, 33,
34
Designing and Implementing User Interfaces
(GUI)
-
Multiple Document Interface (MDI)
-
Make a application Drag-and-Drop capable
-
Organize form contents using the Tab control
-
Populate an unbound grid and control the number
of rows displayed
-
Create a master/detail form
Crystal Report:
-
Design a Crystal report
-
Displaying and printing reports
Comments to your first version final
project
-
QUE Book’s Chap 32 - 34
Client/Server Fundamentals:
-
Two-tier vs. three-tier client/server Model
-
Understand file server vs. client/server database
deployment
-
Investigate the component object model
-
Create a SourceSafe project
Demos:
-
Purchase Order System
-
Financial systems
Final Project Improvement
Advanced Database Topics:
-
Use a trigger to control data integrity, create
and execute a stored procedure
-
Database transaction and two-phase commit
-
Optimization
Advanced Visual Basic Programming Techniques
Resume and Interview Questions
Textbook:
Special Edition Using Visual Basic 6
(QUE Book - for short above)
by Brian Siler, Jeff Spotts
Publisher: Que Education & Training
ISBN: 0789715422 List Price: $39.99 Our
Price: $34.00
Optional Textbook: Using Visual Basic
5.0 (Platinum Edition)
by Loren Eidahl, Andrew Brust
Publisher: Que Education & Training
ISBN: 0789714124 List Price: $60.00 Our
Price: $55.00