Question 1

-In the accompanying figure,how many fields will display on the resulting datasheet?

Accepted Answer

A)  3 
B)  4 
C)  5 
D)  6 
A)  3 
B)  4 
C)  5 
D)  6

Question 2

Describe the one-to-many relationships of the tables shown in the accompanying figure.

Accepted Answer

The Customers and Sales tables are relat

Question 3

Syntax are tests,or limiting conditions,that must be true for a record to be selected for a datasheet in a query._________________________

Accepted Answer

A) True 
 B)False

Question 4

Multiple criteria added to the same line of the query design grid means that each must be true for the record to appear in the datasheet.

Accepted Answer

A) True 
 B)False

Question 5

When you open a query in Datasheet View,you run it.

Accepted Answer

A) True 
 B)False

Question 6

In a query,the  operator means not equal.

Accepted Answer

A) True 
 B)False

Question 7

In SQL,the FROM keyword determines how records are sorted._________________________

Accepted Answer

A) True 
 B)False

Question 8

Each criteria row of the query design grid is evaluated separately.

Accepted Answer

A) True 
 B)False

Question 9

Access helps you with criteria syntax in the query design grid.

Accepted Answer

A) True 
 B)False

Question 10

Sort orders defined in Query Design View are not saved with the query object.

Accepted Answer

A) True 
 B)False

Question 11

Which function should you use to calculate today's current date?

Accepted Answer

A)  CURRENT 
B)  DATE 
C)  YEAR 
D)  DAY 
A)  CURRENT 
B)  DATE 
C)  YEAR 
D)  DAY

Question 12

The >= comparison operator means ____.

Accepted Answer

A)  less than or greater than 
B)  within 
C)  in 
D)  greater than or equal to 
A)  less than or greater than 
B)  within 
C)  in 
D)  greater than or equal to

Question 13

Discuss the use of the * wildcard character in query criteria.

Accepted Answer

The wildcard character * is us

Question 14

When you create a summary query,which row is added to the query design grid?

Accepted Answer

A)  Criteria 
B)  Table 
C)  Field 
D)  Total 
A)  Criteria 
B)  Table 
C)  Field 
D)  Total

Question 15

The wildcard character that represents any combination of characters in query criteria is the ____.

Accepted Answer

A)  asterisk (*) 
B)  exclamation point (!) 
C)  tilde (~) 
D)  question mark (?) 
A)  asterisk (*) 
B)  exclamation point (!) 
C)  tilde (~) 
D)  question mark (?)

Question 16

Which aggregate function is used to find the number of values in a field?

Accepted Answer

A)  Values 
B)  Num 
C)  Number 
D)  Count 
A)  Values 
B)  Num 
C)  Number 
D)  Count

Question 17

Which aggregate function is used to find the total of values in a field?

Accepted Answer

A)  Sum 
B)  Sub 
C)  Subtotal 
D)  Total 
A)  Sum 
B)  Sub 
C)  Subtotal 
D)  Total

Question 18

The < comparison operator means ____.

Accepted Answer

A)  less than 
B)  not equal to 
C)  greater than 
D)  null 
A)  less than 
B)  not equal to 
C)  greater than 
D)  null

Question 19

Which arithmetic operator signifies exponentiation?

Accepted Answer

A)  # 
B)  * 
C)  / 
D)  ^ 
A)  # 
B)  * 
C)  / 
D)  ^

Question 20

Which query wizard helps you build a crosstab query?

Accepted Answer

A)  Select Query Wizard 
B)  Crosstab Query Wizard 
C)  Simple Query Wizard 
D)  Find Aggregates Query Wizard 
A)  Select Query Wizard 
B)  Crosstab Query Wizard 
C)  Simple Query Wizard 
D)  Find Aggregates Query Wizard

-In the accompanying figure,how many fields will display on the resulting datasheet?

Describe the one-to-many relationships of the tables shown in the accompanying figure.

Syntax are tests,or limiting conditions,that must be true for a record to be selected for a datasheet in a query._________________________

