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

Step 6:   lick on the  Finish  button.   newly created table opens in which the user can enter records.
              Sneak Peek




                    To Create Table in Design View in Microsoft Access:

                    1.  Click on Create tab.
                    2.  Click on Table Design command.
                     .   ype a name for the field in the Field Name column.

                     .  Select the type of data to be entered in the field from the drop down list box of  ata  ype
                       column.
                    5.  Mention the details of the field in the  escription column.
                     .   osition the mouse pointer on the field which is to be set as primary key  right click the
                       mouse button and select the option Primary Key.
                     .   ress  trl   S keys to save the table.  Save  s  dialog box appears on the screen.
                    8.  Type the table name and click on OK button.





            Step 7:   fter adding re uired records in the table  click on the  Save  icon from the standard toolbar to save
                    the records.
            Step 8:   o close the table  click on the   lose  button from the   itle bar .  he button of table with the name
                    is shown in the Table Pane.



































               CREATE TABLE BY USING CREATE VIEW

             his option is used to create a table by specifying the field s name   properties and data type.  he user can
            copy selected fields from specific table and create a new table with a combination of fields from different
            tables.  o do so:


                                                                                  Database Management          253
   250   251   252   253   254   255   256   257   258   259   260