Question 1

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

Accepted Answer

A) In the query window,you can include specific fields,define criteria,sort records,and perform calculations. 
B) The query window in Design view allows you to specify the data you want to see by building a query by wizard. 
C) 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. 
D) When you open Design view,by default,the Show Table dialog box opens with a list of available tables and queries to add. 
A) In the query window,you can include specific fields,define criteria,sort records,and perform calculations. 
B) The query window in Design view allows you to specify the data you want to see by building a query by wizard. 
C) 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. 
D) When you open Design view,by default,the Show Table dialog box opens with a list of available tables and queries to add.

Question 2

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 3

Match the following operators with their description.
I. =
III.
V.
A.Greater than or equal to
B.Less than or equal to
C.Less than
D.Not equal to
E.Greater than

Accepted Answer

The answer of Match the following operators with their description.
I....

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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 6

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

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

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.

Match the following operators with their description. I.< = II.> = III.< IV.> V.< > A.Greater than or equal to B.Less than or equal to C.Less than D.Not equal to E.Greater than

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

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

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.

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 true about creating queries in Design view?

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.

Match the following operators with their description. I.< = II.> = III.< IV.> V.< > A.Greater than or equal to B.Less than or equal to C.Less than D.Not equal to E.Greater than

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

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

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.

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