Page 28 - Code & Click - 8

Creating a Table using Datasheet View
Consider the table titled Book with the following structure:

Field name BookNum Title Author Genre Publisher Price

Data type AutoNumber Short Text Short Text Short Text Short Text Number

To create the table Book in Datasheet view:
1. On the Create tab, click the Table button in the Tables group.

A new table with the field ID appears.

1

3 4

2. Double-click the field name ID and change it to BookNum. 2
3. Click the down arrow next to Click To Add field.
A drop-down list of data types appears.
4. Select Short Text.
Access adds a new field ‘Field1’ in the table. Click To Add field is
moved to the third column.

5. Rename Field1 as Title.
6. Repeat steps 3 to 5 to add remaining fields with the specified
names and data types.

7

7. Click the first cell under Title and type ‘The Fist of God’.
The value 1 appears in the BookNum field. A pencil icon appears in front of the row that
indicates that the record is being edited.
8. Press the Tab key to move to the next field.
9. Type the values under the fields Author, Genre, Publisher, and Price respectively.

9

10. Press the Tab key.
A new blank record is added to the table.

26