Page 29 - Code & Click - 8

11. Type the values for some more records as shown in the image.

11

12. Click the Save button on the Quick Access Toolbar.

The Save Table dialog box opens.
13

13. Type the name ‘Book Library’ in the Table Name
text box and click the OK button.
Access saves the table in the database. Its name
appears on the table tab as well in the Navigation
pane under Tables.
Modifying the Table Design
In the Datasheet view, you can add, delete, rename, move, hide, display, or change the data type of
a field.

Adding a New Field
You can add more fields to a table as desired.
To add a new field to a table:

1. In the Navigation Pane, double-click the table name in which you want to add a field.
The table gets opened in the Document window in the Datasheet view.

3
2

1

2. Click the column header of the field to the right of which you want to add a field.

3. On the Table Tools Table Fields tab, click the data type for the new field in the Add & Delete group.
Access adds a new field to the table. 4

4. Type a name for the inserted field.
Deleting a Field
You can delete fields from a table not required anymore.

27