Microsoft Office Tutorials and References
In Depth Information
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
Rate per hour
Work hours per week
Number of openings
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
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
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.