Datasheet

Figure 1-2 Opening the table in Datasheet view allows you to view and edit
the data stored in the table.
TIP The number of records in a table is visible at the bottom left of the
Datasheet view, next to the record selectors.
Opening a table in Design view
Through the Design view of a table, you are able to set the field names and
data types. To get to the Design view of the CustomerMaster table, right-click
the CustomerMaster table and select Design View. As you can see in Figure
1-3, the Design view shows you the fields that comprise the CustomerMaster
table in an easy-to-manage view. Note how each field has a field name and a
data type. Data types are discussed later in this chapter.
The field name is the descriptive text string given to a particular column of a
table. It is what appears at the top of the table when it is in the Datasheet view.
Follow these guidelines when naming your fields:
■■
The maximum length of a field name is 64 characters.
■■
Your field name cannot include a period (.), an exclamation point (!), an
accent grave (`), or brackets ([ ]).
■■
You can begin your field name with leading spaces.
TIP It is good practice not to put any spaces in your field names. When
constructing queries or referring to tables in VBA code, spaces in the field
names can lead to problems. If you need to indicate a space in your field name,
use the underscore character.
Access Basics 5
05_59978X ch01.qxp 12/1/05 7:46 PM Page 5