close menu
Bookswagon-24x7 online bookstore
close menu
My Account
Home > Computing and Information Technology > Databases > Roger Jennings' Database Developer's Guide with Visual Basic 6
Roger Jennings' Database Developer's Guide with Visual Basic 6

Roger Jennings' Database Developer's Guide with Visual Basic 6

          
5
4
3
2
1

Out of Stock


Premium quality
Premium quality
Bookswagon upholds the quality by delivering untarnished books. Quality, services and satisfaction are everything for us!
Easy Return
Easy return
Not satisfied with this product! Keep it in original condition and packaging to avail easy return policy.
Certified product
Certified product
First impression is the last impression! Address the book’s certification page, ISBN, publisher’s name, copyright page and print quality.
Secure Checkout
Secure checkout
Security at its finest! Login, browse, purchase and pay, every step is safe and secured.
Money back guarantee
Money-back guarantee:
It’s all about customers! For any kind of bad experience with the product, get your actual amount back after returning the product.
On time delivery
On-time delivery
At your doorstep on time! Get this book delivered without any delay.
Notify me when this book is in stock
Add to Wishlist

About the Book

Roger Jennings' Database Developer's Guide with Visual Basic 6, Third Edition, provides in-depth coverage of all new database-related features of Visual Basic 6.0. Topics includes OLE DB 1.0, Active Data Objects (ADO) 2.0, Remote Data Services (RDS) 2.0, and DataEnvironment and DataReport objects. Client/server chapters describe how to create high-performance decision-support and OLTP applications with SQL Server 6.5 and 7.0. Advanced topics include executing parameterized stored procedures with ADO Command objects, designing and deploying Microsoft Transaction Server 2.0 components, and writing Multidimensional Expressions (MDX) to extract summarized data from PivotTable and SQL Server OLAP Services (formerly Plato) DataCubes with ADOMD, ADO 2.0's implementation of MDX.

