Cover image for Computer programming fundamentals with applications in Visual Basic 6.0
Title:
Computer programming fundamentals with applications in Visual Basic 6.0
Author:
Kerman, Mitchell C.
Personal Author:
Publication Information:
Reading, Mass. : Addison-Wesley, [2000]

©2000
Physical Description:
xii, 372 pages : illustrations ; 28 cm + 1 computer optical disc (4 3/4 in.)
General Note:
CD-ROM contains the Visual Basic 6.0 working model and program files from the book.

Includes index.
Language:
English
Title Subject:
Subject Term:
Added Author:
ISBN:
9780201612684
Format :
Book

Available:*

Library
Call Number
Material Type
Home Location
Status
Item Holds
Searching...
QA76.6 .K465 2000 TEXT Book and Software Set Non-Fiction Area-Oversize
Searching...

On Order

Summary

Summary

This book presents concepts of programming methodology and sound software development alongside the fundamentals of the Visual Basic 6.0 language. The goal is to provide a foundation of solid programming techniques and to promote an understanding of the common control structures available in most high-level languages. The book discusses the language with gradually increasing complexity, presenting the essential features of Visual Basic before introducing advanced language features. This is an appropriate book for introductory courses in computer programming as well as a reference for advanced programmers. Features: *Provides a solid foundation in computer programming fundamentals using the Visual Basic language *Contains well thought-out pedagogy, including: -Code Callouts to explain important points and key concepts in program source code -GUI Design Tips to enhance understanding of proper GUI design -Real-world examples from the business, math, science, engineering, and operations research communities to demonstrate the relevance of the material -Case Studies to provide insight on how the concepts apply to real-world situations -Chapter Summaries to review key terms, words, and c


Table of Contents

