Question 1

The Simple Query Wizard provides the opportunity to select data criteria.

Accepted Answer

A) True 
 B)False

Question 2

In addition to the Simple Query Wizard,there are three additional query wizards available to make quick,step-by-step queries.

Accepted Answer

A) True 
 B)False

Question 3

Which of the following is NOT true about changing field names in a query?

Accepted Answer

A)  The default name that Access uses for a field that includes an aggregate function is descriptive and does not need to be changed. 
B)  Field names in aggregate queries are a composite of the selected aggregate function and the table field name. 
C)  The field names assigned in an aggregate query can easily be changed either before or after the query is run. 
D)  You must keep the original field name in the query design grid so Access knows what field to perform the calculation on. 
A)  The default name that Access uses for a field that includes an aggregate function is descriptive and does not need to be changed. 
B)  Field names in aggregate queries are a composite of the selected aggregate function and the table field name. 
C)  The field names assigned in an aggregate query can easily be changed either before or after the query is run. 
D)  You must keep the original field name in the query design grid so Access knows what field to perform the calculation on.

Question 4

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.

Accepted Answer

A) True 
 B)False

Question 5

Text filters allow you to create a custom filter to match all of the text in a field that you specify.

Accepted Answer

A) True 
 B)False

Question 6

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 called the ________.

Accepted Answer

The answer of If two tables do not have a...

Question 7

To search for a word that starts with "ar" you would enter ar*.

Accepted Answer

A) True 
 B)False

Question 8

To search for a three-digit number that starts with "67" you would enter 67*.

Accepted Answer

A) True 
 B)False

Question 9

The Navigation bar allows you to move to the top and bottom of a table or scroll to a specific record and can be an efficient tool regardless of the size of the table.

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

The answer of If you need to see a quick...

Question 11

In Datasheet view,you can use the Replace command to quickly locate specific records using all or part of a field value.

Accepted Answer

A) True 
 B)False

Question 12

A wildcard character can replace a single character or multiple characters for both text and numbers.

Accepted Answer

A) True 
 B)False

Question 13

By default,records in a table or query are sorted by the foreign key field.

Accepted Answer

A) True 
 B)False

Question 14

To search for a four-digit number that starts with "75" you would enter ________.

Accepted Answer

A)  75? 
B)  75# 
C)  75## 
D)  75! 
A)  75? 
B)  75# 
C)  75## 
D)  75!

Question 15

________ is the process of rearranging records in a specific order.

Accepted Answer

The answer of ________ is the process of rearranging records...

Question 16

In Datasheet view,you can use the ________ to quickly locate specific records using all or part of a field value.

Accepted Answer

A)  wildcard character 
B)  Replace command 
C)  Find command 
D)  Find & Replace command 
A)  wildcard character 
B)  Replace command 
C)  Find command 
D)  Find & Replace command

Question 17

Datasheets are used to view all records in a table at one time.

Accepted Answer

A) True 
 B)False

Question 18

When you want to specify multiple criteria,and all criteria must be true for a record to be included in the results,then the ________ logical operator is used.

Accepted Answer

A)  AND 
B)  OR 
C)  NOT 
D)  BETWEEN 
A)  AND 
B)  OR 
C)  NOT 
D)  BETWEEN

Question 19

In a query,if you use multiple criteria,then you may also use logical operators to combine these criteria.

Accepted Answer

A) True 
 B)False

Question 20

To search for a three-letter word that starts with "t" and ends with "p" you would enter t!p.

Accepted Answer

A) True 
 B)False

The Simple Query Wizard provides the opportunity to select data criteria.

In addition to the Simple Query Wizard,there are three additional query wizards available to make quick,step-by-step queries.

Which of the following is NOT true about changing field names in a query?

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.

Text filters allow you to create a custom filter to match all of the text in a field that you specify.

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 called the ________.

To search for a word that starts with "ar" you would enter ar*.

To search for a three-digit number that starts with "67" you would enter 67*.

The Navigation bar allows you to move to the top and bottom of a table or scroll to a specific record and can be an efficient tool regardless of the size of the table.

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

In Datasheet view,you can use the Replace command to quickly locate specific records using all or part of a field value.

A wildcard character can replace a single character or multiple characters for both text and numbers.

By default,records in a table or query are sorted by the foreign key field.

To search for a four-digit number that starts with "75" you would enter ________.

________ is the process of rearranging records in a specific order.

In Datasheet view,you can use the ________ to quickly locate specific records using all or part of a field value.

Datasheets are used to view all records in a table at one time.

When you want to specify multiple criteria,and all criteria must be true for a record to be included in the results,then the ________ logical operator is used.

In a query,if you use multiple criteria,then you may also use logical operators to combine these criteria.

To search for a three-letter word that starts with "t" and ends with "p" you would enter t!p.

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

The Simple Query Wizard provides the opportunity to select data criteria.

In addition to the Simple Query Wizard,there are three additional query wizards available to make quick,step-by-step queries.

Which of the following is NOT true about changing field names in a query?

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.

Text filters allow you to create a custom filter to match all of the text in a field that you specify.

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 called the ________.

To search for a word that starts with "ar" you would enter ar*.

To search for a three-digit number that starts with "67" you would enter 67*.

The Navigation bar allows you to move to the top and bottom of a table or scroll to a specific record and can be an efficient tool regardless of the size of the table.

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

In Datasheet view,you can use the Replace command to quickly locate specific records using all or part of a field value.

A wildcard character can replace a single character or multiple characters for both text and numbers.

By default,records in a table or query are sorted by the foreign key field.

To search for a four-digit number that starts with "75" you would enter ________.

________ is the process of rearranging records in a specific order.

In Datasheet view,you can use the ________ to quickly locate specific records using all or part of a field value.

Datasheets are used to view all records in a table at one time.

When you want to specify multiple criteria,and all criteria must be true for a record to be included in the results,then the ________ logical operator is used.

In a query,if you use multiple criteria,then you may also use logical operators to combine these criteria.

To search for a three-letter word that starts with "t" and ends with "p" you would enter t!p.

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