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

