Beginning Visual Basic 6 Database Programming

By: John Connell

Write A Review

Paperback | 2 September 2003

At a Glance

Paperback
884 Pages

Dimensions(cm)
23.5 x 19.1 x 5.08

Paperback

$54.99

or 4 interest-free payments of $13.75 with

Ships in 5 to 7 business days

Beginning Visual Basic 6 Database Programming introduces you to databases and takes you all the way through to the latest ADO technologies in Visual Basic 6. Step by step, this book will help you to build working database components and applications in Visual Basic. Whether you want to work with databases on your desktop, get access to legacy data, or program database access across the Internet, this is the book that will get you started.

This book provides you with all the practical knowledge and skills you need to build a solid foundation in Microsoft Access and Visual Basic database programming. This comprehensive reference offers thorough coverage of object-oriented programming, including how to create data handling classes and ActiveX controls for code reusability; how to effectively use DAO, ADO, ASP, and SQL; and how to take data mining to the next level.

Shipping

	Standard Shipping	Express Shipping
Metro postcodes:	$9.99	$14.95
Regional postcodes:	$9.99	$14.95
Rural postcodes:	$9.99	$14.95

Orders over $89.00 qualify for free shipping.

How to return your order

At Booktopia, we offer hassle-free returns in accordance with our returns policy. If you wish to return an item, please get in touch with Booktopia Customer Care.

Additional postage charges may be applicable.

Defective items

If there is a problem with any of the items received for your order then the Booktopia Customer Care team is ready to assist you.

For more info please visit our Help Centre.

You Can Find This Book In

Non-Fiction Computing & I.T.Computer Programming & Software Development Object-Oriented Programming or OOP Programming & Scripting Languages Databases Software Engineering

