Question

Create a copy of the Revenue and Cost by Country query named Customer Payments. Switch to Design view of the new query and remove the Country, TotalCost, and OrderDate fields. Add the FirstName and LastName fields. Move the TotalRevenue field to the end. Rename the TotalRevenue field to OrderTotal. Change the caption to Order Total.

Answer 1

The task involves modifying a database query by removing specified fields, adding new fields, rearranging the order of fields, and renaming a field with an updated caption.

Step-by-step explanation:

The correct answer is to take specific actions in a database query design to meet the requirements given. Assuming you are using a database program like Microsoft Access, you would create a copy of an existing query called Revenue and Cost by Country and rename it to Customer Payments.

In the Design view, you'd remove Country, TotalCost, and OrderDate fields. Then you would add FirstName and LastName fields from the appropriate table in the query design. The TotalRevenue field would be moved to the end of the field list, and its name would be changed to OrderTotal with its caption set to Order Total.

The correct answer is option Computers and Technology.

The question is asking to create a copy of the Revenue and Cost by Country query named Customer Payments and make modifications to it. In the new query, we need to remove the Country, TotalCost, and OrderDate fields and add the FirstName and LastName fields.

The TotalRevenue field should be moved to the end and renamed to OrderTotal with a caption of Order Total.