Microsoft Office Tutorials and References
In Depth Information
Defining Fields
Figure 2-10
Table window after entering the fi rst fi eld name
field name entered
default data type
click to dis play a
list of data types
pressing the F1 key
displays Help information
properties for a
Tex t f field
def ault pr operty
values for a Text field
Because the InvoiceNum field values will not be used in calculations, you will
accept the default Text data type for the field.
2. Press the Tab key to accept Text as the data type and to advance to the
Description box.
Next you’ll enter the Description property value as “Primary key.” The value you
enter for the Description property will appear on the status bar when you view the
table datasheet. Note that specifying “Primary key” for the Description property
does not establish the current field as the primary key; you use a button on the
Ribbon to specify the primary key in Design view, which you will do later in this
session.
3. Type Primary key in the Description box.
Notice the Field Size property for the field. The default setting of 255 for Text
fields is displayed. You need to change this number to 4 because all invoice
numbers at Belmont Landscapes contain only four digits.
4. Double-click the number 255 in the Field Size property box to select it, and then
type . 4
Finally, you need to set the Caption property for the field so that its name appears
with a space, as “Invoice Num.”
Search JabSto ::




Custom Search