Office® XP Development with VBA

Chapter Seven. Using Data Access Components

The term data is often used in a generic sense to refer to almost any kind of information. In some contexts, however, it has a more specific meaning and refers to data maintained by database programs. Access is the component of Office designed to work with databases. A database is a specific format for maintaining data that uses a record and field format. Each individual entry in a database table is a record, and each piece of information contained in a record is a field. In a mailing list database, for example, each person's entry is a record, and each piece of information—name, address, city, and so on—is a field. Sometimes you will hear records referred to as rows, and fields as columns. Vast amounts ...