Exam 5: Generating Reports From Multiple Worksheets and Workbooks

To list values in a Number field in order from lowest to highest, you use the _____ button.

Set the Append Only property to _____ to allow users to add data to a Long Text field but not to change or remove existing data.

Fields that are good candidates for Lookup properties are those that contain a limited set of values such as State, Gender, or Department.

When you create a(n) _____ query, the value the user enters in the dialog box determines which records the query displays in the results.

To set the Validation Text property for a table in Table Design view, you use the _____.

In large datasheets, you can ____ certain fields so that they remain on the screen at all times.

In Query Design view, how can you add a field to the query design grid?

In Query Design view, you enter parameter criteria within curly brackets, as in {Enter department:}.

Which of the following are settings you specify in the Crosstab row of the query design grid when you create a crosstab query? Select all the options that apply.

To set a validation rule for an entire table, you _____.

To set the validation text for a table in Table Datasheet view, you use the _____ button on the Table Tools Fields tab.

In a SaleDate field, you can display dates as 03-Jan-21, for example, by selecting Medium Date as the _____ property.

You use the Find Unmatched Query Wizard to find records in one table that do not have related records in another table.

You can retain a history of changes to a _____ field.

If you used D*n as the criterion in a Short Text field called FirstName, what would appear in that field in the query results?

The only way to create a Crosstab query is to use the Crosstab Query Wizard.

The Crosstab Query Wizard asks you to select fields for the _____, column headings, and values.

Which of the following fields are good candidates for a single-value lookup field? Select all the options that apply.

The Input Mask property provides a pattern for data to be entered, such as for a phone number.

In Query Design view, use the COUNT aggregate function when you want to find the number of values in a field.