Computer programming concepts and visual basic

CONTENTS......Page 3
SECTION 1 PROBLEM SOLVING......Page 9
PERFORMING A TASK ON THE COMPUTER......Page 11
PROGRAM PLANNING......Page 12
1.2 PROGRAMMING TOOLS......Page 13
FLOWCHARTS......Page 14
PSEUDOCODE......Page 15
HIERARCHY CHART......Page 16
DIRECTION OF NUMBERED NYC STREETS ALGORITHM......Page 17
CLASS AVERAGE ALGORITHM......Page 19
SECTION 2 FUNDAMENTALS OF PROGRAMMING IN VISUAL BASIC......Page 23
2.1 VISUAL BASIC OBJECTS......Page 25
A TEXT BOX WALKTHROUGH......Page 27
A COMMAND BUTTON WALKTHROUGH......Page 31
A PICTURE BOX WALKTHROUGH......Page 32
2.2 VISUAL BASIC EVENTS......Page 35
AN EVENT PROCEDURE WALKTHROUGH......Page 36
2.3 NUMBERS......Page 42
ARITHMETIC OPERATIONS......Page 43
SCIENTIFIC NOTATION......Page 44
VARIABLES......Page 45
PRINT METHOD......Page 46
VARIABLES AND STRINGS......Page 50
CONCATENATION......Page 51
DECLARING VARIABLE TYPES......Page 52
ANSI CHARACER SET......Page 53
THE KEYPRESS EVENT PROCEDURE......Page 54
READING DATA FROM FILES......Page 57
IINPUT FROM AN INPUT BOX......Page 60
FORMATTING OUTPUT WITH PRINT ZONES......Page 61
TAB FUNCTION......Page 62
OUTPUT TO THE PRINTER......Page 63
INTERNAL DOCUMENTATION......Page 64
NUMERIC FUNCTIONS: SQR, INT, ROUND......Page 66
STRING FUNCTIONS: LEFT, MID, RIGHT, UCASE, TRIM......Page 68
STRING-RELATED NUMERIC FUNCTIONS: LEN, INSTR......Page 69
FORMAT FUNCTIONS......Page 70
GENERATING RANDOM NUMBERS: RND......Page 72
SECTION 3 GENERAL PROCEDURES......Page 79
3.1 SUB PROCEDURES, PART I......Page 81
VARIABLES AND EXPRESSIONS AS ARGUMENTS......Page 85
3.2 SUB PROCEDURES, PART II......Page 88
PASSING VLAUES BACK FROM SUB PROCEDURES......Page 89
LOCAL VARIABLES......Page 91
FORM-LEVEL VARIABLES......Page 93
3.3 FUNCTION PROCEDURES......Page 95
TOP-DOWN DESIGN......Page 101
STRUCTURED PROGRAMMING......Page 103
ADVANTAGES OF STRUCTURES PROGRAMMING......Page 104
SECTION 4 DECISIONS......Page 109
4.1 RELATIONAL AND LOGICAL OPERATORS......Page 111
LOGICAL OPERATORS......Page 112
4.2 IF BLOCKS......Page 114
4.3 SELECT CASE BLOCKS......Page 120
4.4 A CASE STUDY: WEEKLY PAYROLL......Page 127
DESIGNING THE WEEKLY PAYROLL PROGRAM......Page 128
WRITING THE WEEKLY PAYROLL PROGRAM......Page 129
THE USER INTERFACE......Page 130
SECTION 5 REPETITION......Page 137
5.1 DO LOOPS......Page 139
5.2 PROCESSING LISTS OF DATA WITH DO LOOPS......Page 143
EOF FUNCTION......Page 144
COUNTERS AND ACCUMULATORS......Page 146
FLAGS......Page 147
NESTED LOOPS......Page 148
5.3 FOR...NEXT LOOPS......Page 149
5.4 A CASE STUDY: ANALYZE A LOAN......Page 154
DESIGNING THE ANALYZE-A-LOAN PROGRAM......Page 155
THE USER INTERFACE......Page 156
WRITING THE ANALYZE-A-LOAN PROGRAM......Page 157
PSEUDOCODE FOR THE ANALYZE-A-LOAN PROGRAM......Page 158
SECTION 6 ARRAYS......Page 167
6.1 CREATING AND ACCESSING ARRAYS......Page 169
ORDERED ARRAYS......Page 179
USING PART OF AN ARRAY......Page 181
PASSING ARRAYS BETWEEN PROCEDURES......Page 184
6.3 CONTROL ARRAYS......Page 187
CONTROL ARRAY EVENT PROCEDURES......Page 189
CREATING CONTROL ARRAYS AT RUN TIME......Page 190
6.4 SORTING AND SEARCHING......Page 192
BUBBLE SORT......Page 193
SHELL SORT......Page 196
SEARCHING......Page 199
6.5 TWO-DIMENSIONAL ARRAYS......Page 204
6.6 A CASE STUDY: CALCULATING WITH A SPREADSHEET......Page 208
THE USER INTERFACE......Page 209
CODING THE PROGRAM......Page 211
SECTION 7 SEQUENTIAL FILES......Page 223
CREATING A SEQUENTIAL FILES......Page 225
ADDING ITEMS TO A SEQUENTIAL FILE......Page 226
ERROR TRAPPING......Page 229
SORTING SEQUENTIAL FILES......Page 231
MERGING SEQUENTIAL FILES......Page 233
CONTROL BREAK PROCESSING......Page 235
THE DESIGN OF THE PROGRAM......Page 236
THE USER INTERFACE......Page 237
CODING THE PROGRAM......Page 239
SECTION 8 RANDOM-ACCESS FILES......Page 251
FIXED-LENTH STRINGS......Page 253
RECORDS......Page 255
8.2 RANDOM-ACCESS FILES......Page 259
SECTION 9 THE GRAPHICAL DISPLAY OF DATA......Page 265
9.1 INTRODUCTION TO GRAPHICS......Page 267
SPECIFYING A COORDINATE SYSTEM......Page 268
GRAPHICS METHODS FOR DRAWING LINES, POINTS, AND CIRCLES......Page 269
POSITIONING TEXT......Page 271
9.2 LINE CHARTS......Page 275
LINE STYLING......Page 277
9.3 BAR CHARTS......Page 281
9.4 PIE CHARTS......Page 285
SECTION 10 ADDITIONAL CONTROLS AND OBJECTS......Page 293
THE LIST BOX CONTROL......Page 295
THE COMBO BOX CONTROL......Page 298
DRIVE, DIRECTORY, AND FILE LIST BOX CONTROLS......Page 300
THE CHECK BOX CONTROL......Page 302
THE OPTION BUTTON CONTROL......Page 304
THE HORIZONTAL AND VERTICAL SCROLL BAR CONTROLS......Page 306
THE TIMER CONTROL......Page 308
THE SHAPE CONTROL......Page 309
THE IMAGE CONTROL......Page 310
THE MICROSOFT FLEXGRID CONTROL......Page 311
THE MENU CONTROL......Page 316
THE CLIPBOARD OBJECT......Page 318
MULTIPLE FORMS......Page 319
THE COMMON DIALOG CONTROL......Page 321
SECTION 11 DATABASE MANAGEMENT......Page 329
11.1 AN INTRODUCTION TO DATABASES......Page 331
A DATA CONTROL WALKTHROUGH......Page 332
USING CODE WITH A DATA CONTROL......Page 333
THE VALIDATION EVENT......Page 334
PRIMARY AND FOREIGN KEYS......Page 338
SQL......Page 339
FOUR SQL REQUESTS......Page 340
FIND METHODS......Page 344
11.3 THREE ADDITIONAL DATA-BOUND CONTROLS; CREATING AND DESIGNING DATABASES......Page 346
USING THE FLEXGRID CONTROL......Page 347
USING THE DATA-BOUND LIST BOX AND COMBO BOX CONTROLS......Page 348
CREATING A DATABASE WITH VISUAL DATA MANAGER......Page 350
CREATING A DATABASE IN CODE......Page 354
PRINCIPLES OF DATABASE DESIGN......Page 356
SECTION 12 OBJECT-ORIENTED PROGRAMMING......Page 361
12.1 CLASSES AND OBJECTS......Page 363
THE INITIALIZE EVENT PROCEDURE......Page 370
12.2 COLLECTIONS AND EVENTS......Page 373
COLLECTIONS......Page 374
KEYS......Page 377
EVENTS......Page 379
12.3 CLASS RELATIONSHIPS......Page 381
SECTION 13 COMMUNICATING WITH OTHER APPLICATIONS......Page 391
OLE AUTOMATION......Page 393
THE OLE CONTAINER CONTROL......Page 396
AN EMBEDDING WALKTHROUGH USING EXCEL......Page 397
A LINKING WALKTHROUGH USING WORD......Page 398
WHAT IS THE INTERNET?......Page 400
A WEB BROWSER WALKTHOUGH......Page 401
HTML......Page 405
PLACING ACTIVEX CONTROLS IN HTML DOCUMENTS......Page 407
ACTIVATING A WEB PAGE WITH VBSCRIPT......Page 409
APPENDICES......Page 413
APPENDIX A ANSI VALUES......Page 415
HOW TO: INSTALL, INVOKE, AND EXIT VISUAL BASIC......Page 417
HOW TO: MANAGE PROGRAMS......Page 418
HOW TO: USE THE EDITOR......Page 419
HOW TO: GET HELP......Page 420
HOW TO: MANIPULATE A DIALOG BOX......Page 421
HOW TO: Utilize the Windows Environment......Page 422
HOW TO: DESIGN A FORM......Page 423
HOW TO: WORK WITH THE PROPERTIES OF AN OBJECT......Page 424
HOW TO: MANAGE PROCEDURES......Page 426
HOW TO: USE THE DEBUGGER......Page 428
APPENDIX C VISUAL BASIC STATEMENTS, FUNCTIONS, METHODS, PROPERTIES, EVENTS, DATA TYPES, AND OPERATORS......Page 431
APPENDIX D VISUAL BASIC DEBUGGING TOOLS......Page 466
INDEX......Page 474
ACCOMANYING CD FOR MICROSOFT VISUAL BASIC 6.0, WORKING EDITION......Page 478
usf.edu......Page 0
http://www.pearsoncustom.com/link/visualbasic/collections.html......Page 482
http://www.pearsoncustom.com/link/visualbasic/pseudocode.html......Page 516
http://www.pearsoncustom.com/link/visualbasic/flowcharts.html......Page 523
http://www.pearsoncustom.com/link/visualbasic/visualbasic.html......Page 565
FreeVBCode.Com - Lists, Collections, and Arrays......Page 483
FreeVBCode.com -- Free, High-Quality Visual Basic Source Code: Best Code......Page 500
Adjust Brightness/Contrast Level of Images......Page 502
Editable Grid Control With Support for Combo Boxes and Check Boxes Version 2.0......Page 508
FreeVBCode.com -- Free, High-Quality Visual Basic Samples and Code......Page 510
FreeVBCode.Com -......Page 512
FreeVBCode.Com -......Page 514
Visual Basic Collections [AVDF Article]......Page 485
May/June 96 [AVDF Contents]......Page 494
Cool Things in SQL Server 6.0 [AVDF Article]......Page 496
Barnes & Noble.com - Microsoft Visual Basic 6.0: Programmer's Guide......Page 490
Barnes & Noble.com - Visual Basic Graphics Programming: Hands-on Applications and Advanced Color Development with Cdrom......Page 504
Visual Basic - Chapter 1......Page 517
Flowcharts and Storyboards......Page 525
Integrating Technology in FL - Syllabus......Page 527
First WWW page creation......Page 531
Bare Bones Guide to HTML -- download page......Page 535
Bare Bones Guide to HTML......Page 538
Guide du langage HTML......Page 551
Visual Basic Programming......Page 566
Why Visual Basic?......Page 567
What Visual Basic is not......Page 568
When You Program in VB:......Page 569
The Visual Basic Interface......Page 570
Drawing The Program......Page 571
Types of Controls......Page 572
A Simple Program......Page 573
The Properties Window......Page 574
Adding Code......Page 575
More Complex Controls......Page 576
Using C Code......Page 577
C Definition vs. VB Definition......Page 578
A (Very Annoying) Problem......Page 579
Alternative Methods......Page 580
Syntax Considerations......Page 581
More VB Syntax......Page 582
VB Statements......Page 583
VB IF Statements......Page 584
VB While Statements......Page 585
VB For Statements......Page 586
VB Arrays......Page 587
VB Strings......Page 588
And in Conclusion .........Page 589
And in Conclusion .........Page 590