Prefacep. vii
1 Computer Basicsp. 1
Chapter Objectivesp. 1
A Brief History of Computersp. 1
Types of Computersp. 7
Components of a Typical Microcomputer Systemp. 8
The Binary Number Systemp. 9
The Evolution of Computer Programming Languagesp. 10
From BASIC to Visual Basicp. 11
Summaryp. 13
Key Termsp. 13
Key Conceptsp. 14
Review Questionsp. 15
Problemsp. 15
Next Step Visual Basic: Computer Arithmetic and Number Systemsp. 16
Chapter Supplement Objectivesp. 16
A Look Back at the Decimal Number Systemp. 16
The Binary Number Systemp. 17
Binary Arithmeticp. 19
Octal and Hexadecimal Number Systemsp. 21
Summaryp. 23
Key Termsp. 23
Key Conceptsp. 24
Review Questionsp. 24
Supplement Problemsp. 24
2 The Visual Basic Development Environmentp. 27
Chapter Objectivesp. 27
The Visual Basic Philosophyp. 28
Using Visual Basicp. 28
The Visual Basic Opening Screenp. 29
Visual Basic Screen Layoutp. 29
Elementary Visual Basic Controlsp. 33
Labelp. 34
Text Boxp. 35
Picture Boxp. 37
Command Buttonp. 37
Placing Moving and Sizing Controlsp. 37
Accessing Additional Toolbox Controlsp. 38
Control Naming Conventionsp. 38
Changing the Integrated Development Environmentp. 38
Your First Programp. 39
Designing the User Interfacep. 41
Writing the Source Codep. 41
Visual Basic File Typesp. 42
Visual Basic Help and Online Documentationp. 45
Summaryp. 47
Key Termsp. 47
Keywordsp. 48
Key Conceptsp. 48
Review Questionsp. 49
Problemsp. 49
Next Step Visual Basic: Customizing the Visual Basic Integrated Development Environmentp. 51
Chapter Supplement Objectivesp. 51
Editor Tabp. 51
Editor Format Tabp. 52
General Tabp. 53
Docking Tabp. 54
Environment Tabp. 55
Advanced Tabp. 56
Summaryp. 57
Key Termsp. 57
Key Conceptsp. 57
Review Questionsp. 58
Supplement Problemsp. 58
3 Planning Your Programp. 59
Chapter Objectivesp. 59
Planning: The First Stepp. 60
Flowchartsp. 60
Pseudocodep. 61
The Program Development Cyclep. 62
Case Study: The Knapsack Problemp. 63
Summaryp. 65
Key Termsp. 65
Key Conceptsp. 65
Review Questionsp. 65
Problemsp. 65
4 Elements of Programmingp. 69
Chapter Objectivesp. 69
Variablesp. 69
Naming Declaring and Using Variablesp. 70
Code Viewsp. 72
Declaring Variablesp. 72
Variant Data Typep. 73
Using = in Codep. 74
Initializing Variablesp. 74
Constantsp. 75
Defining Constantsp. 75
Mathematical Calculationsp. 75
Order of Operationsp. 77
Mathematical Functionsp. 78
Mixed-Mode Arithmeticp. 78
Stringsp. 80
String Concatenationp. 80
Special Characters in Stringsp. 80
String Functionsp. 81
Fixed-Length Stringsp. 81
Scope and Lifetimep. 82
Program Readabilityp. 84
Comment Keywordsp. 84
Line Continuation Characterp. 85
Interactive Input and Outputp. 85
Text Boxesp. 85
Picture Boxesp. 85
Input Boxes and Message Boxesp. 86
Your Second Programp. 87
CASE STUDY: The Global Variable Trapp. 90
Summaryp. 90
Key Termsp. 90
Keywordsp. 92
Key Conceptsp. 93
Review Questionsp. 94
Problemsp. 95
Programming Projectsp. 96
5 Flow Controlp. 97
Chapter Objectivesp. 97
Comparison Operatorsp. 98
Relational Operatorsp. 98
Logical Operatorsp. 99
Relational and Logical Operator Precedencep. 99
Logical Expressionsp. 99
DeMorgan's Lawsp. 100
Expanding and Reducing Logical Expressionsp. 100
Decision Structuresp. 102
If-Blocksp. 102
Comparison of Code Structuresp. 104
Nested If-Blocksp. 104
Select-Case Blocksp. 105
Repetition Structuresp. 107
For-Next Loopsp. 107
Do Loopsp. 110
Comparing Do While-Loop and Do-Loop Untilp. 111
Comparative Example of Do Loopsp. 111
Other Do Loopsp. 112
Ending a Programp. 112
Programming Stylep. 113
CASE STUDY: GoodLook Cosmetics Companyp. 113
Summaryp. 114
Key Termsp. 114
Keywordsp. 115
Key Conceptsp. 116
Review Questionsp. 118
Problemsp. 118
Programming Projectsp. 120
Next Step Visual Basic: An Introduction to Sequential File Input and Outputp. 121
Supplement Objectivesp. 121
Sequential Filesp. 121
Summaryp. 123
Key Termsp. 123
Keywordsp. 124
Key Conceptsp. 124
Review Questionsp. 124
Supplement Problemsp. 125
Programming Projectsp. 125
6 Structured Programmingp. 127
Chapter Objectivesp. 127
Modular Programmingp. 128
Subprograms: Procedures and Functionsp. 128
An Example of a Subprogramp. 128
Arguments and Parametersp. 129
Defining and Using Subprogramsp. 130
Proceduresp. 130
Functionsp. 131
Creating a Subprogram in VBp. 132
Parameter Passingp. 132
Events and Event Handlersp. 135
Even Handlers for Form Eventsp. 135
Event Handlers for Focus Eventsp. 136
Event Handlers for Mouse Eventsp. 136
Summaryp. 138
Key Termsp. 138
Keywordsp. 139
Key Conceptsp. 139
Review Questionsp. 140
Problemsp. 141
Programming Projectsp. 142
Next Step Visual Basic: Recursionp. 144
Supplement Objectivesp. 144
Mathematical Recursionp. 144
Recursive Subprogramsp. 145
CASE STUDY: The Towers of Hanoip. 146
Summaryp. 149
Key Termsp. 149
Key Conceptsp. 149
Review Questionsp. 149
Supplement Problemsp. 149
Programming Projectsp. 150
7 Error Trapping and Debuggingp. 151
Chapter Objectivesp. 151
Built-In Error Trappingp. 152
The GoTo Statementp. 154
Types of Programming Errorsp. 155
Syntax Errors and Logic Errorsp. 155
Standard Debugging Techniquesp. 156
Data Dumpp. 156
Hand-Execution of Codep. 156
The Visual Basic Debuggerp. 157
Debugger Operationp. 159
VB Debugger Examplep. 159
Case Study: A Failed Space Missionp. 166
Case Study: The Y2K Problemp. 166
Summaryp. 167
Key Termsp. 167
Keywordsp. 168
Key Conceptsp. 168
Review Questionsp. 169
Problemsp. 170
8 Advanced Data Structuresp. 173
Chapter Objectivesp. 173
Static vs. Dynamic Data Structuresp. 173
Arraysp. 174
The Option Base Statementp. 176
Accessing an Array Elementp. 177
Array Structures and Notationp. 178
Dynamic Arraysp. 179
Arrays as Arguments and Parametersp. 180
CASE STUDY: Using Arraysp. 182
Records and User-Defined Data Typesp. 185
Recordsp. 186
User-Defined Data Typesp. 186
Using Recordsp. 187
Stacks, Queues, Deques, and Listsp. 189
Stacksp. 189
Queuesp. 192
Dequesp. 194
Pointers and Linked Listsp. 198
Linked List Examplep. 199
Summaryp. 202
Key Termsp. 202
Keywordsp. 203
Key Conceptsp. 203
Review Questionsp. 205
Problemsp. 205
Programming Projectsp. 205
Next Step Visual Basic: Object-Oriented Programmingp. 207
Chapter Supplement Objectivesp. 207
Overview of Object-Oriented Programmingp. 207
An Example Object-Oriented Program in VBp. 209
Summaryp. 214
Key Termsp. 214
Keywordsp. 214
Key Conceptsp. 214
Review Questionsp. 216
Supplement Problemsp. 216
Programming Projectsp. 216
9 File Input and Outputp. 217
Chapter Objectivesp. 217
Sequential Filesp. 218
CASE STUDY: Character Pattern Matchingp. 222
Random-Access Filesp. 223
Summaryp. 228
Key Termsp. 228
Keywordsp. 229
Key Conceptsp. 229
Review Questionsp. 230
Problemsp. 230
Programming Projectsp. 231
Next Step Visual Basic: Sorting and Searchingp. 232
Chapter Supplement Objectivesp. 232
Sortingp. 232
Searchingp. 237
Summaryp. 238
Key Termsp. 238
Key Conceptsp. 239
Review Questionsp. 239
Supplement Problemsp. 239
Programming Projectsp. 240
10 Advanced Visual Basicp. 241
Chapter Objectivesp. 241
Additional Visual Basic Controlsp. 242
Check Boxp. 242
Option Buttonp. 243
Framep. 244
List Boxp. 245
Combo Boxp. 247
Horizontal and Vertical Scroll Barsp. 249
Drive Directory and File List Boxesp. 250
Timerp. 251
Shape and Line Controlsp. 253
Imagep. 254
Datap. 254
OLEp. 255
Common Dialog Controlp. 255
Menu Controlp. 256
Control Arraysp. 259
ActiveX Controlsp. 262
An Active Control Examplep. 262
Testing the Actual Controlp. 264
Collectionsp. 265
Multiple Forms Programming and Multiple Document Interface (MDI) Formsp. 269
MDI versus SDIp. 270
MDI Application Examplep. 271
Random Numbersp. 272
Graphicsp. 275
Object Linking and Embedding (OLE)p. 278
Dynamic Data Exchange (DDE)p. 279
Internet Programmingp. 282
Visual Basic Compiler Directivesp. 284
CASE STUDY: A Computerized Surveyp. 286
Summaryp. 290
Key Termsp. 290
Keywordsp. 291
Key Conceptsp. 292
Review Questionsp. 294
Problemsp. 295
Programming Projectsp. 295
Next Step Visual Basic: Package and Deployment Wizardp. 296
Chapter Supplement Objectivesp. 296
Using the Package Deployment Wizardp. 296
Using the Package and Deployment Wizard as a VB Add-Inp. 297
Summaryp. 300
Key Termsp. 300
Key Conceptsp. 300
Review Questionsp. 301
Supplement Problemsp. 301
Programming Projectsp. 301
11 Visual Basic for Applicationsp. 303
Chapter Objectivesp. 303
Using Macrosp. 304
An Example Macro in Microsoft Wordp. 305
An Example Macro in Microsoft Excelp. 308
Using Macro Shortcutsp. 312
Using Visual Basic Control Objects in Microsoft Office Applicationsp. 315
Differences between Visual Basic and VBAp. 319
Case Study: A Loan Amortization Tablep. 320
Summaryp. 325
Key Termsp. 325
Key Conceptsp. 325
Review Questionsp. 325
Problemsp. 326
Programming Projectsp. 326
12 Databasesp. 327
Chapter Objectivesp. 327
Database Fundamentalsp. 327
Relational Database Designp. 328
Database Enginep. 329
Creating Database Filesp. 330
Visual Data Managerp. 330
Using Data Controls and Data-Aware Controlsp. 334
Structured Query Language (SQL)p. 340
SQL Overviewp. 340
Using the Select Command in SQLp. 340
Creating a Database through Visual Basic Codep. 343
Case Study: Designing a Relational Databasep. 347
Summaryp. 349
Key Termsp. 349
Keywordsp. 350
SQL Keywordsp. 351
Key Conceptsp. 351
Review Questionsp. 352
Problemsp. 352
Programming Projectsp. 353
Appendix A ASCII (ANSI) Character Valuesp. 355
Appendix B Visual Basic Programming Standardsp. 357
Appendix C Visual Basic Trappable Errorsp. 361
Appendix D Visual Basic Keyword Summaryp. 364
Indexp. 369