Question 1

A field property option that verfies a field value by comparing the value entered to a constant or set of constants.

Accepted Answer

A)  	find unmatched query 
B) SQL (Structured Query Language) 
C) list-of-values match 
D) table validation rule 
E) Long Text
F)lookup field
G)pattern match
H)Validation Rule
I)find duplicates query
J)property propagation

Question 2

____________________ perform arithmetic operations on selected records in a crosstab query.

Accepted Answer

The answer of ____________________ perform arithmetic operations on selected records...

Question 3

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 4

To add more flexibility and functionality to a parameter query,comparison operators,such as ___,may be added to the original criterion.

Accepted Answer

A) Like 
B) Unlike 
C) IsIn 
D) IsNull

Question 5

In crosstab query results,the value of a checked Yes/No data type field will display as ____.

Accepted Answer

A) 0 
B) 1 
C) -1 
D) +1

Question 6

The ____ comparison operator is used to select records by matching field values specific to a pattern that includes one or more wildcard characters.

Accepted Answer

A) Between 
B) More 
C) In 
D) Like

Question 7

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

A)  	find unmatched query 
B) SQL (Structured Query Language) 
C) list-of-values match 
D) table validation rule 
E) Long Text
F)lookup field
G)pattern match
H)Validation Rule
I)find duplicates query
J)property propagation

Question 8

Which Access object(s)may be used when creating a lookup field to select values?

Accepted Answer

A) table 
B) form 
C) report 
D) both table and report

Question 9

Which of the following is an example of a parameter query prompt criterion?

Accepted Answer

A) [Type the state:] 
B) Prompt: "Type the state:" 
C) *Type the state:* 
D) {Type the state:}

Question 10

A rule that is set when the validation involves multiple fields.

Accepted Answer

A)  	find unmatched query 
B) SQL (Structured Query Language) 
C) list-of-values match 
D) table validation rule 
E) Long Text
F)lookup field
G)pattern match
H)Validation Rule
I)find duplicates query
J)property propagation

Question 11

Selects a record for the designated field with a value that matches the pattern of a simple condition value.a.find unmatched query

Accepted Answer

A)  	find unmatched query 
B) SQL (Structured Query Language) 
C) list-of-values match 
D) table validation rule 
E) Long Text
F)lookup field
G)pattern match
H)Validation Rule
I)find duplicates query
J)property propagation

Question 12

It is a good idea to ____ the database before using compact and repair to keep the database safe from hardware and software malfunctions.

Accepted Answer

A) use a second computer to save 
B) run a virus check on 
C) make a backup copy of 
D) proofread

Question 13

Yes/No field values are stored in an Access database as a --1 for a checked value and a 0 for an unchecked value.

Accepted Answer

A) True 
 B)False

Question 14

Tables used in a find unmatched query must have a common field.____________________

Accepted Answer

A) True 
 B)False

Question 15

A parameter query displays a dialog box that prompts the user to enter one or more values when the query is run.____________________

Accepted Answer

A) True 
 B)False

Question 16

When creating an input mask,the ____ input mask character is used to indicate that the following character will be a literal display of that character.

Accepted Answer

A) # 
B) & 
C) \ 
D) !

Question 17

Marie works for a busy pediatrician's office.The practice has a sophisticated database for all records and information that pertain to the practice.The doctor for whom she works is participating in an academic study,and she needs a report that lists the patient's name,date of birth,and the names of parents or guardians.The doctor would like to see the patient's full name in the format Lastname,Firstname even though they are separate fields in the database.She would also like to see the data for the fields Mother,Father,and Guardian,regardless of whether or not data is actually entered in those fields.  Based on the doctor's requirements for the report,Marie must create a query on which to base the report.
-Because the doctor wants all data entered for parents and guardians regardless of the data in the field,Marie must create a calculated field in the query with a function that tests the Mother,Father,and Guardian fields for a condition that is either true or false.If the condition is true,one result will be displayed,and if the condition is false a different result will be displayed.Which function should Marie use for this calculated field?

Accepted Answer

A) Input 
B) IIf 
C) nonnull 
D) IsError

Question 18

The office manager at Riverview Veterinary Care Center would like to create a query which displays all patients who have not yet received their yearly check up.She will use the qryAnimalsAndOwners and tblVisit table to create the query.Which type of query will most likely create the desired results?

Accepted Answer

A) crosstab query 
B) find unmatched query 
C) simple query 
D) find duplicates query

Question 19

Setting the ____ field property to Yes instructs Access to keep an historical record of all versions of the Long Text field value.

Accepted Answer

A) Append Only 
B) Validation Rule 
C) Input Max 
D) Default Value

Question 20

The ____________________ button in the Sort &Filter group on the Home tab is used to remove the current filter in a dataset or to reapply a filter.

Accepted Answer

The answer of The ____________________ button in the Sort &Filter...

Exam 5: Creating Advanced Queries and Enhancing Table Design

A field property option that verfies a field value by comparing the value entered to a constant or set of constants.

____________________ perform arithmetic operations on selected records in a crosstab query.

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.

To add more flexibility and functionality to a parameter query,comparison operators,such as ___,may be added to the original criterion.

In crosstab query results,the value of a checked Yes/No data type field will display as ____.

The ____ comparison operator is used to select records by matching field values specific to a pattern that includes one or more wildcard characters.

A select query that finds all records in a table or query that have no related records in the second table or query.

Which Access object(s) may be used when creating a lookup field to select values?

Which of the following is an example of a parameter query prompt criterion?

A rule that is set when the validation involves multiple fields.

Selects a record for the designated field with a value that matches the pattern of a simple condition value.a.find unmatched query

It is a good idea to ____ the database before using compact and repair to keep the database safe from hardware and software malfunctions.

Yes/No field values are stored in an Access database as a --1 for a checked value and a 0 for an unchecked value.

Tables used in a find unmatched query must have a common field.____________________

A parameter query displays a dialog box that prompts the user to enter one or more values when the query is run.____________________

When creating an input mask,the ____ input mask character is used to indicate that the following character will be a literal display of that character.

The office manager at Riverview Veterinary Care Center would like to create a query which displays all patients who have not yet received their yearly check up.She will use the qryAnimalsAndOwners and tblVisit table to create the query.Which type of query will most likely create the desired results?

Setting the ____ field property to Yes instructs Access to keep an historical record of all versions of the Long Text field value.

The ____________________ button in the Sort &Filter group on the Home tab is used to remove the current filter in a dataset or to reapply a filter.