Question 1

Which of the following is NOT used as a comparison operator?

Accepted Answer

A) = 
B)  
D)  
A) = 
B)  
D)

Question 2

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

Question 3

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

The answer of A(n)________ is a foreign key in one...

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

The ________ operator determines if a number or date is within a range.

Accepted Answer

The answer of The ________ operator determines if a number...

Question 6

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 7

Match the following number field sizes with their description.
I.AND
II.OR
III.NOT
IV.LIKE
V.BETWEEN
A.Does not meet the criteria
B.Meets one or more criteria
C.Meets both criteria
D.Uses wildcards
E.Within a range

Accepted Answer

The answer of Match the following number field sizes with...

Question 8

________ operators are generally used with numbers and dates to find a range or a specific value.

Accepted Answer

The answer of ________ operators are generally used with numbers...

Question 9

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) Average 
D) Maximum 
A) Count 
B) Sum 
C) Average 
D) Maximum

Question 10

To search for a three-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 11

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

Accepted Answer

A) True 
 B)False

Question 12

Match the following wildcard characters with their example.
I.*
II.#
III.?
IV.!
V.-
A.To match any number of characters
B.To match any single numeric character
C.To match any range of characters in ascending order
D.To match any single character
E.To match any single character NOT within the brackets

Accepted Answer

The answer of Match the following wildcard characters with their...

Question 13

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

Accepted Answer

A) Special operators are used to compare text values using Find & Replace along with the AND 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 in a set of values using the IN operator. 
D) Special operators are used to compare text values using wildcards using the LIKE operator. 
A) Special operators are used to compare text values using Find & Replace along with the AND 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 in a set of values using the IN operator. 
D) Special operators are used to compare text values using wildcards using the LIKE operator.

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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 16

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

Accepted Answer

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

Question 17

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

Accepted Answer

A) Field properties sheet 
B) Navigation Pane 
C) Expression Builder 
D) Navigation bar 
A) Field properties sheet 
B) Navigation Pane 
C) Expression Builder 
D) Navigation bar

Question 18

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 19

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 20

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

Accepted Answer

A) True 
 B)False

Which of the following is NOT used as a comparison operator?

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)________ is a foreign key in one table that does not have a matching value in the primary key field of a related table.

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

The ________ operator determines if a number or date is within a range.

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

Match the following number field sizes with their description. I.AND II.OR III.NOT IV.LIKE V.BETWEEN A.Does not meet the criteria B.Meets one or more criteria C.Meets both criteria D.Uses wildcards E.Within a range

________ operators are generally used with numbers and dates to find a range or a specific value.

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

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

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

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

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

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

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

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

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.

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

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

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

Which of the following is NOT used as a comparison operator?

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)________ is a foreign key in one table that does not have a matching value in the primary key field of a related table.

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

The ________ operator determines if a number or date is within a range.

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

Match the following number field sizes with their description. I.AND II.OR III.NOT IV.LIKE V.BETWEEN A.Does not meet the criteria B.Meets one or more criteria C.Meets both criteria D.Uses wildcards E.Within a range

________ operators are generally used with numbers and dates to find a range or a specific value.

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

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

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

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

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

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

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

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

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.

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

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

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