Question 1

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 2

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 pattern match and Validation Rule and list-of-values is...

Question 3

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

Accepted Answer

The Answer of find unmatched query and property propagation and is...

Question 4

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 5

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 6

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 7

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

Accepted Answer

The Answer of property propagation and Validation Rule and table is...

Question 8

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

Accepted Answer

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

Question 9

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 Long Text and list-of-values match and table is...

Question 10

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 lookup field and table validation rule and is...

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 find duplicates query and table validation rule is...

Question 12

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

Accepted Answer

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

Question 13

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 table validation rule and find duplicates query is...

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 pattern match and find unmatched query and 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 Long Text and table validation rule and is...

Quiz 1: Access 1: Creating Advanced Queries and Enhancing Table Design

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

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

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)____________________.

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

Matching

Matching

Matching

Matching

Matching

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

Matching

Matching

Match the followings.