Microsoft Office Tutorials and References
In Depth Information
Session 2.2
you to delete the ReferredBy field. Next, she wants the Openings field moved to the end of
the table. She also wants you to add a new yes/no field, named Experience, to the table to
indicate whether the available position requires that potential recruits have prior experience
in that type of work. The Experience field will be inserted between the HoursPerWeek and
StartDate fields. Finally, she thinks that the Wage field should remain a currency field, but
she wants the dollar signs removed from the displayed field values in the datasheet so the
values are easier to read. Figure 2-20 shows Elsa’s modified design for the Position table.
Modified design for the Position table
Figure 2-20
Field Name
Data Type
Field Size
Caption
Description
PositionID
PositionTitle
EmployerID
Wage
HoursPerWeek
Experience
StartDate
EndDate
Openings
Text
Text
Text
Currency
Number
Yes/No
Date/Time
Date/Time
Number
4
30
5
Position ID
Position Title
Employer ID
Primary key
Foreign key
Rate per hour
Work hours per week
Experience required
Month/day/year
Month/day/year
Number of openings
Integer
Hours/Week
Start Date
End Date
Integer
You’ll begin modifying the table by deleting the ReferredBy field.
Deleting a Field
After you’ve defined a table structure and added records to the table, you can delete a
field from the table structure. When you delete a field, you also delete all the values for
the field from the table. Therefore, before you delete a field you should make sure that
you want to do so—and that you choose the correct field to delete.
Deleting a Field from a Table Structure
Reference Window
In the Table window in Design view, right-click the row selector for the field you want to
delete, both to select the field and to display the shortcut menu.
Click Delete Rows on the shortcut menu.
You need to delete the ReferredBy field from the Position table structure.
To delete the ReferredBy field:
1. Click the View button for Design view on the Table Datasheet toolbar. The Table win-
dow for the Position table opens in Design view.
2. Position the pointer on the row selector for the ReferredBy field until the pointer changes to
a
shape.
3. Right-click to select the entire row for the ReferredBy field and display the shortcut menu,
and then click Delete Rows .
A dialog box opens asking you to confirm the deletion.
 
Search JabSto ::




Custom Search