Page 92 - Trackpad_ipro 4.1_Class7
P. 92

6  Enter the name for
                          your table in the Table
                                                                                                  7  Click on the
                          Name: text box.
                                                                                                 OK button.


                  This will open a blank table in the Design view. The table is divided into three columns:
                      Field Name: It is used  to enter the name of the field to be displayed as a column heading

                     in the table.
                     Data Type: It is used  to define the type of
                     data  that  can  be  entered  in  that  field.  The
                     commonly used data types in Access are Text,
                     Number,  Date/Time,  Currency,  AutoNumber,
                     Yes/No, etc.

                     Description: It is used to give additional comments or information to the user while entering
                     data. The entry in this field is optional.
                  By default, Access names the first field ID and sets it as the Primary Key with the AutoNumber
                  data type, which means Access will automatically create a unique number for each record.
                  To move between columns and insert new fields at the end, press the Tab key.

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

                  To do so, follow the given steps:

                                                                                             2  Set the properties.


                         1  Click on the
                        field name for
                        which you want to
                        set the properties.


                  Adding a Record


                  To do so, follow the given steps:





                                                                                                        2  Click on the
                                                                                                       field to add the
                                                                                                       new record.
                           1  Double-click to open
                          table in Datasheet view.






                    90     iPro (Ver. 4.1)-VII
   87   88   89   90   91   92   93   94   95   96   97