Manipulating the Database

 

 

1.                  Proofreading the entered data is important. Common errors are spelling mistakes, leaving out a record and saving an empty record. Data validation techniques can be used to correct data entry. Remember GIGO garbage in garbage out.

 

 

2.                  Selecting records involves physically choosing records on display as well as querying the database. A computer language that gives us a way of selecting records is called a query language. Structured Query Language (SQL) allows you to use

 

·        Wild cards

·        Relational operators

·        Logical operators

 

 

3.                  Amending, inserting and deleting records

 

 

4.                  Copying data from one record to another

 

 

Sorting records