Question 1

When you ________,you select a value in a record and Access filters the records that contain only the values that match what you have selected.

Accepted Answer

The answer of When you ________,you select a value in...

Question 2

A(n)________ is used as a placeholder for an unknown part of a value or to match a certain pattern in a value.

Accepted Answer

The answer of A(n)________ is used as a placeholder for...

Question 3

________ is a feature that can change the column width of the data to match the widest data entered in that field.

Accepted Answer

The answer of ________ is a feature that can change...

Question 4

When using the Find Duplicates Query Wizard,you select the fields that you think may include duplicate information,and the wizard creates the query to find records matching your criteria.

Accepted Answer

A) True 
 B)False

Question 5

Calculated query fields must be formatted in the query design grid using the ________.

Accepted Answer

A)  Navigation Pane 
B)  Expression Builder 
C)  Property Sheet 
D)  Navigation bar 
A)  Navigation Pane 
B)  Expression Builder 
C)  Property Sheet 
D)  Navigation bar

Question 6

The second and subsequent fields you choose to sort by are called ________ fields.

Accepted Answer

The answer of The second and subsequent fields you choose...

Question 7

________ perform arithmetic operations,such as calculating averages and totals,on records displayed in a table or query.

Accepted Answer

A)  Aggregate functions 
B)  Special operators 
C)  Comparison operators 
D)  Is Null criteria 
A)  Aggregate functions 
B)  Special operators 
C)  Comparison operators 
D)  Is Null criteria

Question 8

AutoSize is a feature that can change the column width of the data to match the widest data entered in that field.

Accepted Answer

A) True 
 B)False

Question 9

The ________ Query Wizard is used to display fields from one or more tables or queries with the option to choose a detailed or summary query if working with more than one table.

Accepted Answer

A)  Find Duplicates 
B)  Crosstab 
C)  Find Unmatched 
D)  Simple 
A)  Find Duplicates 
B)  Crosstab 
C)  Find Unmatched 
D)  Simple

Question 10

Which of the following is NOT true about sorting query results on a single field?

Accepted Answer

A)  To sort records, you have to select a sort field, or a field used to determine the order of the records. 
B)  A field may be sorted either in ascending order or descending order. 
C)  By default, records in a table or query are sorted by the primary key field. 
D)  Sorting is the process of rearranging records within a table in a specific order. 
A)  To sort records, you have to select a sort field, or a field used to determine the order of the records. 
B)  A field may be sorted either in ascending order or descending order. 
C)  By default, records in a table or query are sorted by the primary key field. 
D)  Sorting is the process of rearranging records within a table in a specific order.

Question 11

A(n)________ query is used when you want to describe one field in terms of two or more fields in the table.

Accepted Answer

The answer of A(n)________ query is used when you want...

Question 12

An orphan is a foreign key in one table that does not have a matching value in the primary key field of a related table.

Accepted Answer

A) True 
 B)False

Question 13

A placeholder character is used as a placeholder for an unknown part of a value or to match a certain pattern in a value.

Accepted Answer

A) True 
 B)False

Question 14

The ________ operator matches text values by using wildcards.

Accepted Answer

The answer of The ________ operator matches text values by...

Question 15

If you use multiple criteria,then you must also use ________ operators to combine criteria.

Accepted Answer

The answer of If you use multiple criteria,then you must...

Question 16

Which of the following is NOT a method used to add fields to a query design grid?

Accepted Answer

A)  Drag 
B)  Single-click field name 
C)  Double-click title bar 
D)  Click, Shift, click 
A)  Drag 
B)  Single-click field name 
C)  Double-click title bar 
D)  Click, Shift, click

Question 17

Match between columns
                        Premises: Replace command
Filter
Find command
Filter by selection
Wildcard character

Accepted Answer

The Answer of A condition temporarily applied to a table is...

Question 18

Match between columns
                        Premises: Join lines
Orphan
Query by example
Multiplier effect
Sort field

Accepted Answer

The Answer of The symbol that connects tables in the is...

Question 19

An aggregate function can be used in Datasheet view by adding a total row to a table.

Accepted Answer

