Home > Store

Sams Teach Yourself Database Programming with Visual Basic 6 in 21 Days, 3rd Edition

Add To My Wish List

Sams Teach Yourself Database Programming with Visual Basic 6 in 21 Days, 3rd Edition

By Curt Smith, Michael Amundsen
Published Sep 28, 1998 by Sams. Part of the Sams Teach Yourself series.

Book

Sorry, this book is no longer in print.

Not for Sale

About

Description

Sample Content

Updates

More Information

About

FAQs

Question 1: Is there updated source code or errata available for this title?

Solution 1: You can find errata for this title at http://www.amundsen.com/books/tydbvb6.asp

Question 2: I can't copy the CD files to my hard drive.

Solution 2: After you do the initial install, go to the start/programs menu then select Source code at the bottom with the computer with the blue screen. This will install the source code to your hard drive.

Question 3: When I run the 1st 'scratch program', page 50, it gives me the "Runtime error '424', object required". The line it points to is:

imHappy.Picture = LoadPicture("\Program Files\Microsoft Visual Studio\Common\Graphics\Bitmaps\Assorted\Happy.bmp")

Solution 3: The problem is that the file named HAPPY.BMP must not be located in the typical directory where VB normally places it. Depending on the installation options, the file may not even have been installed at all.

The overall steps needed to fix this problem:

1. Locate HAPPY.BMP
2. Replace the path in the program with the correct path on your PC.

I would use the Windows Find feature to locate HAPPY.BMP on the hard disk. You can click the Windows Start button and select Find - Files and Folders, type HAPPY.BMP and press Enter to locate the file. If it's found,
you'll have to look at its location directory path, which may be very long, and put that exact path in the code. If you do not find it, do a Find on the VB CD-ROM itself. If you find it, you can create a directory on your hard disk and copy the files from that CD's directory to your hard disk directory
and use the new hard disk directory path for this program (other programs use these BMP files as well.)



Description

Copyright 1998
Edition: 3rd

Book
ISBN-10: 0-672-31308-1
ISBN-13: 978-0-672-31308-0

Sams Teach Yourself Database Programming with Visual Basic 6 in 21 Days is a tutorial that allows you to learn about working with databases in a set amount of time. The book presents you with a step-by-step approach to learning what can be a critical topic for developing applications. Each week will focus on a different aspect of database programming with Visual Basic. Some of the topics covered are data controls, programming with the Microsoft Jet Engine, and programming with the ODBC Interface and SQL.



Sample Content

Introduction.

Who Should Read This Book. What You Need to Use This Book. Quick Course Summary. What's Not Covered in This Book. What's on the CD-ROM? Online Resources.

WEEK 1 - AT A GLANCE.

1. Database Programming Basics.

Starting Your New Visual Basic Project. Adding the Database Control. Adding the Bound Input Controls. Adding the New and Delete Command Buttons. What Are Relational Databases? Visual Basic Database Field Types. Summary. Quiz. Exercises.

2. Visual Basic Database Access Objects.

Dataset-Oriented Versus Data Record-Oriented. The Dynaset-type Recordset Data Object. The Table-type Recordset Data Object. Strengths of the Table-type Recordset Data Object. The Snapshot-type Recordset Data Object. The Data Control Database Data Object. Summary. Quiz. Exercises.

3. Creating Data Entry Forms with Bound Controls.

What Are Bound Data Controls? Using the Data Control. Adding the Bound Text Control and the Bound Label Control. Adding the Bound Check Box Control. Adding the Bound OLE Control. General Design Rules for Quality Forms. Summary. Quiz. Exercises.

4. Input Validation.

What Is Input Validation? Common Input Validation Rules. Field-Level Validation. Form-Level Validation. Using the <F35014M>VText Custom Control. Summary. Quiz. Exercises.

5. Writing Reports for Visual Basic 6 Applications.

Understanding Report Writing. Creating a Report with the Data Report Designer. Formatting Your Report. Inserting Headers and Footers. Creating Reports Using SQL Statements. Building More Complex Data Reports. Exporting Data. Creating Data Reports from Joined Tables. Summary. Quiz. Exercise.

6. Using the Visdata Program.

Using Visdata to Maintain Databases and Tables. The Visdata Opening Screen. What's on the Visdata File Menu? Using Visdata to Add Tables and Indexes to the Database. What's on the Visdata Utility Menu? What's on the Visdata Windows and Help Menus? Summary. Quiz. Exercises.

7. Selecting Data with SQL.

