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
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
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
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.
Introducing Other Access Objects
The table is just one type of object found in Access. You can also work with forms, queries, and
In essence, each of these different database objects allows you a different way of viewing and manipulating the data found in your tables. Each of these objects (including the table) should also be