Written by Ravi Prakash
|
|
Friday, 22 June 2007
Category MS Access 2007 - Data.
|
| |
| General Information |
| |
 |
| |
Datasheet
Changing records
Adding records
Deleting records
Sorting records
Filtering records
|
| |
|
| |
| Datasheet |
| |
|
A datasheet is the visual representation of the information contained in a database table, or of the results returned by a query. When you add or remove a
column from a datasheet, you add or remove a field from the table that underlies the datasheet. If that field contains data, you also eliminate that
information. |
| |
|
You can use the datasheet view to add, change, delete, sort or filter records from a database table. |
| |
|
In this tutorial, you will work with the TutorialSource database. |
| |
| |
| Changing records |
| |
| 1) Open TutorialSource database. |
| |
|
| Illustration 1: Tables that belongs to the Tutorial Source Database. Click here to view larger image. |
| |
| 2) Double click on Areas table to open the datasheet view. |
| |
|
| Illustration 2: Areas table at datasheet view. Click here to view larger image. |
| |
| 3) Select the first record and change the AreaId field content. Change the value 2 by 8. |
| |
| 4) Press the Tab key to jump to the Area field. |
| |
| 5) Modify the value with "Engineering". |
| |
| 6) Press Tab key to jump to the next record. |
| |
|
| Illustration 3: The first record data and record Id are updated. |
| |
| 7) At second record, change the actual value in AreaId field. Place a 9. |
| |
| 8) Press the Tab key to move to the next field. Change it by "Quality Assurance". |
| |
| 9) Press the Tab key to move to the next record. |
| |
| 10) Close the datasheet view. A window asking for save changes will appear. Press the YES button. |
| |
|
| Illustration 4: You must save the changes. Click here to view larger image. |
| |
|
