Designing Access Tables
Naming the “Cars” table’s field names in
the table’s “Design” view :
The table’s “Datasheet” view showing the actual
data in columns and rows :
All data is stored in tables, and only in
tables.
Note that each car is on a separate row,
and each property forms a column of data for each attribute
that describes each car.
For
example, the field “Color” can contain the actual color for each car in the
table.
This
is the data that is stored as compared to the name of the place it will be
stored (the field.)
(The
last, empty row is for a new car to be added to the table.)
Table Design View Showing Details:
The “Design”
view is where the programmer specifies what field names will be used,
and what kind of data will be used to store that data :
