Page 93 - TP_iPlus_V2.1_Class7
P. 93

i +  CONVENTIONS FOR NAMING A FIELD

                 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 (").

                  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:


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






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







                                  6  Enter the name for
                                  your table in the Table
                                  Name text box.




                                                                         7  Click on the 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.



                                                                                                                  91
                                                                            Database and DBMS—An Introduction
   88   89   90   91   92   93   94   95   96   97   98