What Is SQL? SQL Basics. The <F35014M>SELECT_FROM Statement. SQL Aggregate Functions. More SQL DML Statements. Summary. Quiz. Exercises.

WEEK 1 - IN REVIEW.

Day 1: Database Programming Basics. Day 2: Visual Basic Database Access Objects. Day 3: Creating Data Entry Forms with Bound Controls. Day 4: Input Validation. Day 5: Writing Reports for Visual Basic Applications. Day 6: Using the Visdata Program. Day 7: Selecting Data with SQL.

WEEK 2 - AT A GLANCE.

8. Visual Basic and the DAO Jet Database Engine.

What Is the DAO Database Engine? Building the DAO Project. The DBEngine Object Methods and Properties. The Workspace Data Object. The Database Data Object. The QueryDef Data Object. Building the QueryDef Form. Other DAO Jet Objects. Summary. Quiz. Exercise.

9. Creating Database Programs with the Data Environment Designer.

Introducing the Data Environment Designer (DED). Using the Data Environment Designer. Creating a Data Entry Application with DED. Creating Your Own Data-Bound Controls. Summary. Quiz. Exercise.

10. Displaying Your Data with Graphs.

The Advantages of Graphing Your Data. Loading and Using the Microsoft Chart Control. Creating the <F35014M>CHARTING Project. Copying, Saving, and Printing Your Charts. Creating Your Data Chart DLL Component. Testing the <F35014M>DataGraph Component. Summary. Quiz. Exercise.

11. Data-Bound List Boxes, Grids, and Subforms.

The Data-Bound List and Combo Boxes. The Data-Bound Grid. Using the <F35014M>dbFind Custom Control. Using the Data Grid to Create a Subform. Summary. Quiz. Exercise.

12. Creating Databases with SQL.

Using the <F35014M>SQL-VB6 Interpreter. Why Use SQL to Create and Manage Data Tables? Using Table Management SQL Keywords. Using Relationship SQL Keywords. Summary. Quiz. Exercise.

13. Error Handling in Visual Basic 6.

Error Handling in General. Error Handling in Visual Basic. The Built-In Visual Basic Error Objects. Creating Your Own Error Handlers. Creating a Simple Error Handler. Types of Errors. Reporting Errors in External Components. Using the Error Handler OLE Component. Summary. Quiz. Exercises.

14. Updating Databases with SQL.

Using Data Manipulation SQL Keywords. Summary. Quiz. Exercises.

WEEK 2 - IN REVIEW.

Day 8: Visual Basic and the DAO Jet Database Engine. Day 9: Creating Database Programs with the Data Environment Designer. Day 10: Displaying Your Data with Graphs. Day 11: Data-Bound List Boxes, Grids, and Subforms. Day 12: Creating Databases with SQL. Day 13: Error Handling in Visual Basic 6. Day 14: Updating Databases with SQL.

WEEK 3 - AT A GLANCE.

15. Database Normalization.

What Is Data Normalization? A Typical Database Before Normalization. Applying the Rules of Data Normalization. Summary. Quiz. Exercises.

16. Multiuser Considerations.

Understanding Database Locking Schemes. Database Locking. Using Cascading Updates and Deletes. Adding Transaction Management to Database Application. Summary. Quiz. Exercises.

17. Using the Remote Data Control and the RDO Model.

The RDO Object Model Summary. The Basics of Remote Data Access. Building an ODBC Definition. Programming with the Remote Data Control. Programming with RDO. Summary. Quiz. Exercise.

18. Using the ActiveX Data Objects (ADO).

What Is ADO? Special ADO Properties. Programming with the ADO Data Control (ADODC). Building the ADO Data Control Project. Starting the ADO Data Entry Project. Programming with the ADO Library (ADODB). Summary. Quiz. Exercise.

19. Attaching to Databases.

Benefits of Attaching Tables. Disadvantages of Attaching Data Tables. Attaching Data with Visdata. Working with DAO to Attach a Table. Attaching Data with DAO Code. The New Generation: Attaching Data with ADO. Summary. Quiz. Exercise.

20. Database Replication.

What Is Database Replication? Why Use Database Replication? When Is Database Replication Not a Good Idea? Making a Database Replicable. What Happens to a Database When You Make It Replicable? Creating Replicas. Synchronizing Members of a Replica Set. Resolving Synchronization Conflicts. Errors That May Occur During Replication. Replication Topologies. Keeping Database Elements from Replicating. Summary. Quiz. Exercise.