What this Book is About	p. 1
Who Is This Book Aimed At?	p. 2
Our Approach	p. 3
What Do I Need To Use This Book?	p. 3
Customer Support	p. 4
Conventions Used In This Book	p. 4
The Road Map for This Book	p. 6
What Is a Database?	p. 9
Why Use a Database?	p. 9
What is a Database? A More In-Depth View	p. 10
Flat Files and Relational Databases	p. 14
The Relational Database in More Detail	p. 15
Our Sample Database - Biblio.mdb	p. 16
Indexes 'R' Us	p. 18
What's a Relationship Again?	p. 20
Orphaned Records	p. 23
Normalizing Our Data	p. 24
Moving On...	p. 24
Our Two Vehicles - Access and Visual Basic	p. 24
The Biblio.mdb relational database	p. 25
Where Does Our VB Program Come In?	p. 26
Getting Our Feet Wet	p. 29
The Way(s) Ahead...	p. 32
Summary	p. 35
Exercises	p. 37
Meet the ActiveX Data Object (ADO) Data Wizard	p. 39
What is the ADO Data Control?	p. 40
Meet the VB Data Form Wizard	p. 42
Looking at the Same Information in Another Way	p. 58
Pay No Attention to the Man Behind the Curtain	p. 75
The Dark Side of the Wizard	p. 75
A Word on Sorting	p. 76
Exercises	p. 81
Programming the Data Control	p. 83
Why Not Just Let the Wizard Do It?	p. 83
The Data Control and Bound Controls	p. 84
Intrinsic Controls	p. 84
The Intrinsic DAO Data Control	p. 86
What is a Recordset Exactly?	p. 87
What is a Data Bound Control?	p. 88
Working With Data Controls	p. 91
Parent/Child Data Control Relationship	p. 98
Who Was That Masked Control?	p. 104
Introducing the New ADO ActiveX Data Control	p. 105
The ADO Data Control and the Bound DataList Control	p. 106
The VB 6.0 Hierarchical FlexGrid Bound Control	p. 119
What Do All These Controls Have in Common?	p. 122
Summary	p. 123
What We Learned	p. 123
Exercises	p. 124
Designing a User Interface for the Data Control	p. 127
Designing the User Interface	p. 127
The Visual Basic Form	p. 128
Into the Heart of the Data Control	p. 134
Duplicating the Functionality of the Wizard	p. 135
Bound Controls Revisited	p. 143
The Strange and Terrible Saga of Control Arrays	p. 147
Under the Hood of the Data Control	p. 148
Just Add Code!	p. 151
Exercises	p. 164
Programming a Bulletproof User Interface	p. 167
The Data Control - Right or Wrong?	p. 167
Building an Enhanced User Interface	p. 168
Back to the Data Control...	p. 168
The State-Machine Concept	p. 172
Designing a Robust User Interface	p. 172
Enhancing Record Navigation	p. 179
A Level of Indirection	p. 180
Building the Navigation Code for the User Interface	p. 181
Adding the Interface Enhancements to our Program	p. 198
BookMarking a Record	p. 200
Enhancing Data Manipulation Via the User Interface	p. 200
Adding a Reference	p. 208
Summary	p. 213
What We Learned	p. 213
Exercises	p. 214
Completing the User Interface	p. 217
How's It Look?	p. 217
Unloading our Form - a Few Concerns	p. 218
Some Data-Entry Considerations	p. 225
Finding a Specific Record	p. 237
Look Ma, No Typing!	p. 241
A Few Words on Global Variables	p. 243
Greating the Find Form	p. 245
Data Validation - the Programmer's Bane	p. 261
Summary	p. 268
Exercises	p. 269
Building a Data Control Class Module	p. 271
The Joys of Repetitive Programming	p. 271
Reusable Components	p. 272
Copying Your Program	p. 275
Building a Class in Visual Basic 6.0	p. 276
Making a Property Read-Only or Write-Only	p. 289
Let's Take a Closer Look at the Properties	p. 291
Back to the Class Builder	p. 294
Adding Code to Our Class's Methods	p. 297
Polishing the dataClass Class Module	p. 310
Making Our Templates Available to All Our VB Projects	p. 317
Data Validation...Again	p. 326
The Object Browser - Revisited	p. 327
Refining Our dataClass Class	p. 328
Summary	p. 339
What We Learned	p. 339
Exercises	p. 341
Getting the Data You Want from the Database	p. 343
SQL - What's the Story?	p. 343
Getting the Data We Need	p. 345
Build the SQL Query Tester	p. 347
Selecting Specific Fields from a Single Table	p. 353
Filtering the Returned Recordset - the Good Stuff	p. 354
The Delete Query	p. 359
Unique or Non-Unique Fields?	p. 359
Ordering the Returned Recordset	p. 360
Aggregate Functions	p. 361
The GROUP BY Clause - Summarizing Values	p. 366
Joining Tables	p. 367
The SQL Update Statement	p. 371
"Pay no attention to the man behind the curtain"	p. 376
Enough Theory - Let's Build a Dynamic SQL Generator!	p. 379
Summary	p. 384
What We Learned	p. 384
Exercises	p. 385
Database Design, Construction and Analysis	p. 387
When to use DAO and ADO - A Rule of Thumb	p. 388
Giving VB 6.0 the Reference to DAO	p. 389
The Personal Address Book	p. 390
1st Normal Form - Eliminate Any Repeating Groups	p. 394
2nd Normal Form - Splitting Tables	p. 395
3rd Normal Form - Eliminate Columns Not Dependent on Key	p. 397
Creating our Database	p. 400
Guidelines for Creating Indexes	p. 407
Creating a Database with DAO	p. 409
Objects and Collections	p. 412
Database Objects	p. 414
Connect the Dots	p. 414
Recordset Objects	p. 417
Analyzing a .mdb File Using DAO	p. 425
Summary	p. 437
What We Learned	p. 437
Exercises	p. 438
Programming The Address Book	p. 441
The Microsoft Tab Control	p. 449
Let's Write Some Code	p. 455
The Initialized Address Book Program	p. 473
Converting Dates	p. 477
The frmCall Form - Where to Log Calls	p. 492
Add a New Call or Cancel the Operation?	p. 502
The DB Statistics Tab	p. 504
How It All Works - A Global Recap	p. 505
What We Learned	p. 510
Exercises	p. 511
Universal Data Access Using ADO	p. 513
What's the Background to ADO?	p. 513
The Quest for Data	p. 514
Universal Data Access	p. 518
The ADO Object Model	p. 530
The ADO Object Model - Revisited	p. 561
Summary	p. 573
What we Learned	p. 573
Exercises	p. 574
Creating ADO Data Bound ActiveX Controls	p. 577
We Could Create ActiveX Controls Before, Couldn't We?	p. 578
The Holy Grail of Code Reusability	p. 578
C++ and Visual Basic - a Short (and Partial) History	p. 579
Time Out to Discuss Data Binding	p. 579
Binding Datafields to Controls	p. 581
Creating Our Own Data Control	p. 592
The Brand New VB 6.0 Data Repeater Control	p. 637
Setting the Procedure Attributes	p. 642
Summary	p. 649
What Have We Learned?	p. 649
Exercises	p. 650
ADO and Active Server Pages	p. 653
Active Server Pages	p. 653
Hyper Text Markup Language - or HTML	p. 654
Enter Active Server Pages	p. 656
How to set up PWS on Your Machine	p. 657
ASP, Scripts and HTML	p. 664
What Does an ASP Script Look Like?	p. 664
A More Robust ASP Example Using ADO	p. 671
A Simple Client/Server ADO Application	p. 679
Persistent Client Side Data Using Cookies	p. 687
Summary	p. 710
What We've Learned	p. 710
Exercises	p. 711
Advanced ADO Programming - Data Mining	p. 713
Data, Data, Everywhere...	p. 713
Data Mining	p. 714
ID3 Project Form and Code Initialization	p. 721
Determining the Entropy of the Values We Added	p. 747
A Word on Creating That SQL Statement	p. 760
What We Learned	p. 761
Exercises	p. 762
Making our Data Available Universally	p. 765
Exporting Recordsets to other Programs	p. 765
Exporting Our Data in a Comma Delimited File	p. 769
Exporting Our Data in HTML	p. 781
Using Objects to Send ADO Data to an Excel Worksheet	p. 787
Late Binding	p. 788
Early Binding	p. 789
Sending ADO Recordset Information to Excel	p. 790
Advanced ADO Techniques	p. 798
Getting the AbsolutePosition Property	p. 809
Another ADO 2.0 Wonder - Persistent Recordsets	p. 811
Summary	p. 815
What We Have Learned	p. 816
Exercises	p. 817
Where Next?	p. 819
This Land is Your Land	p. 819
One Standard, Many Flavors...	p. 825
The [Field Name] Syntax	p. 825
The Between Clause	p. 826
Column Aliases	p. 826
Joins	p. 826
Summary	p. 827
Solutions	p. 829
Chapter 1	p. 829
Chapter 2	p. 830
Chapter 3	p. 831
Chapter 4	p. 832
Chapter 5	p. 833
Chapter 6	p. 834
Chapter 7	p. 835
Chapter 8	p. 836
Chapter 9	p. 837
Chapter 10	p. 838
Chapter 11	p. 840
Chapter 12	p. 841
Chapter 13	p. 842
Chapter 14	p. 843
Chapter 15	p. 843
Summary of Microsoft Access Field Types	p. 847
Index	p. 849
Table of Contents provided by Ingram. All Rights Reserved.

