Table of Contents

Introduction 1 Part I: The Basics of Databases 9 Chapter 1: The Big Picture: Visual Basic's Database Features 11 Chapter 2: Databases 101: How Databases Work 19 Part II: Making a Connection 35 Chapter 3: Getting Connected with Data Controls and the Data Form Wizard 37 Chapter 4: Using the Data Environment Designer 53 Chapter 5: A Collection of Connection 71 Part III: Contacting the User 87 Chapter 6: Reports-Plain and Fancy 89 Chapter 7: Designing a User Interface 107 Part IV: Building a New Database 123 Chapter 8: Creating and Manipulating a New Database 125 Chapter 9: Validating and Indexing Your Data 135 Chapter 10: Creating Custom, Data-Bound ActiveX UserControls 147 Part V: The Internet Connection 163 Chapter 11: Translating Windows Applications to Web Pages: Using the ActiveX Document Migration Wizard 165 Chapter 12: Mixing HTML and VB: Active Server Pages 183 Chapter 13: IIS Applications: Moving Beyond ASP 197 Part VI: Hands-On Programming 217 Chapter 14: Doing it Yourself: Data Access Programming 219 Chapter 15: Acronym Soup: ADO, DAO, RDO, UDA 257 Chapter 16: Focus on ADO 265 Chapter 17: Killing Bugs 287 Part VII: Working with Queries 303 Chapter 18: Automatic SQL: Using the Query Designer 305 Chapter 19: A Brief Dictionary of SQL 325 Part VIII: The Part of Tens 347 Chapter 20: Ten Outstanding Add-Ons 349 Chapter 21: Ten Topics that Don't fit Elsewhere in the Book (But Are Important) 353 Index 363 Book Registration Information......Back of Book

About the Author

Richard Mansfield, the former editor of Compute! magazine, is the author of more than 20 computer book bestsellers, including Visual Studio 6 For Dummies and Visual InterDev Bible. Nickolas Landry, who supplied the technical review, is an MCSD and a Microsoft Regional Director.