Question 1

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

Accepted Answer

The answer of In Datasheet view,you can use the ________...

Question 2

To find all states that are not PA,you could enter "PA" for the state criteria.The  is an example of a logical operator.

Accepted Answer

A) True 
 B)False

Question 3

The query window in Design view allows you to specify the data you want to see by building a(n)________.

Accepted Answer

The answer of The query window in Design view allows...

Question 4

In a query,you can select any records that have no value in a field using the ________ criteria.

Accepted Answer

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

Question 5

Which of the following is NOT true regarding calculated fields?

Accepted Answer

A)  The result of the calculated field is displayed each time you run the query. 
B)  A calculated field can be added to a query using the fields in the query or even fields in another table or query in the database. 
C)  A calculated field is stored in the table once the query is saved. 
D)  The calculation can use a combination of numbers and field values, which allows you flexibility in how you perform the calculation. 
A)  The result of the calculated field is displayed each time you run the query. 
B)  A calculated field can be added to a query using the fields in the query or even fields in another table or query in the database. 
C)  A calculated field is stored in the table once the query is saved. 
D)  The calculation can use a combination of numbers and field values, which allows you flexibility in how you perform the calculation.

Question 6

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

Accepted Answer

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

Question 7

Match between columns
                        Premises: Sorting
Logical operator
Secondary sort field
Comparison operator
Primary sort field

Accepted Answer

The Answer of The process of rearranging records into a is...

Question 8

Which of the following is NOT true about using aggregate functions in a query?

Accepted Answer

A)  Aggregate functions can be used in queries to perform calculations on selected fields and records. 
B)  By default, the query design grid has a place to enter aggregate functions. 
C)  One advantage to using aggregate functions in queries, rather than just a total row, is that you can group criteria and then calculate the aggregate functions for a group of records. 
D)  Each column or field can calculate only one aggregate function. 
A)  Aggregate functions can be used in queries to perform calculations on selected fields and records. 
B)  By default, the query design grid has a place to enter aggregate functions. 
C)  One advantage to using aggregate functions in queries, rather than just a total row, is that you can group criteria and then calculate the aggregate functions for a group of records. 
D)  Each column or field can calculate only one aggregate function.

Question 9

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

Accepted Answer

A)  everything except 
B)  part of 
C)  all of 
D)  all or part of 
A)  everything except 
B)  part of 
C)  all of 
D)  all or part of

Question 10

The ________ contains a list of properties for fields in which you can make precise changes to each property associated with the field.

Accepted Answer

The answer of The ________ contains a list of properties...

Question 11

Which of the following is NOT true about using special operators?

Accepted Answer

A)  Special operators are used to compare text values using wildcards using the LIKE operator. 
B)  Special operators are used to determine whether values are between a range of values using the BETWEEN operator. 
C)  Special operators are used to compare text values using Find & Replace along with the AND operator. 
D)  Special operators are used in a set of values using the IN operator. 
A)  Special operators are used to compare text values using wildcards using the LIKE operator. 
B)  Special operators are used to determine whether values are between a range of values using the BETWEEN operator. 
C)  Special operators are used to compare text values using Find & Replace along with the AND operator. 
D)  Special operators are used in a set of values using the IN operator.

Question 12

Which of the following is NOT true about applying filters to a datasheet?

Accepted Answer

A)  A filter is a condition you apply permanently to a table or query. 
B)  You can choose to save a table with the filter applied so when you open the table later the filter is still available. 
C)  A filter is a simple technique to quickly reduce a large amount of data to a much smaller subset of data. 
D)  All records that do not match the filter criteria are hidden until the filter is removed or the table is closed and reopened. 
A)  A filter is a condition you apply permanently to a table or query. 
B)  You can choose to save a table with the filter applied so when you open the table later the filter is still available. 
C)  A filter is a simple technique to quickly reduce a large amount of data to a much smaller subset of data. 
D)  All records that do not match the filter criteria are hidden until the filter is removed or the table is closed and reopened.

