Access SQL - III

• The UPDATE Statement: Used to change values in one or more columns in a table.

Syntax: UPDATE table-or-query

SET column1=expression1[,column2=expression2][,..]

[WHERE criteria];

Example: UPDATE tblMenu SET tblMenu.Price = {Price]*1.1 WHERE MenuDescription Not Like "*Pizza";

• The DELETE Statement: Used to delete rows from tables.

  Syntax: DELETE [table.*]
  

FROM from-clause

[WHERE criteria];

Example: DELETE FROM tblMenu WHERE Discontinued = True;

• The INSERT INTO Statement: Used to copy rows from one table into another or to add a single row of data to a table using a list of values.

Syntax: INSERT INTO target-table

select-statement;

Example: INSERT INTO tblCustomer SELECT * FROM tblCustomerNew;

Previous slide

Next slide

Back to first slide

View graphic version