Page 91 - Trackpad_ipro 4.1_Class7
P. 91

NAMING CONVENTIONS FOR WRITING A FIELD NAME

                 You should remember the following naming conventions 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 (").

                     CREATING A TABLE

                 Tables can be created in two ways:
                    Creating tables using Design View
                    Creating tables using Datasheet View

                 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:

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
















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





                                                                           Database and DBMS—An Introduction     89
   86   87   88   89   90   91   92   93   94   95   96