| |
| |
How to use Database System. |
| |
| Important |
| |
| Press F7 to execute the script in Single Step mode as soon as it is loaded |
| |
| The script demonstrates the data manipulation in an MS-ACCESS 2000 database named DB2000.MDB. It includes methods for: Adding, Editing, Searching and Deleting records. |
| |
DB2000.MDB contains a table viz., EMPLOYEE with the following fields. |
| |
Field Name |
Data Type |
EmpID |
AutoNumber |
EmpName |
Text |
Address |
Memo |
|
|
| |
| A break point is inserted at the beginning of the script, so that you can single step through the code. |
| |
| Insertion is the first database operation executed by the script. A record having values 'George' and 'White House' as EmpName and Address respectively, is inserted into the table. |
| |
| Later, the script retrieves the record having EmpName='George' with the help of Select query and displays the Address. The data is then edited using the Update query replacing the EmpName 'George' with 'Alexander' and the Delete query removes the record from the table. |
| |
| |
| |
| |