VB6 beginners tutorial - Learn VB6

Advanced VB6 tutorial - Learn Advanced VB6

Systems Analysis - System analysis and Design tutorial for Software Engineering

Browse Topics

- Getting started
- Data Types
- Modules
- Operators in VB6
- VB6 Variable
- VB6 Procedures
- VB6 Control Structures
- Loops in VB6
- VB6 Exit Do & With End With
- Arrays in VB6
- User-Defined Data Types
- VB6 Constants
VB6 Built-in Functions
- Date and Time in VB6
- VB6 Controls
- TextBox Control
- ComboBox & OptionButton
- Label & Frame
- PictureBox & ImageBox
- Timer Control
- ListBox & ComboBox
- VB6 ScrollBar
- Control Arrays in VB6
- Files controls in VB6
- VB6 CheckBox
- Forms in VB6
- Menus in VB6
- MDI Form in VB6
- InputBox
- MessageBox
- Mouse events
- Mouse Move
- Error Handling
Error Handling (2)
VB6 Database

You are here: Visual Basic > VB6 (Beginners Tutorial)

Tutorial Main Page | Previous Page | Contents | Next Page

Visual Basic 6 (VB6) - Database Access Management

All business applications need to store large volumes of data organized in a format so that information can be retrieved efficiently and quickly as and when required. With the help of a DBMS (Database Management System), managing the data becomes easy. A DBMS is a system that manages the storage and retrieval of data in a database.

Further Microsoft Visual Basic provides tools for creating and accessing a variety of RDBMS (Relational Database Management System). An RDBMS stores and retrieves information according to the relationship defined. In a RDBMS, the data is the container of the tables in which all data is stored in the relationships is formed by data values.

A database is a collection of data that is related one to another to support a common application. For example Employee details - Name, Address, etc. Each of these collections of data continue a database.

database accessing methods are as follows;

  1. Jet Engine - Accessing Microsoft Access and Visual Basic databases.

  2. ODBC (Open Database Connectivity) - Allow access to the client server databases on a network.

  3. ISAM (Index Sequential Access Method) - Used to access flat databases such as dBase, FoxPro, ParaDox.

Click here for more in-depth lessons on ADO and OLEDB

If you need some databases for your website, I recommend you to take a look at databases. They have hundreds of useful databases at very reasonable prices.


Database Structure and Terminology

ADO Data Control (ADODC)

Data Links

Assigning Tables

Bound Data Tools
Example - Accessing the Books Database

Creating a Virtual Table

Finding Specific Records
Example - Rolodex’ Searching of the Books Database

Data Manager
Example - Phone Directory - Creating the Database

Database Management
Example - Phone Directory - Managing the Database

Custom Data Aware Controls

Creating a Data Report
Exercise - Home Inventory Database


Tutorial Main Page | Previous Page | Contents | Next Page


Home | About Us | Privacy Policy | Contact Us

Copyright © | All Rights Reserved