Question 1

The ________ operator matches text values by using wildcards.

Accepted Answer

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

Question 2

________ are the lines connecting the tables that represent relationships.

Accepted Answer

The answer of ________ are the lines connecting the tables...

Question 3

The first field you choose to sort by is called the ________ field.

Accepted Answer

The answer of The first field you choose to sort...

Question 4

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 5

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 6

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) The calculation can use a combination of numbers and field values,which allows you flexibility in how you perform the calculation. 
D) A calculated field is stored in the table once the query is saved. 
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) The calculation can use a combination of numbers and field values,which allows you flexibility in how you perform the calculation. 
D) A calculated field is stored in the table once the query is saved.

Question 7

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 8

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 9

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 10

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 11

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

Accepted Answer

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

Question 12

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

Accepted Answer

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

Question 13

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

Accepted Answer

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

Question 14

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

Accepted Answer

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

Question 15

When you want to specify criteria in multiple fields,and at least one of the 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 16

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

Accepted Answer

A) t?p 
B) t#p 
C) t*p 
D) t!p 
A) t?p 
B) t#p 
C) t*p 
D) t!p

Question 17

Comparison operators compare the values in a table or another query to the criteria value you set up in a query.

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

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

Question 19

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 20

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

The ________ operator matches text values by using wildcards.

________ are the lines connecting the tables that represent relationships.

The first field you choose to sort by is called the ________ field.

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.

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

Which of the following is NOT true regarding calculated fields?

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

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

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.

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

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

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

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

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

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

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

Comparison operators compare the values in a table or another query to the criteria value you set up in a query.

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

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

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

Workshop 1: The Four Main Database Objects

Workshop 2: Tables, Keys, and Relationships

Workshop 4: Access Information From an Access Database

Workshop 5: Advanced Tables

Workshop 6: Pattern Matching and Functions in Queries

Workshop 7: Aggregated Calculations, Subquerying, and Sql

Workshop 8: Action Queries and Advanced Relationships

Workshop 9: Advanced Reports and Mailing Labels

Workshop 10: Advanced Form Settings and Form Types

Workshop 11: Develop Navigation Forms and the User Interface

Workshop 12: Create a Refined User Experience With Macros

Workshop 13: Use VBA in Access

Workshop 14: Implement Your Database

Normalize a Database for Effective Design

The Common Features of Microsoft Office

Efficient Interaction With a Touch Screen

Filters

Exam 3: Workshop 3: Queries and Data Access

The ________ operator matches text values by using wildcards.

________ are the lines connecting the tables that represent relationships.

The first field you choose to sort by is called the ________ field.

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.

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

Which of the following is NOT true regarding calculated fields?

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

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

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.

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

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

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

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

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

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

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

Comparison operators compare the values in a table or another query to the criteria value you set up in a query.

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

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

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

Workshop 1: The Four Main Database Objects

Workshop 2: Tables, Keys, and Relationships

Workshop 4: Access Information From an Access Database

Workshop 5: Advanced Tables

Workshop 6: Pattern Matching and Functions in Queries

Workshop 7: Aggregated Calculations, Subquerying, and Sql

Workshop 8: Action Queries and Advanced Relationships

Workshop 9: Advanced Reports and Mailing Labels

Workshop 10: Advanced Form Settings and Form Types

Workshop 11: Develop Navigation Forms and the User Interface

Workshop 12: Create a Refined User Experience With Macros

Workshop 13: Use VBA in Access

Workshop 14: Implement Your Database

Normalize a Database for Effective Design

The Common Features of Microsoft Office

Efficient Interaction With a Touch Screen

Filters