Multiple criteria added to the same line of the query design grid means that each must be true for the record to appear in the datasheet.

When you open a query in Datasheet View,you run it.

In a query,the <> operator means not equal.

In SQL,the FROM keyword determines how records are sorted._________________________

Each criteria row of the query design grid is evaluated separately.

Access helps you with criteria syntax in the query design grid.

Sort orders defined in Query Design View are not saved with the query object.

Which function should you use to calculate today's current date?

The >= comparison operator means ____.

Discuss the use of the * wildcard character in query criteria.

When you create a summary query,which row is added to the query design grid?

The wildcard character that represents any combination of characters in query criteria is the ____.

Which aggregate function is used to find the number of values in a field?

Which aggregate function is used to find the total of values in a field?

The < comparison operator means ____.

Which arithmetic operator signifies exponentiation?

Which query wizard helps you build a crosstab query?

Word 2013 : Creating and Formatting Tables

Word 2013 : Illustrating Documents With Graphics

Word 2013 : Working With Themes and Building Blocks

Word 2013 : Merging Word Documents

Powerpoint 2013 : Working With Advanced Tools and Masters

Powerpoint 2013 : Enhancing Charts

Powerpoint 2013 : Inserting Graphics, Media, and Objects

Powerpoint 2013 : Using Advanced Features

Integration : Integrating Word and Excel

Integration : Integrating Word, Excel, and Access

Integration : Integrating Word, Excel, Access, and Powerpoint

Excel 2013 : Analyzing Data Using Formulas

Excel 2013 : Managing Workbook Data

Excel 2013 : Managing Data Using Tables

Excel 2013 : Analyzing Table Data

Access 2013 : Modifying the Database Structure

Access 2013 : Enhancing Forms

Access 2013 : Analyzing Data With Reports

Working in the Cloud

Filters

Exam 17: Access 2013 : Improving Queries

-In the accompanying figure,how many fields will display on the resulting datasheet?

Describe the one-to-many relationships of the tables shown in the accompanying figure.

Syntax are tests,or limiting conditions,that must be true for a record to be selected for a datasheet in a query._________________________

Multiple criteria added to the same line of the query design grid means that each must be true for the record to appear in the datasheet.

When you open a query in Datasheet View,you run it.

In a query,the <> operator means not equal.

In SQL,the FROM keyword determines how records are sorted._________________________

Each criteria row of the query design grid is evaluated separately.

Access helps you with criteria syntax in the query design grid.

Sort orders defined in Query Design View are not saved with the query object.

Which function should you use to calculate today's current date?

The >= comparison operator means ____.

Discuss the use of the * wildcard character in query criteria.

When you create a summary query,which row is added to the query design grid?

The wildcard character that represents any combination of characters in query criteria is the ____.

Which aggregate function is used to find the number of values in a field?

Which aggregate function is used to find the total of values in a field?

The < comparison operator means ____.

Which arithmetic operator signifies exponentiation?

Which query wizard helps you build a crosstab query?

Word 2013 : Creating and Formatting Tables

Word 2013 : Illustrating Documents With Graphics

Word 2013 : Working With Themes and Building Blocks

Word 2013 : Merging Word Documents

Powerpoint 2013 : Working With Advanced Tools and Masters

Powerpoint 2013 : Enhancing Charts

Powerpoint 2013 : Inserting Graphics, Media, and Objects

Powerpoint 2013 : Using Advanced Features

Integration : Integrating Word and Excel

Integration : Integrating Word, Excel, and Access

Integration : Integrating Word, Excel, Access, and Powerpoint

Excel 2013 : Analyzing Data Using Formulas

Excel 2013 : Managing Workbook Data

Excel 2013 : Managing Data Using Tables

Excel 2013 : Analyzing Table Data

Access 2013 : Modifying the Database Structure

Access 2013 : Enhancing Forms

Access 2013 : Analyzing Data With Reports

Working in the Cloud

Filters