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

1. MCSD book’s Chap 1, 2, 3, 6, 8 / QUE Book’s Chap 2, 3, 7, 8

Introduction to Visual Basic 6.0
Demos:
• Financial systems
Introduction to the Development Environmen
Working with Forms and Controls:
• Three Demos and Labs: Loan Calculation, Temperature Conversion
Input Dialog Box:
• Logo Screen
Programming Fundamental 1: Data types and variables
Using setup wizards to create your installation disks
Homework#1
2. 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
 
3. 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

1. 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
 
2. 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

1. 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

• Design a Crystal report
• Displaying and printing reports

1. 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

• 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

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