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
   21   22   23   24   25   26   27   28   29   30   31