Author Question: Give a business example of how you could use each of the four action queries. What will be an ... (Read 39 times)

scienceeasy · **on:** Aug 28, 2018

Give a business example of how you could use each of the four action queries.

What will be an ideal response?

Question 2

By default the Action Catalog and Add New Action combo box only show actions that execute in nontrusted databases. To see all actions, click Show All Actions in the ________ on the Design tab.

A) Tools group
B) Show/Hide group
C) Views group
D) Field, Record & Table Events group

nickk12214 · **Reply #1 on:** Aug 28, 2018

Answer to Question 1

Student answers will vary. Some examples include:
Database may have initially been built to track customers and the orders they placed. Now you may want also to track marketing efforts and the quantity of customers who use coupons that were mailed or emailed to them. You would need to create a new table to track who redeemed coupons and when they were redeemed.
The Painted Paradise Resort and Spa's marketing department regularly updates their database with new marketing campaigns, customers, and redemption status of discounts. If the spa manager wants to ensure he has current data for decision making, he needs to regularly add new records to the table that is storing the marketing data in the Spa database. An Append query could help the spa's manager easily and regularly add new records to the existing table.
Perhaps an employee no longer works at the salon and there are dozens of future appointments that need to be changed to a different employee's name. If the same employee (perhaps the person you hired to fill that employee's position) is now going to handle these appointments, you could create an update query that changes the name of the employee for all future appointments from the employee who left to the new employee.
The spa manager may want to remove all coupons that were not redeemed and have now expired. This will keep the database cleansed, meaning that the Delete query will remove data that isn't useful or needed anymore.

Answer to Question 2

B