Page 36 - ModularV1.1 _c8_flipbook
P. 36

Editing a Record

                  To edit a record, follow these steps:
                  Step 1  Open the required table in Datasheet view.
                  Step 2  Double-click on the record that you want to edit.
                  Deleting a Record

                  To delete a record, follow these steps:

                  Step 1  Open the required table in Datasheet view.
                  Step 2  Select the record that you want to delete.
                  Step 3  Right-click and select the Delete Record option.                 Deleting a record




                     Recap


                           MS Access 2010 allows us to add maximum of 256 columns and unlimited rows in a
                          table.
                           MS Access 2010 allows us to add, delete, hide, unhide and rename a column in a
                          table.

                           MS Access facilitates us to add, delete and edit records in a table.




                                                         Exercise



                           ü
                  A.  Tick ( ) the correct option.
                     1.  Which of the following is one of the ways to create a table in MS Access?
                       a. Design view                       b. Form view                  c. Table view

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

                       a. Shift                             b. Ctrl                       c. Tab

                     3.  Which of the following options is used to unfreeze columns?
                       a. Unfreeze All Fields               b. Unfreeze Fields            c. Unfreeze

                     4.  In which view of the table can we add records?

                       a. Datasheet view                    b. Design view                c. Form view

                     5.  Which command is used to insert a text field/column in a table?
                       a. Number                            b. Currency                   c. Text


                  B.  Write ‘T’ for true and ‘F’ for false.
                     1.  We can add maximum of 256 columns in a table.                                   ............................

                     2.  We can create a table using built-in templates.                                 ............................


                  34      Modular (Ver. 1.1)-VIII
   31   32   33   34   35   36   37   38   39   40   41