Cover image for Sams teach yourself Microsoft Access 2002 programming in 24 hours
Title:
Sams teach yourself Microsoft Access 2002 programming in 24 hours
Author:
Kimmel, Paul.
Personal Author:
Publication Information:
Indianapolis, Ind. : Sams, [2002]

©2002
Physical Description:
xix, 549 pages : illustrations ; 24 cm
General Note:
Includes index.
Language:
English
Title Subject:
Subject Term:
ISBN:
9780672320989
Format :
Book

Available:*

Library
Call Number
Material Type
Home Location
Status
Central Library QA76.9.D3 K545 2002 Adult Non-Fiction Central Closed Stacks
Searching...

On Order

Summary

Summary

Sams Teach Yourself Access 2002 Programming in 24 Hours will considerably improve the quality of the database applications that the reader can create with Microsoft Access. Concise tutorials that quickly bring the reader up to speed will be the goal of each chapter. Having completed this book, the readers will be able to understand any sample VBA code that they see, and will possess the skills to attack all of the most common Access programming tasks.

Topics covered in the book will include: #65533; Using data aware controls #65533; Creating data aware web pages #65533; Creating views to organize data #65533; Building reusable code modules #65533; Programming reports #65533; Communicating results with graphing #65533; Automating contact and task management with Outlook #65533; Access programming for Internet Explorer


Author Notes

Paul Kimmel is the founder of Software Conceptions. Software Conceptions provides software development and consulting services to small, medium, and large companies worldwide. Paul has been developing business solutions in Microsoft Access for more than 10 years and is available for consulting and development projects (at pkimmel@softconcepts.com).

Paul is the author of several books on Visual Basic and Access programming, including the upcoming Visual Basic.NET Unleashed, and is the co-author of Sams Microsoft Access 2002 Development Unleashed. Paul is the weekly author of the free newsletter Code Guru Visual Basic Tech Notes from Internet.com. Paul resides in Okemos, Michigan with wife Lori and children Trevor, Douglas, Alex, and Noah, all accompanied by their assorted critters.


Table of Contents

