Page 43 - TP_Prime_V2.2_Class8
P. 43

To create table in Design view, follow these steps:

                 Step 1:  Click  on  Table Design  command  from  Tables  group
                           under Create tab. This will create a new table as Table1
                           in the database.
                           This will open a blank table in the Design view. The table
                           is divided into three columns:                                        Creating a Table

                           •     Field  Name:  This  column  is  used  to  enter  the  name  of  the  field  to  be
                              displayed as column heading in the table.                                                     WORKING WITH ACCESS 2016
                           •     Data Type: This column is used to define the type of data that can be entered

                              in that field. The commonly used data types in Access are Short Text, Number,
                              Date/Time, Currency, AutoNumber, Yes/No, etc.
                           •     Description: This column is used to give additional comments or information to
                              the user while entering data. The entry in this field is optional.

                 Step 2:  Enter the names of the fields and assign suitable data types.
                                                                                                                          41
                 Step 3:  Assign the primary key to the Roll No field.




















                                     Design View                                       Entering Field Names

                 To move between columns and insert new fields at the end, press the Tab key.

                 Setting Field Properties

                 The detailed properties of each field can be defined in the
                 Field Properties pane according to the rules for writing a field
                 name discussed earlier.

                 Perform the following steps to set field properties:

                 Step 1:  Click on the field name for which you want to set the
                           properties.
                 Step 2:  Specify  the  required  properties in the  Field
                           Properties pane.                                                Setting Field Properties

                 Step 3:  Similarly, you can set the properties for the other fields.
   38   39   40   41   42   43   44   45   46   47   48