Page 26 - ModularV1.1 _c8_flipbook
P. 26
Field grid pane
Field Properties pane
Design view
ADDING FIELDS TO A TABLE
When a new database is created, a table named Table 1 is opened with a field named ID. By
default, the table is opened in Datasheet view. Follow these steps to add more fields into the
table in the Datasheet view:
Step 1 Click on the down-arrow of the Click to Add column
header. A drop-down list appears.
Step 2 Select the type of field you want to add. In this case, we
have selected the Number field. A number field named
Field 1 gets added in the table. The name of the added
field appears as editable.
Step 3 Type the new name and press the Enter key. In this case,
we have typed Class.
Follow these steps to add fields using Design view: Adding a field
Step 1 Click on the View command form the Views group of the Home tab.
Step 2 Select the Design view option. The Save As dialog box
appears if your table is not saved. Type the name of the
table or click on the OK button. The table opens in the
Design view with three columns named Field Name,
Data Type and Description.
Step 3 Type the field name under the Field Name and select
the desired data type under the Data Type column. You
can also give description of the field in the Description
Selecting data type
column.
24 Modular (Ver. 1.1)-VIII

