Exam 5: Generating Reports From Multiple Worksheets and Workbooks

To change the _____ displayed in a query datasheet,you modify the field's Caption property in Query Design view.

An aggregate function is _____.

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?

Which of the following describes the Caption property? Select all the options that apply.

Use a Long Text field when you need to store more than 256 characters in a field,such as for comments,reviews,or notes.

To create a single-value lookup field in Table Design view,you use the _____ in the Field Properties pane.

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

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

To set a validation rule in the Employees table specifying that the DateHired field value must be greater than the DateBorn field value,you set the Validation Rule property for the _____.

Which of the following are options you can select in the Top Values list for a query? Select all the options that apply.

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

Create a Top Values query to find the highest values in set of unsorted records.

How can you display "Product Description" in a table datasheet for a field named "ProdDesc" without renaming the field?

If the Quantity field has "< 50" as its validation rule,and a user tries to enter "100" in the field,Access displays the message in the _____ property.

To set the properties for an entire table,open the table's property sheet in Table Design view.

Which of the following could you use as a criterion in a Number field? Select all the options that apply.

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

To display the contents of a text box in more than one font size or color,set the _____ property of the text box to RTF.

The Recordset Type property determines whether Access locks or allows updates to records displayed by a query.

You can freeze one or more fields in a datasheet so they remain visible at all times.