Page 35 - ModularV1.1 _c8_flipbook
P. 35

Tech


                    Funda
                                   You  can also rename  a column by right-clicking on it and  selecting the
                                   Rename option.


                 Setting a Column 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. Follow these steps to set the properties of a column:

                 Step 1  Open the table in the Design view.
                 Step 2 Click on the field name for which
                         you want to set the properties.

                         All the properties related to the
                         column will appear in the Field
                         Properties pane.

                 Step 3  Set the properties according  to
                         your requirement. In this case, we
                         have set the Field Size property
                         of the Employee Name column
                         to 50. Now, this column accepts
                         maximum  of  50  characters as
                         value.                                               Setting Column Properties

                     HANDLING RECORDS IN A TABLE

                 MS Access facilitates you to add, delete, edit and sort records in a table. Let us learn about these
                 in detail.
                 Adding a Record


                 To add a record, follow these steps:
                 Step 1  Open the required table in Datasheet view.

                 Step 2  Place the pointer where you want to add the new record.













                                    Selecting table                           Adding record





                                                                                 Working with Tables in MS Access  33
   30   31   32   33   34   35   36   37   38   39   40