Page 93 - iPlus_Ver_2.0_class_7
P. 93

•  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 as ID and assigns it as a Primary Key. The default Data Type
                 for the Primary Key field is AutoNumber. Enter the names of the fields and assign suitable data types.
                 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 rules 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:






                         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.





                                                                                                                  91
                                                                            Database and DBMS—An Introduction
   88   89   90   91   92   93   94   95   96   97   98