Cover image for SAMS teach yourself database programming with Visual Basic 6 in 21 days
Title:
SAMS teach yourself database programming with Visual Basic 6 in 21 days
Author:
Smith, Curtis.
Personal Author:
Publication Information:
Indianapolis, Ind. : Sams Publishing, [1998]

©1999
Physical Description:
xxi, 882 pages : illustrations ; 23 cm + 1 computer laser optical disc (4 3/4 in.)
General Note:
Includes index.
Language:
English
Title Subject:
Added Author:
ISBN:
9780672313080
Format :
Book

Available:*

Library
Call Number
Material Type
Home Location
Status
Central Library QA76.73.B3 S577 1999 Book and Software Set Central Closed Stacks
Searching...

On Order

Summary

Summary

PLEASE PROVIDE COURSE INFORMATIONPLEASE PROVIDE


Author Notes

Curtis Smith has been working in the computer industry for many years. Curtis has a financial background which helps to bring a practical real world flair to this book. Curtis currently hold both an MBA and a CPA. Michael Amundsen has more than ten years database programming experience - using dBase, Clipper, FoxPro, and Visual Basic. He has worked in large corporate IS shops, small accounting offices and an IS consulting firm He recently completed his Microsoft Certification in Visual Basic and Windows 3.1 and now holds Microsoft s MCP.


Table of Contents

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
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 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
CHARTING Project
Copying, Saving, and Printing Your Charts
Creating Your Data Chart DLL Component
Testing the
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
dbFind Custom Control
Using the Data Grid to Create a Subform
Summary
Quiz
Exercise
12 Creating Databases with SQL
Using the
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. A

Google Preview