Give the function of each of the following queries.
-Make table query
-Delete query
-Append query
-Update query;
Answer:
-Make table query: used for creating another table from existing table(s) or queries.
-Delete query: used to automatically delete a record or records from the source data.
-Append query: used to automatically add a record or records to an underlying table.
-Update query: used to automatically update record(s) in a table