FunctionX FunctionX Press ADO.NET XML.NET Visual Basic Microsoft Access C++ Builder

Other Tutorials

Fundamentals

Windows
Computer Networking

Databases

SQL
Oracle
VBA For MS Access

Computer Languages

C++
C#
Managed C++
VBasic
J#
Java
Object Pascal

Programming Environments

Visual Basic
Visual Basic .NET
Visual C++
Visual C++ .NET
C++ Builder
Visual C#
Visual J#
Delphi

Presentations

MS PowerPoint
StarImpress

Spreadsheets

MS Excel
StarCalc

Libraries

Win32
XML.NET

 

Microsoft ActiveX Data Objects, ADO, is a library used to create and manage computer databases for the Microsoft Windows family of operating systems. The library can be used to connect to various types of databases, including Microsoft Access, Paradox, Microsoft SQL Server, text files, Microsoft Excel, etc.

This web site features lessons, articles, and links on using ADO. The lessons on this site were created using Microsoft Visual Basic Express.

aaa
Lessons Summary

Introduction to ADO Database Tables
Database Creation Tables' Columns
ADO Fundamentals Database Records
Database Creation Data Entry Assistance
Introduction to Record Sets

A record set is the center of an ADO database. This is an introduction on how to create it using the RecordsetClass class of the ADODB namespace.

Introduction to SQL

The Structured Query Language (SQL) is the most universal language used by database environments. This is an introduction to its implementation in Microsoft JET.

Record Maintenance

This is review of editing or deleting records using the SQL. The operators or keywords include UPDATE and DELETE.

Record Navigation

Record navigation consists of moving among records of a recordset. Before doing this, you must create a recordset and specify the type of cursor you will use. When implementing the navigation, you must specify what Windows control would display the values of what column.

 

 

 

 

 

 

 

 

 

 

 
VBA For MS Access Copyright © 2004-2012 FunctionX, Inc.