Exam 3: Performing Calculations With Formulas and Functions

Which of the following options are available as you filter a datasheet? Select all the options that apply.

How do you display the records in a subdatasheet?

You use a subdatasheet to modify a field's properties.

If you want to sort records in the query results first by City and then by LastName, where should you insert the LastName field in the query design grid?

To create a banded rows effect in a report, you _____.

Access adds @ signs around date criteria in Date/Time fields.

You can add fields to a form in Design view or _____.

A customer has moved to a new address in the same city. What Access feature can you use to quickly change the customer's address in a table datasheet that contains hundreds of records?

Which of the following statements describe a filter? Select all the options that apply.

In Query Design view, the query grid shows the names of the fields and tables involved in the query.

When working in Table Datasheet view, which button on the Table Tools Fields tab can you use to change the expression in a calculated field?

When you delete a column from a table in Table Datasheet view, you delete the field and all of its data.

How do you display the results of a query listed in the Navigation Pane?

You use the Field List to add fields to a form in Form Design view.

What data type is most appropriate for a field named PaymentAmt?

Which of the following are views you can use to display a query? Select all the options that apply.

What happens if you hide the Bonus column in the Employees table in Table Datasheet view?

What can you add to a query datasheet to display statistics for a group of records?

To delete a field from a query in Query Design view, click the _____ for the field, and then press DELETE.

To apply the last filter you selected to a datasheet, you click the _____ button.