Professional Visual Basic 6 Databases

While previous versions of Visual Basic had some database facilities, with Visual Basic 6, Microsoft has created a robust, fully-fledged database programming language. VB6 includes a raft of highly effective database features and toolsincluding hundreds of efficiencies, step-through wizards, and shortcutsthat in most cases are extremely easy to understand and master. Among the most important of these are ADO Data Control, Data View window, Query Designer, DataRepeater Control, Data Environment Designer, ActiveX Document Migration Wizard, WebClass Designer, and Visual Data Manager. Visual Basic 6 Database Programming For Dummies is a friendly, no-nonsense guide for programmers already familiar with Visual Basic who want to take advantage of all of version 6s powerful database features. Packed with real-world examples and plain-English explanations, it cuts through the jargon and shows you, step-by-step, how to: Build professional-looking database programs Craft user-friendly interfaces and robust reports Automate programming with built-in tools Maximize Internet connectivity with ActiveX Develop ASP and IIS applications Transitions from DAO to ADO Understand how best to use all of VBs built-in database features Get the most out of VBs Data Environment Designer Know ho to use SQL Author Richard Mansfield gives you a solid understanding of what databases are, how they work, and what you can do with them. Then he walks you through all the steps to creating powerful database applications. Topics covered include: Getting connected with data controls and the Data Form Wizard Using the Data Environment Designer Designing a user interface Building a new database from scratch Translating Windows applications to Web pages using ActiveX Document Migration Wizard Combining HTML and VB to create active server pages Creating IIS applications Data access programming Using the Query Designer Have you been baffled by the alphabet soup of VB6 acronyms? Have you tried other books on the subject and found them sourly lacking in clarity? Dont despair, relax and let Visual Basic 6 Database Programming For Dummies gently ease you into the world of database programming.

* Provides a good foundation for Microsoft Access and Visual Basic database programming * Offers thorough coverage of object-oriented programming, including how to create data handling classes and ActiveX controls for code reusability * Covers DAO, ADO, ASP, and SQL, and demonstrates how to take data mining to the next level

Broad coverage is given of many issues relating to professional database design and implementation using Visual Basic 6. The authors show how to use SQL to manipulate data and investigate advanced topics such as data warehousing and data mining.

VISUAL BASIC AND DATABASES is a tutorial that provides a detailed introduction to using Visual Basic for accessing and maintaining databases for desktop applications. Topics covered include: database structure, database design, Visual Basic project building, ADO .NET data objects (connection, data adapter, command, data table), data bound controls, proper interface design, structured query language (SQL), creating databases using Access, SQL Server and ADOX, and database reports. Actual projects developed include a books tracking system, a sales invoicing program, a home inventory system and a daily weather monitor. VISUAL BASIC AND DATABASES is presented using a combination of over 850 pages of FULL-COLOR self-study notes and actual Visual Basic examples. No previous experience working with databases is presumed. It is assumed, however, that users of the product are familiar with the Visual Basic environment and the steps involved in building a Visual Basic application (such training can be gained from our LEARN VISUAL BASIC course). VISUAL BASIC AND DATABASES requires a Microsoft Windows 7 or the Windows 8 operating system and Visual Basic Professional 2012. The Visual Basic source code and all needed multimedia files are available for download from the publisher's website (www.KidwareSoftware.com) after you register this book.

Evangelos Petroutsos is a computer engineer who gained much of his experience at the California Institue of Technology and MCI.