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 42 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
YES! Correct, THANKS for helping me on my review


TheDev123

  • Member
  • Posts: 332
Reply 3 on: Yesterday
Excellent

 

Did you know?

Individuals are never “cured” of addictions. Instead, they learn how to manage their disease to lead healthy, balanced lives.

Did you know?

In 2006, a generic antinausea drug named ondansetron was approved. It is used to stop nausea and vomiting associated with surgery, chemotherapy, and radiation therapy.

Did you know?

More than nineteen million Americans carry the factor V gene that causes blood clots, pulmonary embolism, and heart disease.

Did you know?

Signs and symptoms that may signify an eye tumor include general blurred vision, bulging eye(s), double vision, a sensation of a foreign body in the eye(s), iris defects, limited ability to move the eyelid(s), limited ability to move the eye(s), pain or discomfort in or around the eyes or eyelids, red or pink eyes, white or cloud spots on the eye(s), colored spots on the eyelid(s), swelling around the eyes, swollen eyelid(s), and general vision loss.

Did you know?

All adverse reactions are commonly charted in red ink in the patient's record and usually are noted on the front of the chart. Failure to follow correct documentation procedures may result in malpractice lawsuits.

For a complete list of videos, visit our video library