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 47 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 :)


rleezy04

  • Member
  • Posts: 322
Reply 3 on: Yesterday
Gracias!

 

Did you know?

Although puberty usually occurs in the early teenage years, the world's youngest parents were two Chinese children who had their first baby when they were 8 and 9 years of age.

Did you know?

When Gabriel Fahrenheit invented the first mercury thermometer, he called "zero degrees" the lowest temperature he was able to attain with a mixture of ice and salt. For the upper point of his scale, he used 96°, which he measured as normal human body temperature (we know it to be 98.6° today because of more accurate thermometers).

Did you know?

Hippocrates noted that blood separates into four differently colored liquids when removed from the body and examined: a pure red liquid mixed with white liquid material with a yellow-colored froth at the top and a black substance that settles underneath; he named these the four humors (for blood, phlegm, yellow bile, and black bile).

Did you know?

When blood is deoxygenated and flowing back to the heart through the veins, it is dark reddish-blue in color. Blood in the arteries that is oxygenated and flowing out to the body is bright red. Whereas arterial blood comes out in spurts, venous blood flows.

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.

For a complete list of videos, visit our video library