Question 1

Which of the following is NOT true about the Find Unmatched query wizard?

Accepted Answer

A)  The wizard uses the primary key from the first table and matches it with the foreign key in the second table in order to determine if there are unmatched records. 
B)  The Find Unmatched Query Wizard is designed to find records in a table or query that have no related records in the same table or query. 
C)  The wizard will try to match the primary key field and the foreign key field if there is a one-to-many relationship between the two tables. 
D)  If a one-to-many relationship exists between the two tables, then the wizard will join the two correct fields automatically. 
A)  The wizard uses the primary key from the first table and matches it with the foreign key in the second table in order to determine if there are unmatched records. 
B)  The Find Unmatched Query Wizard is designed to find records in a table or query that have no related records in the same table or query. 
C)  The wizard will try to match the primary key field and the foreign key field if there is a one-to-many relationship between the two tables. 
D)  If a one-to-many relationship exists between the two tables, then the wizard will join the two correct fields automatically. B

Question 2

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

A)  use the Find command 
B)  filter by selection 
C)  use the Replace command 
D)  use the Navigation bar 
A)  use the Find command 
B)  filter by selection 
C)  use the Replace command 
D)  use the Navigation bar B

Question 3

To search for a word that begins with "ar" you would enter ________.

Accepted Answer

A)  ar? 
B)  ar# 
C)  ar! 
D)  ar* 
A)  ar? 
B)  ar# 
C)  ar! 
D)  ar* D

Question 4

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

Accepted Answer

A)  AutoFit 
B)  Form fit 
C)  Field size 
D)  Fit by selection 
A)  AutoFit 
B)  Form fit 
C)  Field size 
D)  Fit by selection

Question 5

If you need to see a quick snapshot of statistics for a table or query,you can use the ________.

Accepted Answer

A)  total row 
B)  aggregate row 
C)  Function pane 
D)  statistics button 
A)  total row 
B)  aggregate row 
C)  Function pane 
D)  statistics button

Question 6

In a query,if you wanted to display the smallest value from the selected records,you would use the ________ aggregate function.

Accepted Answer

A)  Count 
B)  Sum 
C)  Minimum 
D)  Maximum 
A)  Count 
B)  Sum 
C)  Minimum 
D)  Maximum

Question 7

If two tables do not have a common field,Access will join the two tables by combining the records,regardless of whether they have a matching field.This is known as the multiplier effect.

Accepted Answer

A) True 
 B)False

Question 8

Match between columns
                        Premises: Text filter
Find Duplicates query
AutoFit
Find Unmatched query
Crosstab query

Accepted Answer

The Answer of Used to describe one field in terms is...

Question 9

Which of the following is NOT true about sorting query results on multiple fields?

Accepted Answer

A)  In datasheet view, you can sort multiple fields by selecting all the fields at one time and using the Sort & Filter group sorts. 
B)  The second and subsequent fields are called secondary sort fields. 
C)  The first field you choose to sort by is called the primary sort field. 
D)  You can have one field sorted in ascending order and another in descending order. 
A)  In datasheet view, you can sort multiple fields by selecting all the fields at one time and using the Sort & Filter group sorts. 
B)  The second and subsequent fields are called secondary sort fields. 
C)  The first field you choose to sort by is called the primary sort field. 
D)  You can have one field sorted in ascending order and another in descending order.

Question 10

With multiple criteria,it is good practice to add one criteria,run the query to make sure you are getting the correct results,and then continue adding criteria one at a time.

Accepted Answer

A) True 
 B)False

Question 11

________ equate the values in a table or another query to the criteria value you set up in a query.

Accepted Answer

A)  Comparison operators 
B)  Is Null criteria 
C)  Search criteria 
D)  Query operators 
A)  Comparison operators 
B)  Is Null criteria 
C)  Search criteria 
D)  Query operators

Question 12

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

Accepted Answer

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

Question 13

A ________ query is used when you want to find records with the same specific value.

Accepted Answer

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

Question 14

The query window in Design view allows you to specify the data you want to see by building a query by example.

Accepted Answer

A) True 
 B)False

Question 15

A(n)________ 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)  composite key 
B)  orphan 
C)  wildcard 
D)  duplicate key 
A)  composite key 
B)  orphan 
C)  wildcard 
D)  duplicate key

Question 16

A(n)________ field is a field used to determine the order of the records.

Accepted Answer

The answer of A(n)________ field is a field used to...

Question 17

In a query,if you wanted to display the number of records retrieved,you would use the ________ aggregate function.

Accepted Answer

A)  Count 
B)  Sum 
C)  Minimum 
D)  Maximum 
A)  Count 
B)  Sum 
C)  Minimum 
D)  Maximum

Question 18

Relationship lines are the lines connecting the tables that represent relationships.

Accepted Answer

A) True 
 B)False

Question 19

To search for a word beginning with "a" and ending in "e" with any letter between "b" and "t" in between,you would enter b[a-e]t.

Accepted Answer

A) True 
 B)False

Question 20

________ is a tool in Access that can help you format your calculated fields correctly.

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

Which of the following is NOT true about the Find Unmatched query wizard?

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.

To search for a word that begins with "ar" you would enter ________.

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

If you need to see a quick snapshot of statistics for a table or query,you can use the ________.

In a query,if you wanted to display the smallest value from the selected records,you would use the ________ aggregate function.

If two tables do not have a common field,Access will join the two tables by combining the records,regardless of whether they have a matching field.This is known as the multiplier effect.

Which of the following is NOT true about sorting query results on multiple fields?

With multiple criteria,it is good practice to add one criteria,run the query to make sure you are getting the correct results,and then continue adding criteria one at a time.

________ equate the values in a table or another query to the criteria value you set up in a query.

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

A ________ query is used when you want to find records with the same specific value.

The query window in Design view allows you to specify the data you want to see by building a query by example.

A(n)________ is a foreign key in one table that does not have a matching value in the primary key field of a related table.

A(n)________ field is a field used to determine the order of the records.

In a query,if you wanted to display the number of records retrieved,you would use the ________ aggregate function.

Relationship lines are the lines connecting the tables that represent relationships.

To search for a word beginning with "a" and ending in "e" with any letter between "b" and "t" in between,you would enter b[a-e]t.

________ is a tool in Access that can help you format your calculated fields correctly.

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

Which of the following is NOT true about the Find Unmatched query wizard?

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.

To search for a word that begins with "ar" you would enter ________.

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

If you need to see a quick snapshot of statistics for a table or query,you can use the ________.

In a query,if you wanted to display the smallest value from the selected records,you would use the ________ aggregate function.

If two tables do not have a common field,Access will join the two tables by combining the records,regardless of whether they have a matching field.This is known as the multiplier effect.

Which of the following is NOT true about sorting query results on multiple fields?

With multiple criteria,it is good practice to add one criteria,run the query to make sure you are getting the correct results,and then continue adding criteria one at a time.

________ equate the values in a table or another query to the criteria value you set up in a query.

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

A ________ query is used when you want to find records with the same specific value.

The query window in Design view allows you to specify the data you want to see by building a query by example.

A(n)________ is a foreign key in one table that does not have a matching value in the primary key field of a related table.

A(n)________ field is a field used to determine the order of the records.

In a query,if you wanted to display the number of records retrieved,you would use the ________ aggregate function.

Relationship lines are the lines connecting the tables that represent relationships.

To search for a word beginning with "a" and ending in "e" with any letter between "b" and "t" in between,you would enter b[a-e]t.

________ is a tool in Access that can help you format your calculated fields correctly.

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