Page 94 - TP_iPlus_V2.1_Class7
P. 94

•  Data Type: 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: 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 in
                         which you want to
                         set the properties.

                  Adding a Record


                  To do so, follow the given steps:






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



                  Editing a Record

                  To do so, follow the given steps:






                           1  Double-click                                                  2  Double-click
                          to open table in                                                  on the record that
                          Datasheet view.                                                   you want to edit.





                    92
                         iPlus (Ver. 2.1)-VII
   89   90   91   92   93   94   95   96   97   98   99