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;
Jet Engine - Accessing Microsoft Access and Visual Basic
databases.
ODBC (Open Database Connectivity) - Allow access to the
client server databases on a network.
ISAM (Index Sequential Access Method) - Used to access
flat databases such as dBase, FoxPro, ParaDox.
