1. The Insert Into 

    1. Insert Data Only in Specified Column or all Columns

    2. Insert Data Using Designer Tools

  2. The Update

    1. Update Data in Specified Column or all Columns

    2. Update Data Using Designer Tools

  3. The Delete

    1. Delete a Specific or all Rows

    2. Delete Data Using Designer Tools

  4. The Select

    1. Select a Specific or All Records

    2. Select Data Using Designer Tools

    3. The Order by Keyword

    4. Select Distinct

    5. Where Clause

    6. Select with Operator’s Conditions 

      1. Like Operator

      2. In Operator

      3. Between Operator

  5. Wildcards

    1. AND & OR operators

    2. Select Top Clause

  6. Summary

Material File