Exam 3: Performing Calculations With Formulas and Functions

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

To add,delete,or change fields in a query,you use Query Design view.

Which of the following statements describe Query Design view? Select all the options that apply.

What are you doing when you enter data into a subdatasheet?

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

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

What criterion would you use to find numbers greater than or equal to 100?

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

What happens when you run a query from Query Design view?

After you hide a field in a datasheet,you can redisplay the hidden field using a shortcut menu.

Which of the following are examples of correct criteria syntax? Select all the options that apply.

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

Use Query Design view to display the results of a query.

A _____ is a saved object within the database,whereas a _____ is temporary.

To add a field list to the upper pane in Query Design view,drag a table from the Navigation Pane.

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?

Which of the following statements are true about subdatasheets? 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.

To delete a field from a query,drag the field out of its field list.

Which of the following are ways to run a query? Select all the options that apply.