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 48 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
Wow, this really help


patma1981

  • Member
  • Posts: 292
Reply 3 on: Yesterday
Thanks for the timely response, appreciate it

 

Did you know?

A recent study has found that following a diet rich in berries may slow down the aging process of the brain. This diet apparently helps to keep dopamine levels much higher than are seen in normal individuals who do not eat berries as a regular part of their diet as they enter their later years.

Did you know?

Thyroid conditions cause a higher risk of fibromyalgia and chronic fatigue syndrome.

Did you know?

During pregnancy, a woman is more likely to experience bleeding gums and nosebleeds caused by hormonal changes that increase blood flow to the mouth and nose.

Did you know?

People who have myopia, or nearsightedness, are not able to see objects at a distance but only up close. It occurs when the cornea is either curved too steeply, the eye is too long, or both. This condition is progressive and worsens with time. More than 100 million people in the United States are nearsighted, but only 20% of those are born with the condition. Diet, eye exercise, drug therapy, and corrective lenses can all help manage nearsightedness.

Did you know?

Eating food that has been cooked with poppy seeds may cause you to fail a drug screening test, because the seeds contain enough opiate alkaloids to register as a positive.

For a complete list of videos, visit our video library