Understanding Access 2002
Strictly speaking, a database is any collection of information. Your local telephone book, for example, is a database, as is the shopping list that you take to the grocery store. Microsoft Access makes creating databases very straightforward and relatively simple.
The electronic container that Access provides for holding your data is called a table (see
Figure 1.1). A table consists of rows and columns . Access stores each database entry (for example, each employee or each inventory item) in its own row; this is a record. Each record contains specific information related to one person, place, or thing.
Figure 1.1. A table serves as the container for your database information.
Table A container for your database information consisting of columns and rows.
Each record is broken up into discrete pieces of information, called fields. Each field consists of a separate column in the table. Each field contains a different piece of information that taken all together makes up a particular record. For example, Last Name is a field. All the last names in the entire table (all in the same column) are collectively known as the Last Name field.
Record A row in a table that contains information about a particular person, place, or thing.
Field A discrete piece of information making up a record. Each column in the Access table is a different field.