A) True 
 B)False

Question 20

To match any single numeric character,you would use the ________ wildcard character.

Accepted Answer

To match any single numeric character, y

When you ________,you select a value in a record and Access filters the records that contain only the values that match what you have selected.

A(n)________ is used as a placeholder for an unknown part of a value or to match a certain pattern in a value.

________ is a feature that can change the column width of the data to match the widest data entered in that field.

When using the Find Duplicates Query Wizard,you select the fields that you think may include duplicate information,and the wizard creates the query to find records matching your criteria.

Calculated query fields must be formatted in the query design grid using the ________.

The second and subsequent fields you choose to sort by are called ________ fields.

________ perform arithmetic operations,such as calculating averages and totals,on records displayed in a table or query.

AutoSize is a feature that can change the column width of the data to match the widest data entered in that field.

The ________ Query Wizard is used to display fields from one or more tables or queries with the option to choose a detailed or summary query if working with more than one table.

Which of the following is NOT true about sorting query results on a single field?

A(n)________ query is used when you want to describe one field in terms of two or more fields in the table.

An orphan is a foreign key in one table that does not have a matching value in the primary key field of a related table.

A placeholder character is used as a placeholder for an unknown part of a value or to match a certain pattern in a value.

The ________ operator matches text values by using wildcards.

If you use multiple criteria,then you must also use ________ operators to combine criteria.

Which of the following is NOT a method used to add fields to a query design grid?

An aggregate function can be used in Datasheet view by adding a total row to a table.

To match any single numeric character,you would use the ________ wildcard character.

Understanding the Common Features of Microsoft Office

Explore Windows and File Management

Review and Modify a Document

Create and Edit a Document

Include Tables and Objects

Special Document Formatting and Mail Merge

Create, Navigate, Work With, and Print Worksheets

Formats, Functions, and Formulas

Cell References, Named Ranges, and Functions

Effective Charts

The Four Main Database Objects

Tables,Keys,and Relationships

Using Forms and Reports in Access

Presentation Fundamentals

Text and Graphics

Multimedia and Motion

Customization and Collaboration

Filters

Exam 13: Queries and Data Access

When you ________,you select a value in a record and Access filters the records that contain only the values that match what you have selected.

A(n)________ is used as a placeholder for an unknown part of a value or to match a certain pattern in a value.

________ is a feature that can change the column width of the data to match the widest data entered in that field.

When using the Find Duplicates Query Wizard,you select the fields that you think may include duplicate information,and the wizard creates the query to find records matching your criteria.

Calculated query fields must be formatted in the query design grid using the ________.

The second and subsequent fields you choose to sort by are called ________ fields.

________ perform arithmetic operations,such as calculating averages and totals,on records displayed in a table or query.

AutoSize is a feature that can change the column width of the data to match the widest data entered in that field.

The ________ Query Wizard is used to display fields from one or more tables or queries with the option to choose a detailed or summary query if working with more than one table.

Which of the following is NOT true about sorting query results on a single field?

A(n)________ query is used when you want to describe one field in terms of two or more fields in the table.

An orphan is a foreign key in one table that does not have a matching value in the primary key field of a related table.

A placeholder character is used as a placeholder for an unknown part of a value or to match a certain pattern in a value.

The ________ operator matches text values by using wildcards.

If you use multiple criteria,then you must also use ________ operators to combine criteria.

Which of the following is NOT a method used to add fields to a query design grid?

An aggregate function can be used in Datasheet view by adding a total row to a table.

To match any single numeric character,you would use the ________ wildcard character.

Understanding the Common Features of Microsoft Office

Explore Windows and File Management

Review and Modify a Document

Create and Edit a Document

Include Tables and Objects

Special Document Formatting and Mail Merge

Create, Navigate, Work With, and Print Worksheets

Formats, Functions, and Formulas

Cell References, Named Ranges, and Functions

Effective Charts

The Four Main Database Objects

Tables,Keys,and Relationships

Using Forms and Reports in Access

Presentation Fundamentals

Text and Graphics

Multimedia and Motion

Customization and Collaboration

Filters