Introductionp. 1
Part I Access Programming 101p. 3
Hour 1 What's New in Access 2002p. 5
New Side Panes for Easier Navigationp. 6
Customizing Menus and Toolbarsp. 6
Spell-Checking Datap. 9
Editing Optionsp. 11
Speech Command and Controlp. 12
Collaborating Onlinep. 12
Network Placesp. 14
Remove Author Informationp. 15
Introducing ActiveX Data Objectsp. 15
Programming Objectsp. 16
Adding Data to Web Pagesp. 17
Access Projectsp. 17
Summaryp. 18
QandAp. 18
Workshopp. 19
Hour 2 Exploring VBAp. 21
Understanding How Access VBA Worksp. 22
Learning Access VBA Keywordsp. 22
Access Operators and Operandsp. 24
Data: What a Program Knowsp. 26
Putting It All Togetherp. 28
Prelude to Advanced Topicsp. 32
Summaryp. 33
QandAp. 33
Workshopp. 34
Hour 3 Storing Your Program's Datap. 35
How Memory Is Usedp. 36
Declaring Variablesp. 37
Data Assignment and Evaluationp. 40
Be Explicitp. 41
Using Pop-up Hintsp. 43
Using the Locals Windowp. 46
Using the Watches Windowp. 46
Running Code in the Immediate Windowp. 49
Employing the Call Stackp. 51
Summaryp. 52
QandAp. 52
Workshopp. 52
Hour 4 Controlling Program Flow and Performing Calculationsp. 55
What Goes into an Equationp. 56
Understanding Operator Countp. 60
Using Arithmetic Operatorsp. 60
Performing Comparisonsp. 61
The Truth of Logical Operatorsp. 63
Concatenate Itp. 68
Who Has Precedence Here?p. 69
Special Operatorsp. 70
Summaryp. 71
QandAp. 72
Workshopp. 72
Part II Writing Code to Manage Your Access Datap. 73
Hour 5 Learning to Write Conditional Codep. 75
A Programmer's Traffic Copp. 76
Tidying Up Nested Conditional Statementsp. 80
Want to Go for a Spin?p. 82
Take It Once Around the Blockp. 84
Iterating Through Datap. 86
Iterating Collections of Datap. 89
Short-circuiting Codep. 90
Using the Switch Functionp. 91
Summaryp. 92
QandAp. 92
Workshopp. 93
Hour 6 Managing Your Databasep. 95
Access 2002 Is Backward Compatible with Access 2000p. 96
Creating a Databasep. 97
Managing a Table with Codep. 104
Iteratively Inputting User Datap. 108
Using Conditional Code to Find Datap. 109
Summaryp. 111
QandAp. 111
Workshopp. 112
Hour 7 Using Advanced Data Types to Manage Datap. 113
Understanding OLE Automationp. 115
Using the ADODB Objectp. 118
Using the ADOX Objectp. 124
Summaryp. 127
QandAp. 128
Workshopp. 128
Part III Using Access Resources to Get the Job Donep. 131
Hour 8 Solving Problems a Piece at a Timep. 133
The Mechanics of Writing Subroutinesp. 134
The Mechanics of Writing Functionsp. 140
Programming Rules of Thumbp. 141
Tying It All Togetherp. 144
Summaryp. 150
QandAp. 150
Workshopp. 151
Hour 9 Using Macros As Learning Aidsp. 153
Creating a Macro 101p. 154
Using CopyObjectp. 161
Using DeleteObjectp. 162
The Keys to the Cityp. 164
Importing Datap. 165
Using Macro Resources in Codep. 169
To Macro or Not to Macrop. 170
Summaryp. 171
QandAp. 172
Workshopp. 172
Hour 10 Employing Access Predefined Solutionsp. 175
Using String-Handling Functionsp. 176
Formatting Datap. 183
Using Date and Time Functionsp. 184
Managing File I/Op. 185
Dynamic User Input Functionsp. 191
Using Function, Method, Property, and Statement Referencesp. 192
Summaryp. 192
QandAp. 193
Workshopp. 193
Part IV Defining Data Types and Using Arrays and Collectionsp. 195
Hour 11 Making the Complex Simple: Creating Your Own Data Typesp. 197
Understanding Aggregationp. 198
Using the Type Declarationp. 198
What Kind of Data Can Go into My Type?p. 200
Declaring Instances of User Typesp. 202
Defining Enumerated Typesp. 203
Putting It All Togetherp. 205
Summaryp. 205
QandAp. 206
Workshopp. 206
Hour 12 Managing Varying Amounts of Datap. 207
Understanding Arraysp. 208
Declaring Arraysp. 209
Using Arrays to Store Datap. 212
Functions for Managing Arraysp. 215
Returning Arrays from a Functionp. 218
Things You Should Do When Using Arraysp. 219
Sorting Array Datap. 220
Summaryp. 226
QandAp. 226
Workshopp. 227
Hour 13 Storing Information in a Collectionp. 229
Understanding Collectionsp. 230
Declaring Collection Variablesp. 232
Managing a Data Collectionp. 233
Places You'll Find Collectionsp. 238
Summaryp. 238
QandAp. 239
Workshopp. 239
Part V Database Programming in Accessp. 241
Hour 14 Managing Your Codep. 243
Naming Conventionsp. 244
Using Whitespace Consistentlyp. 248
Managing Complexityp. 250
Commenting Guidelinesp. 252
Understanding the Benefits of Code Reusep. 253
Testing and Debuggingp. 254
Managing Datap. 254
Summaryp. 255
QandAp. 255
Workshopp. 256
Hour 15 Data Programming Made Easy with ADODBp. 257
Connecting to a Databasep. 258
Managing a Recordsetp. 265
Finding Recordsp. 273
Copying Data to a Collection Objectp. 277
Using AddItem and RemovItemp. 278
Finding ActiveX Data Objects Resources Onlinep. 279
Summaryp. 280
QandAp. 281
Workshopp. 281
Hour 16 Using Advanced SQL Techniquesp. 283
Using the SELECT Statementp. 284
Inserting New Datap. 296
Updating Datap. 300
Deleting Datap. 301
Calling Functions in SQL Codep. 302
Writing Stored Proceduresp. 302
Querying a SQL Server Databasep. 306
Summaryp. 307
QandAp. 308
Workshopp. 308
Part VI Master Error Handlingp. 311
Hour 17 Removing Bugsp. 313
Scaffoldingp. 314
Trapping Codep. 318
Tracing Codep. 320
Asserting Assumptionsp. 321
Using Compiler Directivesp. 323
Making Debug Code Read-Onlyp. 327
Development Versus Deployment Error Handlingp. 327
Summaryp. 328
QandAp. 329
Workshopp. 329
Hour 18 Adding Code to Handle Errorsp. 331
Comparing Error-Handling Stylesp. 332
Writing Error Handlersp. 334
Clearing the Error Handlerp. 336
Writing Silent Error Handlersp. 337
Using the Err Objectp. 339
Using Error Handlers to Validate User Inputp. 341
Creating the Resource-Protection Block Idiomp. 342
Reviewing the Debug Objectp. 344
Summaryp. 344
QandAp. 345
Workshopp. 345
Part VII Creating Access User Interfacesp. 347
Hour 19 Creating Custom Forms and Reportsp. 349
Using Form Wizardsp. 350
Customizing Wizard Formsp. 361
Testing Your Formp. 371
Defining a Reportp. 371
Setting the Startup Point for Your Programp. 375
Summaryp. 376
QandAp. 376
Workshopp. 377
Hour 20 Adding Data to Web Pagesp. 379
Comparing Intranets to Internetsp. 380
Understanding Web Pagesp. 383
Building the Database Used for the Demop. 385
Using Wizards to Generate Web Pagesp. 387
Using Web Page Design Toolsp. 390
Adding a PivotTable to Web Pagesp. 399
XML's Role in Accessp. 402
Summaryp. 403
QandAp. 403
Workshopp. 404
Part VIII Object-Oriented Programming in Accessp. 405
Hour 21 Class Programming Basicsp. 407
Understanding the Need for Classesp. 408
Creating Your First Classp. 410
Hiding Information to Make Code Easier to Usep. 411
Defining Class Methodsp. 413
Defining Propertiesp. 416
Writing Initialization and Termination Codep. 420
Writing a New Classp. 421
Creating an Instance of a Classp. 424
Summaryp. 426
QandAp. 426
Workshopp. 427
Hour 22 Adding Capabilities to Your Data Typesp. 429
Defining the Objectivep. 430
Understanding When to Write a Classp. 430
Applying Basic Principles of Object-Oriented Designp. 432
Extending Existing Classesp. 435
Testing Your New Classp. 440
Using the Strings Classp. 441
Summaryp. 442
QandAp. 442
Workshopp. 443
Hour 23 Writing Access Add-Insp. 445
Introducing Add-Insp. 446
Defining an Error-Logging Databasep. 447
Defining a Viewer for the Error Logp. 451
Testing the Error Logging Add-In Databasep. 452
Installing and Uninstalling Add-insp. 453
Going for a Test Drivep. 458
Summarizing the Processp. 458
Summaryp. 459
QandAp. 459
Workshopp. 460
Hour 24 Managing Outlook Contact Informationp. 461
Understanding Outlook 2002p. 462
Introducing the Outlook Object Modelp. 462
Viewing Outlook Contacts in Accessp. 468
Updating Outlook Informationp. 469
Searching the Body of a Mail Itemp. 470
Undeleting Mail Itemsp. 472
Sending Mail to Contacts Automaticallyp. 474
Summaryp. 475
QandAp. 476
Workshopp. 476
Part IX Appendixp. 477
Appendix A Answersp. 479
Hour 1

p. 479

Hour 2

p. 481

Hour 3

p. 481

Hour 4

p. 482

Hour 5

p. 483

Hour 6

p. 484

Hour 7

p. 486

Hour 8

p. 487

Hour 9

p. 488

Hour 10

p. 490

Hour 11

p. 491

Hour 12

p. 492

Hour 13

p. 493

Hour 14

p. 495

Hour 15

p. 495

Hour 16

p. 496

Hour 17

p. 497

Hour 18

p. 499

Hour 19

p. 500

Hour 20

p. 501

Hour 21

p. 502

Hour 22

p. 504

Hour 23

p. 505

Hour 24

p. 506

Indexp. 507

Google Preview