This topic contains a solution. Click here to go to the answer

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

scienceeasy

  • Hero Member
  • *****
  • Posts: 565
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



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

nickk12214

  • Sr. Member
  • ****
  • Posts: 332
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




scienceeasy

  • Member
  • Posts: 565
Reply 2 on: Aug 28, 2018
Great answer, keep it coming :)


chjcharjto14

  • Member
  • Posts: 342
Reply 3 on: Yesterday
:D TYSM

 

Did you know?

Urine turns bright yellow if larger than normal amounts of certain substances are consumed; one of these substances is asparagus.

Did you know?

Ether was used widely for surgeries but became less popular because of its flammability and its tendency to cause vomiting. In England, it was quickly replaced by chloroform, but this agent caused many deaths and lost popularity.

Did you know?

The average human gut is home to perhaps 500 to 1,000 different species of bacteria.

Did you know?

Though methadone is often used to treat dependency on other opioids, the drug itself can be abused. Crushing or snorting methadone can achieve the opiate "rush" desired by addicts. Improper use such as these can lead to a dangerous dependency on methadone. This drug now accounts for nearly one-third of opioid-related deaths.

Did you know?

More than one-third of adult Americans are obese. Diseases that kill the largest number of people annually, such as heart disease, cancer, diabetes, stroke, and hypertension, can be attributed to diet.

For a complete list of videos, visit our video library