Question 13

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

Accepted Answer

The answer of The ________ is a tool in Access...

Question 14

A(n)________ query is used when you want to find the rows in one table that do not have a match in the other table.

Accepted Answer

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

Question 15

To search for a three-letter word that begins with "m" and ends with "t" you would enter ________.

Accepted Answer

A)  m[?]t 
B)  m!t 
C)  m-t 
D)  m?t 
A)  m[?]t 
B)  m!t 
C)  m-t 
D)  m?t

Question 16

________ allow you to create a custom filter to match all or part of the text in a field that you specify.

Accepted Answer

The answer of ________ allow you to create a custom...

Question 17

To search for a word that starts with "e",contains any of the letters "a" or "r" and ends with "r",you would enter e[ar]r and get "ear" or "err" as a result.

Accepted Answer

A) True 
 B)False

Question 18

Which of the following is NOT true about creating queries in Design view?

Accepted Answer

A)  When you open Design view, by default, the Show Table dialog box opens with a list of available tables and queries to add. 
B)  When you use the query window, you have more control and more options available to manage the details of the query design than with the Simple Query Wizard. 
C)  The query window in Design view allows you to specify the data you want to see by building a query by wizard. 
D)  In the query window, you can include specific fields, define criteria, sort records, and perform calculations. 
A)  When you open Design view, by default, the Show Table dialog box opens with a list of available tables and queries to add. 
B)  When you use the query window, you have more control and more options available to manage the details of the query design than with the Simple Query Wizard. 
C)  The query window in Design view allows you to specify the data you want to see by building a query by wizard. 
D)  In the query window, you can include specific fields, define criteria, sort records, and perform calculations.

Question 19

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 ________ effect.

Accepted Answer

A)  relationship 
B)  join 
C)  multiplier 
D)  query 
A)  relationship 
B)  join 
C)  multiplier 
D)  query

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

To find all states that are not PA,you could enter < >"PA" for the state criteria.The < > is an example of a logical operator.

The query window in Design view allows you to specify the data you want to see by building a(n)________.

In a query,you can select any records that have no value in a field using the ________ criteria.

Which of the following is NOT true regarding calculated fields?

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

Which of the following is NOT true about using aggregate functions in a query?

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

The ________ contains a list of properties for fields in which you can make precise changes to each property associated with the field.

Which of the following is NOT true about using special operators?

Which of the following is NOT true about applying filters to a datasheet?

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

A(n)________ query is used when you want to find the rows in one table that do not have a match in the other table.

To search for a three-letter word that begins with "m" and ends with "t" you would enter ________.

________ allow you to create a custom filter to match all or part of the text in a field that you specify.

To search for a word that starts with "e",contains any of the letters "a" or "r" and ends with "r",you would enter e[ar]r and get "ear" or "err" as a result.

Which of the following is NOT true about creating queries in Design view?

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 ________ effect.

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

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

To find all states that are not PA,you could enter < >"PA" for the state criteria.The < > is an example of a logical operator.

The query window in Design view allows you to specify the data you want to see by building a(n)________.

In a query,you can select any records that have no value in a field using the ________ criteria.

Which of the following is NOT true regarding calculated fields?

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

Which of the following is NOT true about using aggregate functions in a query?

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

The ________ contains a list of properties for fields in which you can make precise changes to each property associated with the field.

Which of the following is NOT true about using special operators?

Which of the following is NOT true about applying filters to a datasheet?

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

A(n)________ query is used when you want to find the rows in one table that do not have a match in the other table.

To search for a three-letter word that begins with "m" and ends with "t" you would enter ________.

________ allow you to create a custom filter to match all or part of the text in a field that you specify.

To search for a word that starts with "e",contains any of the letters "a" or "r" and ends with "r",you would enter e[ar]r and get "ear" or "err" as a result.

Which of the following is NOT true about creating queries in Design view?

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 ________ effect.

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