21. Securing Your Database Applications.

Database Security. Application Security. Building a Test Application. About the <F35014M>SECURITY COM Object. Adding User Login and Logout Security. Adding Permission-Checking Security. Adding User Action Auditing. Adding Data Field Change Auditing. Summary. Quiz. Exercise.

WEEK 3 - IN REVIEW.

Day 15: Database Normalization. Day 16: Multiuser Considerations. Day 17: Using the Remote Data Control and the RDO Model. Day 18: Using the ActiveX Data Objects (ADO). Day 19: Attaching to Databases. Day 20: Database Replication. Day 21: Securing Your Database Applications.

APPENDIX - Answers to Quizzes and Exercises.

Day 1, “Database Programming Basics”. Day 2, “Visual Basic Database Access Objects”. Day 3, “Creating Data Entry Forms with Bound Controls”. Day 4, “Input Validation”. Day 5, “Writing Reports For Visual Basic 6 Applications”. Day 6, “Using the Visdata Program”. Day 7, “Selecting Data with SQL”. Day 8, “Visual Basic and the DAO Jet Database Engine”. Day 9, “Creating Database Programs with the Data Environment Designer”. Day 10, “Displaying Your Data with Graphs”. Day 11, “Data-Bound List Boxes, Grids, and Subforms”. Day 12, “Creating Databases with SQL”. Day 13, “Error Handling in Visual Basic 6". Day 14, ”Updating Databases with SQL". Day 15, “Database Normalization”. Day 16, “Multiuser Considerations”. Day 17, “Using the Remote Data Control and the RDO Model”. Day 18, “Using the ActiveX Data Objects (ADO)”. Day 19, “Attaching to Databases”. Day 20, “Database Replication”. Day 21, “Securing Your Database Applications”.

Index.



Updates

Submit Errata



More Information



InformIT Promotional Mailings & Special Offers

I would like to receive exclusive offers and hear about products from InformIT and its family of brands. I can unsubscribe at any time.

Privacy Notice

Overview

Pearson Education, Inc., 221 River Street, Hoboken, New Jersey 07030, (Pearson) presents this site to provide information about products and services that can be purchased through this site.

This privacy notice provides an overview of our commitment to privacy and describes how we collect, protect, use and share personal information collected through this site. Please note that other Pearson websites and online products and services have their own separate privacy policies.

Collection and Use of Information

To conduct business and deliver products and services, Pearson collects and uses personal information in several ways in connection with this site, including:

Questions and Inquiries

For inquiries and questions, we collect the inquiry or question, together with name, contact details (email address, phone number and mailing address) and any other additional information voluntarily submitted to us through a Contact Us form or an email. We use this information to address the inquiry and respond to the question.

Online Store

For orders and purchases placed through our online store on this site, we collect order details, name, institution name and address (if applicable), email address, phone number, shipping and billing addresses, credit/debit card information, shipping options and any instructions. We use this information to complete transactions, fulfill orders, communicate with individuals placing orders or visiting the online store, and for related purposes.

Surveys

Pearson may offer opportunities to provide feedback or participate in surveys, including surveys evaluating Pearson products, services or sites. Participation is voluntary. Pearson collects information requested in the survey questions and uses the information to evaluate, support, maintain and improve products, services or sites, develop new products and services, conduct educational research and for other purposes specified in the survey.

Contests and Drawings

Occasionally, we may sponsor a contest or drawing. Participation is optional. Pearson collects name, contact information and other information specified on the entry form for the contest or drawing to conduct the contest or drawing. Pearson may collect additional personal information from the winners of a contest or drawing in order to award the prize and for tax reporting purposes, as required by law.

Newsletters

If you have elected to receive email newsletters or promotional mailings and special offers but want to unsubscribe, simply email information@informit.com.

Service Announcements

On rare occasions it is necessary to send out a strictly service related announcement. For instance, if our service is temporarily suspended for maintenance we might send users an email. Generally, users may not opt-out of these communications, though they can deactivate their account information. However, these communications are not promotional in nature.

Customer Service

We communicate with users on a regular basis to provide requested services and in regard to issues relating to their account we reply via email or phone in accordance with the users' wishes when a user submits their information through our Contact Us form.

Other Collection and Use of Information

Application and System Logs

Pearson automatically collects log data to help ensure the delivery, availability and security of this site. Log data may include technical information about how a user or visitor connected to this site, such as browser type, type of computer/device, operating system, internet service provider and IP address. We use this information for support purposes and to monitor the health of the site, identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents and appropriately scale computing resources.

