Page 105 - Viva ICSE Computer Studies 7 : E-book

Editing Table in Access

Sometimes, you may need to modify the structure Think and Discuss
of your table. Table can be edited in both Datasheet If you were a computer professional,
and Design views. how would you prefer to create a table?

Adding a Field in Datasheet View
Follow these steps to add a fi eld in Datasheet view.
1. Open a table in the ‘Datasheet’
view.
2. Select the fi eld to the left of
Step 2
which you wish to add a new
fi eld. Right-click on the drop-

Step 3 down arrow of the fi eld.
Step 1 3. Select the Insert Field option
from the menu that appears.

4. A new fi eld named ‘Field1’ will
be added to the left of the
selected fi eld.

Step 4

Step 3
Adding a Field in Design
View

Follow these steps to add a
fi eld in Design view.

1. Open the table in the
‘Design’ view.
Step 2 2. Select the fi eld above
which you wish to add
a new fi eld.
Step 1
3. Select the Insert Rows
option from the ‘Tools’
group on the ‘Design’
tab.

93