Beginning Visual Basic 6 Database Programming

At a Glance

Paperback

Shipping

How to return your order

Defective items

You Can Find This Book In

More in Software Engineering

Introduction to Psychophysics with Python

Cloud-Native Modernization Unleashed

Revolutionizing Legacy Systems with Spring, Ai, Cloud, and Microservices

The Essence of Software Engineering

Making Embedded Systems

2nd Edition - Design Patterns for Great Software

Building Microservices

Designing Fine-Grained Systems 2nd Edition

Fundamentals of Software Architecture

A Modern Engineering Approach

Design Patterns

Elements of Reusable Object-Oriented Software

Git : Pocket Guide

A Working Introduction

The Manager`s Path

A Guide for Tech Leaders Navigating Growth and Change

Site Reliability Engineering

How Google Runs Production Systems

The Pragmatic Programmer 2nd edition

your journey to mastery, 20th Anniversary Edition

C# 12 in a Nutshell

The Definitive Reference

Developing Graphics Frameworks with Java and OpenGL

Arduino for Dummies

Blackwell Philosophy Anthologies

Robert C. Martin

A Craftsman's Guide to Software Structure and Design

Architecture Patterns with Python

Enabling Test-Driven Development, Domain-Driven Design, and Event-Driven Microservices

Swim Training Patterns

1st Edition - Plan your Training Sessions with the Power of Mathematics

Code

2nd Edition - The Hidden Language of Computer Hardware and Software

Coding All-in-One For Dummies

2nd Edition

Hacking For Dummies

For Dummies (Computer/Tech)

Web Application Security

2nd Eidtion - Exploitation and Countermeasures for Modern Web Applications

Learning Modern C++ for Finance

Foundations for Quantitative Programming

Robert C. Martin

A Handbook of Agile Software Craftsmanship

User Story Mapping

Discover the Whote Story, Build the Right Product

This product is categorised by