1. Computer Basics.
Types of Computers.
Components of a Typical Microcomputer System.
Computer Fundamentals and Number Systems.
The Evolution of Computer Programming Languages.
Machine Language.
Assembly Language.
High-level Languages.
Interpreters.
Compilers.
From BASIC to Visual Basic.
(Chapter 1 Supplement) Octal and Hexadecimal Numbers.
2. The Visual Basic Development Environment.
The Visual Basic Philosophy.
Using Visual Basic.
The Visual Basic Opening Screen.
Visual Basic Screen Layout.
Elementary Visual Basic Controls.
Label.
Text Box.
Picture Box.
Command Button.
Placing, Moving, and Sizing Controls.
Accessing Additional Toolbox Controls.
Control Naming Conventions.
Changing the Integrated Development Environment.
Your First Program.
Saving Your Program.
Printing Your Program.
Compiling and Executing Your Program.
Visual Basic Help and Online Documentation.
3. Planning Your Program.
Problem Solving.
Flowcharts.
Pseudocode.
The Program Development Cycle.
4. Elements of Programming.
Variables.
Naming, Declaring, and Using Variables.
Constants.
Calculations.
Arithmetic Operators.
Precedence Rules.
Common Math Functions.
The Format Function.
Data Type Conversion Functions.
Strings.
The Concatenation Operator.
ASCII/ANSI Characters.
Common String Functions.
Scope and Lifetime.
Local and Global Scope.
Form-level and Public Variables.
Static vs. Dynamic Variables.
Advantages and Disadvantages of Global Variables.
Program Readability.
Comments.
Indentation and White-space.
The Line-continuation Character.
Interactive Input and Output.
Picture Boxes and Text Boxes.
Input Boxes and Message Boxes.
Your Second Program.
5. Flow Control.
Comparisons.
Relational Operators.
Logical Operators.
Relational and Logical Operator Precedence.
DeMorgan's Laws.
Expanding and Reducing Logical Expressions.
Decisions.
If-blocks.
General Structures.
Sequential If-blocks.
Nested If-blocks.
Select-Case blocks.
Repetition.
For-Next Loops.
Do Loops.
Do While-Loop.
Do-Loop Until.
Ending a Program.
Programming Style.
6. Structured Programming.
The Modular Design Philosophy.
Subprograms.
Arguments and Parameters.
Defining and Using Subprograms.
Parameter Passing.
Passing by Reference.
Passing by Value.
Recursion.
7. Error Trapping and Debugging.
Bullet-proofing Your Programs.
Built-in Error Trapping.
The GoTo Statement.
Types of Programming Errors.
Standard Debugging Techniques.
The Data Dump.
Hand-execution of Code.
The Visual Basic Debugger.
Debugger Example.
8. Advanced Data Structures.
Static vs. Dynamic Data Structures.
Arrays.
One-dimensional Arrays.
Two-dimensional Arrays.
Multi-dimensional Arrays.
Dynamic Arrays.
Records and User-defined Data Types.
Stacks, Queues, Deques, and Lists.
Pointers and Linked Lists.
Object-oriented Programming.
Encapsulation, Inheritance, and Polymorphism.
Defining New Objects and Classes.
Defining New Methods.
9. File Input and Output.
Sequential Files.
Random-access Files.
Sorting and Searching (Supplement).
Sorting.
Bubble sort.
Shell sort.
Searching.
Sequential Search.
Binary Search.
10. Advanced Visual Basic.
Additional Visual Basic controls.
Check Boxes.
Option Buttons.
Frames.
List Boxes.
Combo Boxes.
Horizontal and Vertical Scroll Bars.
Drive, Directory, and File List Boxes.
Timer Controls.
Shape and Line Controls.
Image Controls.
Data Controls.
OLE Container Control.
Common Dialog Control.
Menu Control.
ActiveX Controls.
Collections (of objects).
Control Arrays.
Multiple Forms.
Programming with Multiple Forms.
Multiple Document Interface (MDI) Forms.
Random Numbers.
Graphics.
Object Linking and Embedding (OLE).
Dynamic Data Exchange (DDE).
Internet Programming.
Visual Basic Compiler Directives.
11. Visual Basic for Applications (VBA).
Using Macros.
An Example Macro in Microsoft Word.
An Example Macro in Microsoft Excel.
Using Macro Shortcuts.
Using Visual Basic Control Objects in Microsoft Office Applications.
Differences between Visual Basic and VBA
12. Databases.
Database Fundamentals.
Creating Database Files.
Using Data Controls and Data-Aware Controls.
Structured Query Language (SQL).
Creating a Database through Visual Basic Code. 0201612682T04062001