Page 92 - iPlus_Ver_2.0_class_7
P. 92

i +   RULES FOR WRITING A FIELD NAME IN ACCESS

                  You should remember the following rules while writing field names:
                  •  Field name can be up to 64 characters long.
                  •  Field name can include any combination of letters, numbers, spaces, and special characters
                     except a period (.), an exclamation mark (!), an accent grave (') and brackets ([ ]).

                  •  Field name cannot begin with the leading spaces.
                  •  Field name cannot include a double quotation mark (").


                   i +   CREATING A TABLE
                  Tables can be created in three ways:

                  •  Creating tables using Design View

                  •  Creating tables using Datasheet View
                  •  Creating tables using Templates

                  Let us create a table using Design view.
                  Creating a Table Using Design View

                  In this view, you can define fields that are to be included in the table. You can simultaneously
                  define the properties of these fields. To create a table in Design view, follow the given steps:

                                                      4  Click on the View command.     3  Click on the Fields tab.

                       1  Click on the Create tab.
















                           2  Click on the Table
                          command.                              5  Select the Design View option.







                         6  Enter the name for
                         your table in the Table                                                  7  Click on the
                         Name text box.
                                                                                                  OK button.



                  This will open a blank table in the Design view. The table is divided into three columns:
                  •  Field Name: Used to enter the name of the field to be displayed as a column heading in the table.



                    90
                         iPlus (Ver. 2.0)-VII
   87   88   89   90   91   92   93   94   95   96   97