Question

In Design view of the Employee Commissions_1st Qtr_Formatted query, format the Commission calculated field as Currency with two decimal places, and add a caption of 1st Qtr Commission (no period). Press ENTER.

Answer 1

To format the Commission calculated field as Currency with two decimal places and add the caption '1st Qtr Commission', one must adjust the field's format and caption properties in the Design view of the database query.

Step-by-step explanation:

The question pertains to formatting a calculated field named Commission in a database query using Design view. In many database systems, formatting a field as Currency with two decimal places involves selecting the Commission field in the query design grid and modifying its formatting settings to reflect the currency format. Additionally, adding a caption such as '1st Qtr Commission' requires specifying the caption in the properties area or similar section in the design view where field properties can be set.

To apply these changes, you would generally locate the format property of the Commission field and select or enter the currency format, which typically includes options for symbol placement, decimal places (in this case, specifying two decimal places), and whether to include a thousands separator. To change the caption, you would look for the caption property in the properties area and enter 1st Qtr Commission (making sure there is no period at the end as specified).