6. Microsoft Access

6.1. Database for dummies

The database typically contains an aggregation of data records such as a list of sale transactions, product catalog, customer profiles collection, etc.

The database is much like a telephone book; it is a list of records of the same structure: phone owner’s name, address of telephone owner, telephone number of telephone owner.

A price list is a set of records similarly structured: order number, item name, price, quantity, item type.

Summary: a database is a large computer collection of structured data; it can be quickly expanded, updated, and retrieved for various purposes. Readme: the structure of each record is of the same type and is captured by a head of the table (that is, the list of column names).

Definition: a database is a structured collection of corresponding data related to a specific subject area.