Free E-Books

Inserting a new field
To insert a new field, in the Table Design window, place your cursor on an existing field and
choose Insert ??? Rows or click the Insert Rows button in the toolbar. A new row is added to the
table, and existing fields are pushed down. You can then enter a new field definition. Inserting a
field does not disturb other fields or existing data. If you have queries, forms, or reports that use
the table, you may need to add the field to those objects as well.
NEW FEATURE NEW FEATURE
52
Access Building Blocks Part I
Deleting a field
There are three ways to delete a field. While the table is in Design View:
n Select the field by clicking the row selector and pressing the Delete key.
n Right-click on the selected field and choose Delete Rows from the shortcut menu.
n Select the field and click the Delete Rows button from the Tools group on the ribbon??™s
Design tab.
When you delete a field containing data, you??™ll see a warning that you will lose data in the table for
the selected field.


Pages:
242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266