Microsoft Office Tutorials and References
In Depth Information
Session 2.1
3. Press the F6 key to move to the Field Properties pane. The current entry for the Field Size
property, 50, is highlighted.
4. Type 30 to set the Field Size property.
Finally, you need to set the Caption property for the field. In addition to clicking to position
the insertion point in a property’s box, you can press the Tab key to move from one prop-
erty to the next.
5. Press the Tab key three times to move to the Caption property, and then type Position
Title . You have completed the definition of the second field.
The third field in the Position table is the EmployerID field. Recall that this field will
serve as the foreign key in the Position table, allowing you to relate data from the Position
table to data in the Employer table. The field must be defined in the same way in both
tables—that is, a text field with a field size of 5.
To define the EmployerID field:
1. Place the insertion point in the third row’s Field Name text box, type EmployerID in the
text box, and then press the Tab key to advance to the Data Type text box.
2. Press the Tab key to accept Text as the field’s data type and to advance to the Description
text box.
3. Type Foreign key in the Description text box.
4. Press the F6 key to move to the Field Properties pane. The current entry for the Field Size
property, 50, is highlighted.
5. Type 5 to set the Field Size property.
6. Press the Tab key three times to move to the Caption property, and then type Employer ID .
You have completed the definition of the third field. See Figure 2-10.
Figure 2-10
Table window after defining the first three fields
current field
property values
set for the
current field
The fourth field is the Wage field, which will display values in the currency format.
 
Search JabSto ::




Custom Search