List the four types of action queries and give an example of what each would do.
What will be an ideal response?
1. A Delete query would be created to remove products that are discontinued or for which there are no orders.
2. An Update query would be created to raise prices by 10% for all products.
3. An Append query would be created to merge new employee records into the existing Employees table for a company that you just acquired.
4. A Make Table query would be created to export records to another Access database in order to make a backup copy of a table.
You might also like to view...
Which of the following statements are TRUE regarding symmetric algorithms?
A. They are easy to break. B. They are slower than asymmetric algorithms. C. They include both stream-based and block ciphers. D. They provide confidentiality, authentication, and non-repudiation.
A Function procedure can pass many values back to the calling procedure.
Answer the following statement true (T) or false (F)