Page 251 - IT 402 v2.0 class 10
P. 251

N ot e s


                      In MS- ccess  the third option to create a table is   reate tab
                      In MS- ccess  the third option to create a table is   reate table by entering data.... .
                      In MS- ccess  the third option to create a table is   reate tab
                                                                           le by entering data.... .
                                                                           le by entering data.... .
            Create Table In Design View

             his option enables to create a table in design view in which the user has to define table structure  field name
            and field type  and the table name.  o create table in design view:
            Step 1:   lick on   reate  able in  esign  iew .   window opens which contains three columns:

                       Field Name                         Field Type                      Description

            Step 2:   ype a name for the field in the  Field Name  column.
            Step 3:  Select the field type from the drop down list box of  Field  ype  column.





                            2                                                                          3


                                                         Field Type List









                         Field
                       Properties



            Step 4:  Mention the details of the field in the   escription  column.   he description field is optional though
                    it is a good practice to give field description so that any person other than the programmer can
                    understand the purpose of the field .











                                                                           Field Description
                      Field Name













                                             Field Type



                                                                                  Database Management          249
   246   247   248   249   250   251   252   253   254   255   256