Question 1

Match between columns
                        Premises: A field data type that allows text values to be entered up to 65,535 characters.

Accepted Answer

The Answer of SQL (Structured Query Language) and find unmatched is...

Question 2

When creating a find unmatched query using the query wizard, Matching fields will be joined automatically if a ____________________ is already defined between the two selected objects.

Accepted Answer

The answer of When creating a find unmatched query using...

Question 3

Match between columns
                        Premises: A standard query language used in querying, updating, and managing relational databases.

Accepted Answer

The Answer of lookup field and find unmatched query and is...

Question 4

Match between columns
                        Premises: A rule that is set when the validation involves multiple fields.

Accepted Answer

The Answer of list-of-values match and pattern match and lookup is...

Question 5

Match between columns
                        Premises: A select query that finds duplicate records in a table or query.

Accepted Answer

The Answer of property propagation and pattern match and Long is...

Question 6

The Top Values query property allows the user to limit the number of records in the query results by using a preset value, by entering an integer, or by selecting a(n)____________________.

Accepted Answer

The answer of The Top Values query property allows the...

Question 7

Match between columns
                        Premises: A field property option that verfies a field value by comparing the value entered to a constant or set of constants.

Accepted Answer

The Answer of find unmatched query and Validation Rule and is...

Question 8

Valid values that may be entered in a field are specified using the ____________________ propoerty.

Accepted Answer

The answer of Valid values that may be entered in...

Question 9

Match between columns
                        Premises: A field that allows the user to select a value from a list of possible values to enter data in the field.

Accepted Answer

The Answer of pattern match and find unmatched query and is...

Question 10

Table Validation Rules are entered using the ____________________ for a table.

Accepted Answer

The answer of Table Validation Rules are entered using the...

Question 11

Match between columns
                        Premises: Selects records for the designated field when the value matches one of two or more condition values.

Accepted Answer

The Answer of pattern match and table validation rule and is...

Question 12

Match between columns
                        Premises: The capability of a database to update field properties in objects automatically when a table field property is modified.

Accepted Answer

The Answer of find unmatched query and list-of-values match and is...

Question 13

Fields and criteria that will be used in a query are contained in the ____________________ when creating a query.

Accepted Answer

The answer of Fields and criteria that will be used...

Question 14

Match between columns
                        Premises: A select query that finds all records in a table or query that have no related records in the second table or query.

Accepted Answer

The Answer of SQL (Structured Query Language) and Long Text is...

Question 15

Match between columns
                        Premises: Selects a record for the designated field with a value that matches the pattern of a simple condition value.

Accepted Answer

The Answer of Validation Rule and list-of-values match and find is...

Quiz 5: Creating Advanced Queries and Enhancing Table Design

Matching

When creating a find unmatched query using the query wizard, Matching fields will be joined automatically if a ____________________ is already defined between the two selected objects.

Matching

Matching

Matching

The Top Values query property allows the user to limit the number of records in the query results by using a preset value, by entering an integer, or by selecting a(n)____________________.

Matching

Valid values that may be entered in a field are specified using the ____________________ propoerty.

Matching

Table Validation Rules are entered using the ____________________ for a table.

Matching

Matching

Fields and criteria that will be used in a query are contained in the ____________________ when creating a query.

Matching

Matching