Web Analytics

Pearson may use third party web trend analytical services, including Google Analytics, to collect visitor information, such as IP addresses, browser types, referring pages, pages visited and time spent on a particular site. While these analytical services collect and report information on an anonymous basis, they may use cookies to gather web trend information. The information gathered may enable Pearson (but not the third party web trend services) to link information with application and system log data. Pearson uses this information for system administration and to identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents, appropriately scale computing resources and otherwise support and deliver this site and its services.

Cookies and Related Technologies

This site uses cookies and similar technologies to personalize content, measure traffic patterns, control security, track use and access of information on this site, and provide interest-based messages and advertising. Users can manage and block the use of cookies through their browser. Disabling or blocking certain cookies may limit the functionality of this site.

Do Not Track

This site currently does not respond to Do Not Track signals.

Security

Pearson uses appropriate physical, administrative and technical security measures to protect personal information from unauthorized access, use and disclosure.

Children

This site is not directed to children under the age of 13.

Marketing

Pearson may send or direct marketing communications to users, provided that

Pearson will not use personal information collected or processed as a K-12 school service provider for the purpose of directed or targeted advertising.
Such marketing is consistent with applicable law and Pearson's legal obligations.
Pearson will not knowingly direct or send marketing communications to an individual who has expressed a preference not to receive marketing.
Where required by applicable law, express or implied consent to marketing exists and has not been withdrawn.

Pearson may provide personal information to a third party service provider on a restricted basis to provide marketing solely on behalf of Pearson or an affiliate or customer for whom Pearson is a service provider. Marketing preferences may be changed at any time.

Correcting/Updating Personal Information

If a user's personally identifiable information changes (such as your postal address or email address), we provide a way to correct or update that user's personal data provided to us. This can be done on the Account page. If a user no longer desires our service and desires to delete his or her account, please contact us at customer-service@informit.com and we will process the deletion of a user's account.

Choice/Opt-out

Users can always make an informed choice as to whether they should proceed with certain services offered by InformIT. If you choose to remove yourself from our mailing list(s) simply visit the following page and uncheck any communication you no longer want to receive: www.informit.com/u.aspx.

Sale of Personal Information

Pearson does not rent or sell personal information in exchange for any payment of money.

While Pearson does not sell personal information, as defined in Nevada law, Nevada residents may email a request for no sale of their personal information to NevadaDesignatedRequest@pearson.com.

Supplemental Privacy Statement for California Residents

California residents should read our Supplemental privacy statement for California residents in conjunction with this Privacy Notice. The Supplemental privacy statement for California residents explains Pearson's commitment to comply with California law and applies to personal information of California residents collected in connection with this site and the Services.

Sharing and Disclosure

Pearson may disclose personal information, as follows:

As required by law.
With the consent of the individual (or their parent, if the individual is a minor)
In response to a subpoena, court order or legal process, to the extent permitted or required by law
To protect the security and safety of individuals, data, assets and systems, consistent with applicable law
In connection the sale, joint venture or other transfer of some or all of its company or assets, subject to the provisions of this Privacy Notice
To investigate or address actual or suspected fraud or other illegal activities
To exercise its legal rights, including enforcement of the Terms of Use for this site or another contract
To affiliated Pearson companies and other companies and organizations who perform work for Pearson and are obligated to protect the privacy of personal information consistent with this Privacy Notice
To a school, organization, company or government agency, where Pearson collects or processes the personal information in a school setting or on behalf of such organization, company or government agency.

Links

This web site contains links to other sites. Please be aware that we are not responsible for the privacy practices of such other sites. We encourage our users to be aware when they leave our site and to read the privacy statements of each and every web site that collects Personal Information. This privacy statement applies solely to information collected by this web site.

Requests and Contact

Please contact us about this Privacy Notice or if you have any requests or questions relating to the privacy of your personal information.

Changes to this Privacy Notice

We may revise this Privacy Notice through an updated posting. We will identify the effective date of the revision in the posting. Often, updates are made to provide greater clarity or to comply with changes in regulatory requirements. If the updates involve material changes to the collection, protection, use or disclosure of Personal Information, Pearson will provide notice of the change through a conspicuous notice on this site or other appropriate way. Continued use of the site after the effective date of a posted revision evidences acceptance. Please contact us if you have questions or concerns about the Privacy Notice or any objection to any revisions.

Last Update: November 17, 2020

Email Address