Monday 2 July 2012

DATA MANIPULATION

09:41    No comments

Data manipulation refers to the operations of accessing, locating, organising, modifying and managing data contained in the database.

Basic operations of data manipulation :
  1. Update
  2. Insert
  3. Delete
  4. Retrieve
  5. Sort
  6. Filter
  7. Search
UPDATING RECORDS
The Update operation is used for changing data in a database Table.

INSERTING RECORDS
The Insert operation is used for adding records to a database Table.

DELETING RECORDS
The Delete operation is used for removing records from a database Table.

RETRIEVING RECORDS
The Retrieve operation is used for retrieving records from a database Table.

SORTING RECORDS
The Sort operation is used for sorting records in a records in a database Table.

FILTERING RECORDS
The Filter operation is used for filtering records from a database table.
Instead of displaying all the records in a Table, you can use a filter to display only those records that you want to see or edit.

SEARCHING RECORDS
The Search operation is used for finding record from a database table.
You can use the Find function in Microsoft Access to search for the records. You can use the “Find” feature to locate one or more records to find specific data.

__________________________________________________________________________________
 Others Lesson : | click lesson to view |

0 comments:

Post a Comment