Table of Contents:
I. ACTIVEX DATA OBJECTS AND BOUND CONTROLS. 1. Staking Visual Basic's Claim to Enterprise Development. Summarizing Visual Basic 6.0's New Data-Related Features. Migrating to OLE DB and ADO. Exploring the Data Environment Designer and the Data View Window. Adopting ADO-Compliant Controls. Binding Hierarchical FlexGrids to Recordsets. Printing Reports with the Data Report Designer. Automating Design with the Data Form Wizard. Binding Data Sources and Consumers. Using the Visual Data Tools. Working with Microsoft SQL Server. 2. Understanding OLE DB and Universal Data Access. Interfacing with Data. Creating ADODB.Recordsets. Exploring Top- Level ADO Properties, Methods, and Events. Examining Provider-Specific ADODB.Properties Collections. 3. Migrating from DAO and RDO to ADO. Comparing ADO, DAO, and RDO Object Models. Moving from DAO.Recordset to ADODB.Recordset Objects. Manipulating ADODB.Recordset Objects with VBA Code. Taking Advantage of New ADODB.Recordset Features. Adopting ADODB.Recordset Find Methods. Migrating from rdoResultsets and ODBCDirect Recordsets to ADODB.Recordsets. Understanding Hierarchical Recordsets. 4. Using the ADO Data Control with Bound Controls. Creating Simple Text Box Data Display and Editing Forms. Exploring ADODC's Data-Related Properties and Events. Introducing Batch Optimistic Updates. Simple-Binding Data Consumer Controls. Complex-Binding Data Consumer Controls. II. Database and Query Design Concepts. 5. Optimizing the Design of Relational Databases. Classifying Database Systems. Modeling Data. Rules for Relational Database Design. Indexing Tables for Performance and Domain Integrity. Warehousing and Analyzing OLTP Data. 6. Learning Structured Query Language. Reviewing the Foundations of SQL. Differences Between SQL and Procedural Computer Languages. Writing ANSI SQL Statements. Comparing the Jet SQL Dialect with ANSI SQL-92. 7. Running Crosstab and Action Queries. Using Crosstab Queries to Present Summary Data. Using TRANSFORM and PIVOT to Create Crosstab Queries. Executing Crosstab Queries as DataEnvironment Commands. Defining Action Queries. Using the SQL Action Queries. 8. Connecting to Desktop Data Sources with ODBC. Understanding the Structure of the ODBC API. Exploring ODBC Initialization Files and Registry Entries. Creating and Using a DSN for dBASE Tables. III. AN INTRODUCTION TO DATABASE FRONT-END DESIGN. 9. Designing A Decision-Support Front End. Organizing the Data Behind a Decision-Support Front End. Specifying the Data Sources. Developing Query Strategies. Designing the User Interface. Creating and Using Button Bars and Toolbars. Creating Graphs from Rolled-Up Data. Displaying Detail Data with the MSFlexGrid Control. 10. Taking Full Advantage of Data-Bound ActiveX Controls. Working with DataGrids and Hierarchical FlexGrids. Creating and Displaying Hierarchical Recordsets. Saving and Displaying Images with PictureBox and Image Controls. 11. Graphing Summary Data Created from Crosstab Queries. Organizing a Chart-Based Decision-Support Application. Deciding on a Navigation Method for Complex Decision-Support Applications. Setting Graph Properties in Design Mode. Implementing the First Two Chart Levels. Adding a Detail Grid to the MDI Child Form. Adding the Code to Populate an MSHFlexGrid Control. Writing the Code to Navigate Between Graphs and Charts. Printing and Saving Graphs and Charts. 12. Printing with the Report Designer and VBA Code. Designing and Printing a Simple DataReport. Grouping Detail Records. Using Command Aggregates for Subtotals and Grand Totals. Crossfooting Reports with Row Totals. Substituting RptFunction Controls for Aggregate Values. Exporting DataReports to HTML and Text Files. Printing with VBA Code. IV. ADVANCED PROGRAMMING FOR DATA ACCESS AND AUTOMATION. 13. Drilling Down into Data from Graphs and Charts. Taking Advantage of Chart Events. Displaying a Single Series from a Stacked Area Chart. Adding a Drilldown Pie Chart to the Drilldn.vbp Project. Using MouseDown and Double-Click Events to Activate Drilldown. Choosing the Drilldown Path with a Pie Chart. Populating an MSHFlexGrid with the Selected Drilldown Data. 14. Scheduling And Device Control with Jet and VBA. Navigating the Visual Basic Program Guide. Working with WebTV's Scheduling Database. Comparing the Performance of DAO and ADO with Large Recordsets. Upgrading Projects from DAO to ADO. Replacing Compound FindFirst and FindNext Methods with Find. Traversing a Recordset to Fill a Custom Grid. Exploring the Remainder of the VB6PG Project. 15. Writing Local Automation Components and ActiveX DLLs. Defining the Role of Automation Components. Deciding Between In- Process and Out-of-Process Components. Building a Simple Automation Component. Creating a Complex Three-Tier Automation Component. 16. Creating User Controls For Database Applications. Emulating an Access Continuous Form with the DataRepeater Control. Automating Control Generation with Wizards. Exploring the BindingCollection Object. Debugging Data-Bound ActiveX Controls. V. MULTIUSER AND CLIENT/SERVER DATABASE FRONT ENDS. 17. Networking Secure Multiuser Jet Databases. Understanding Network Topology and Operations. Working with Network Hardware and Operating Protocols. Logging on to Servers and Joining Workgroups. Maintaining Database Security in a Network Environment. File Permissions Using NTFS Partitions. Fathoming the Jet Security System. Programming Jet Security Features with Visual Basic 6.0 and DAO 3.5. OLE DB, ADO 2.0, and Jet Security. 18. Working With Client/Server Databases. Using Microsoft SQL Server. Upsizing Nwind.mdb to SQL Server 6.5 with the Access 97 Wizard. Specifying Primary Keys and Relationships in Database Diagrams. Using the Native SQL Server Provider. Connecting to Oracle8 Databases. Using Visual Data Tools with Visual Basic 6.0. Working with Client/Server Connections in VBA Code. 19. Processing Transactions and Bulk Operations. Defining Transactions and the ACID Test. Processing Transactions with ADO 2.x and VBA Code. Distributing Transactions Across Multiple Databases. Working with Bulk Updates and Disconnected Recordsets. 20. Porting Access OLTP Applications To Visual Basic 6.0. Designing Front Ends for Heads-Down Data Entry. Following the OLTP Project's Upgrade Path. Stepping Through the First Phase of the Migration Process. Making the Transition from DAO to ADO. Reviewing the Code of the Ado2oltp Project. 21. Using Transact-SQL Stored Procedures. Gaining a Performance Boost with Stored Procedures. Understanding Stored Procedure Syntax. Replacing SQL Statements with Stored Procedures. Calling Stored Procedures in VBA Code. Adapting the Ado2oltp Application to Stored Procedures. Troubleshooting Stored Procedures with the T-SQL Debugger. VI. DATABASES, INTRANETS, AND THE INTERNET. 22. Integrating Databases with Intranets and the Internet. Cutting Through the Hype for Microsoft's Digital Nervous System. Getting a Grip on Windows Distributed interNet Applications Architecture. Examining the New Internet-Related Features of Visual Basic 6.0. Creating a Simple Data-Enabled WebClass Project. Starting a Simple DHTML Project. Opening a New DHTML Project and Adding a DHTML Page. 23. Using ActiveX Document Objects with Intranets. Converting the ADO2OLTP.vbp Project to an ActiveX Document. Packaging ActiveX Document Objects. Dealing with the Architectural Issues of Multi-form Projects. 24. Working with Remote Data Services. Understanding RDS Architecture. Exploring the Methods, Properties, and Events of RDS Components. The RDS.DataSpace Object. The RDSServer.DataFactory Object. Coding for Implicit and Explicit Remoting. Programming RDS with VBA in the DHTML Page Designer. 25. Developing Data-Enabled Internet Applications. Setting Up to Run VBLive. Touring the VBLive Application. Understanding the Architecture of VBLive. Generating HTML from Structure Resources. Generating HTML Directly from Template Files. Localizing Content with a Resource File. VII. ENTERPRISE-LEVEL DEVELOPMENT TECHNIQUES. 26. Taking Advantage of Microsoft Transaction Server 2.0. Positioning MTS in the Middleware Market. Understanding the Role of MTS in N-Tier Client/Server Architecture. Setting Up MTS 2.0 Under Windows NT Server 4.0. Setting Up and Running the Bank Client on a Remote Computer. Installing MTS 2.0 on Workstations. 27. Creating and Deploying MTS Components. Defining MTS Component Candidates. Designing Efficient MTS Components. Converting a Monolithic Client to Use MTS Components. Adding Security to Your Packages and Components. 28. Analyzing Multidimensional Data with OLAP and MDX. Understanding Measures and Dimensions. Defining Measures and Dimensions at the Department Level. Categorizing OLAP Servers and Engines. Delivering Information to the Client. Exploring ADO MD Objects. VIII. APPENDIX. Appendix A. Glossary. Index.


Best Seller

| | See All


Product Details
  • ISBN-13: 9780672310638
  • Publisher: Pearson Education (US)
  • Publisher Imprint: Sams Publishing
  • Height: 189 mm
  • No of Pages: 1200
  • Weight: 1923 gr
  • ISBN-10: 0672310635
  • Publisher Date: 28 Apr 1999
  • Binding: SA
  • Language: English
  • Spine Width: 46 mm
  • Width: 230 mm


Similar Products

How would you rate your experience shopping for books on Bookswagon?

Add Photo
Add Photo

Customer Reviews

REVIEWS           
Click Here To Be The First to Review this Product
Roger Jennings' Database Developer's Guide with Visual Basic 6
Pearson Education (US) -
Roger Jennings' Database Developer's Guide with Visual Basic 6
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Roger Jennings' Database Developer's Guide with Visual Basic 6

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book
    Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    New Arrivals

    | | See All


    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!
    ASK VIDYA