Question 1

When you enter text data in a criterion,you must enclose the text in quotation marks.

Accepted Answer

A) True 
 B)False

Question 2

The field or fields on which records are sorted is called the sort key.

Accepted Answer

A) True 
 B)False

Question 3

To find all book reps whose start date is after 1/1/2013,use the ____________________ operator.

Accepted Answer

The answer of To find all book reps whose start...

Question 4

Identify the letter of the choice that best matches the phrase or definition.
-Each individual criterion must be true in order for the compound criterion to be true.

Accepted Answer

A) (*) 
B) (?) 
C) / 
D) Total 
E) AND criterion
F)NOT
G)BETWEEN
H)OR criterion
I)IN
J)FIRST 
A) (*) 
B) (?) 
C) / 
D) Total 
E) AND criterion
F)NOT
G)BETWEEN
H)OR criterion
I)IN
J)FIRST

Question 5

-In the accompanying figure,the ____ line between matching fields in the two tables indicates that the tables are related.

Accepted Answer

A)  infinity 
B)  join 
C)  connector 
D)  inner 
A)  infinity 
B)  join 
C)  connector 
D)  inner

Question 6

In fixed-width files,each record is on a separate line and the fields are separated by a special character.

Accepted Answer

A) True 
 B)False

Question 7

The arithmetic symbols for use in query calculations are ____.

Accepted Answer

A)  asterisk (*) 
B)  ampersand (&) 
C)  slash (/) 
D)  question mark (?) 
A)  asterisk (*) 
B)  ampersand (&) 
C)  slash (/) 
D)  question mark (?)

Question 8

A crosstab query calculates a statistic for data that is grouped by two different types of information.____________________

Accepted Answer

A) True 
 B)False

Question 9

When you sort data in a query,the records in the underlying table are actually rearranged.

Accepted Answer

A) True 
 B)False

Question 10

The only calculated fields you can create in Access are those involving addition and subtraction.

Accepted Answer

A) True 
 B)False

Question 11

-In the accompanying figure,Book Rep Number is the ____ key.

Accepted Answer

A)  major 
B)  minor 
C)  primary sort 
D)  secondary sort 
A)  major 
B)  minor 
C)  primary sort 
D)  secondary sort

Question 12

To combine criteria with ____________________,each criterion must go on separate rows in the Criteria area of the grid.

Accepted Answer

The answer of To combine criteria with ____________________,each criterion must...

Question 13

Identify the letter of the choice that best matches the phrase or definition.
-A mathematical operator for division.

Accepted Answer

A) (*) 
B) (?) 
C) / 
D) Total 
E) AND criterion
F)NOT
G)BETWEEN
H)OR criterion
I)IN
J)FIRST 
A) (*) 
B) (?) 
C) / 
D) Total 
E) AND criterion
F)NOT
G)BETWEEN
H)OR criterion
I)IN
J)FIRST

Question 14

To use the Report Wizard to create a report for a query,select the query in the Navigation Pane,tap or click ____ on the ribbon,and then tap or click the Report Wizard button.

Accepted Answer

A)  CREATE 
B)  DATABASE TOOLS 
C)  REPORT 
D)  FILE 
A)  CREATE 
B)  DATABASE TOOLS 
C)  REPORT 
D)  FILE

Question 15

To view the results of a query,open it by pressing and holding or right-clicking the query in the Navigation Pane and tapping or clicking ____ on the shortcut menu.

Accepted Answer

A)  Datasheet View 
B)  Design View 
C)  Open 
D)  Run 
A)  Datasheet View 
B)  Design View 
C)  Open 
D)  Run

Question 16

To use the Expression Builder to create a calculated field,select the column in the Field row,right-click to display the shortcut menu,and then click ____.

Accepted Answer

A)  Expression Builder 
B)  Builder box 
C)  Build 
D)  Field Builder 
A)  Expression Builder 
B)  Builder box 
C)  Build 
D)  Field Builder

Question 17

To find all customers whose current due amount is greater than $1,000.00,enter ____ in the Criteria row of the Current Due column.

Accepted Answer

A)  > $1000 
B)  > 1000 
C)  > 1,000 
D)  > $1,000 
A)  > $1000 
B)  > 1000 
C)  > 1,000 
D)  > $1,000

Question 18

If a Security Warning appears when you open an Access database,tap or click the ____________________ button.

Accepted Answer

The answer of If a Security Warning appears when you...

Question 19

To quit Access,click the ____ button on the right side of the Access title bar.

Accepted Answer

A)  Quit 
B)  Close 
C)  Stop 
D)  Exit 
A)  Quit 
B)  Close 
C)  Stop 
D)  Exit

Question 20

To include all fields for a table in the design grid,double-tap or double-click the ____________________ in the field list.

Accepted Answer

The answer of To include all fields for a table...

When you enter text data in a criterion,you must enclose the text in quotation marks.

The field or fields on which records are sorted is called the sort key.

To find all book reps whose start date is after 1/1/2013,use the ____________________ operator.

Identify the letter of the choice that best matches the phrase or definition. -Each individual criterion must be true in order for the compound criterion to be true.

-In the accompanying figure,the ____ line between matching fields in the two tables indicates that the tables are related.

In fixed-width files,each record is on a separate line and the fields are separated by a special character.

The arithmetic symbols for use in query calculations are ____.

A crosstab query calculates a statistic for data that is grouped by two different types of information.____________________

When you sort data in a query,the records in the underlying table are actually rearranged.

The only calculated fields you can create in Access are those involving addition and subtraction.

-In the accompanying figure,Book Rep Number is the ____ key.

To combine criteria with ____________________,each criterion must go on separate rows in the Criteria area of the grid.

Identify the letter of the choice that best matches the phrase or definition. -A mathematical operator for division.

To use the Report Wizard to create a report for a query,select the query in the Navigation Pane,tap or click ____ on the ribbon,and then tap or click the Report Wizard button.

To view the results of a query,open it by pressing and holding or right-clicking the query in the Navigation Pane and tapping or clicking ____ on the shortcut menu.

To use the Expression Builder to create a calculated field,select the column in the Field row,right-click to display the shortcut menu,and then click ____.

To find all customers whose current due amount is greater than $1,000.00,enter ____ in the Criteria row of the Current Due column.

If a Security Warning appears when you open an Access database,tap or click the ____________________ button.

To quit Access,click the ____ button on the right side of the Access title bar.

To include all fields for a table in the design grid,double-tap or double-click the ____________________ in the field list.

Word: Creating, Formatting, and Editing a Word Document With a Picture

Word: Creating a Research Paper With References and Sources

Word: Creating a Business Letter With a Letterhead and Table

Powerpoint: Creating and Editing a Presentation With Pictures

Powerpoint: Enhancing a Presentation With Pictures, Shapes, and Wordart

Powerpoint: Reusing a Presentation and Adding Media and Animation

Outlook: Managing Email Messages With Outlook

Outlook: Managing Calendars With Outlook

Office 2013 and Windows 8: Essential Concepts and Skills

Office 365 Essentials

Introduction to Technology

Excel: Creating a Worksheet and a Chart

Excel: Formulas, Functions, and Formatting

Excel: Working With Large Worksheets, Charting, and What-If Analysis

Access: Databases and Database Objects: an Introduction

Access: Maintaining a Database

Filters

Exam 16: Access: Querying a Database

When you enter text data in a criterion,you must enclose the text in quotation marks.

The field or fields on which records are sorted is called the sort key.

To find all book reps whose start date is after 1/1/2013,use the ____________________ operator.

Identify the letter of the choice that best matches the phrase or definition. -Each individual criterion must be true in order for the compound criterion to be true.

-In the accompanying figure,the ____ line between matching fields in the two tables indicates that the tables are related.

In fixed-width files,each record is on a separate line and the fields are separated by a special character.

The arithmetic symbols for use in query calculations are ____.

A crosstab query calculates a statistic for data that is grouped by two different types of information.____________________

When you sort data in a query,the records in the underlying table are actually rearranged.

The only calculated fields you can create in Access are those involving addition and subtraction.

-In the accompanying figure,Book Rep Number is the ____ key.

To combine criteria with ____________________,each criterion must go on separate rows in the Criteria area of the grid.

Identify the letter of the choice that best matches the phrase or definition. -A mathematical operator for division.

To use the Report Wizard to create a report for a query,select the query in the Navigation Pane,tap or click ____ on the ribbon,and then tap or click the Report Wizard button.

To view the results of a query,open it by pressing and holding or right-clicking the query in the Navigation Pane and tapping or clicking ____ on the shortcut menu.

To use the Expression Builder to create a calculated field,select the column in the Field row,right-click to display the shortcut menu,and then click ____.

To find all customers whose current due amount is greater than $1,000.00,enter ____ in the Criteria row of the Current Due column.

If a Security Warning appears when you open an Access database,tap or click the ____________________ button.

To quit Access,click the ____ button on the right side of the Access title bar.

To include all fields for a table in the design grid,double-tap or double-click the ____________________ in the field list.

Word: Creating, Formatting, and Editing a Word Document With a Picture

Word: Creating a Research Paper With References and Sources

Word: Creating a Business Letter With a Letterhead and Table

Powerpoint: Creating and Editing a Presentation With Pictures

Powerpoint: Enhancing a Presentation With Pictures, Shapes, and Wordart

Powerpoint: Reusing a Presentation and Adding Media and Animation

Outlook: Managing Email Messages With Outlook

Outlook: Managing Calendars With Outlook

Office 2013 and Windows 8: Essential Concepts and Skills

Office 365 Essentials

Introduction to Technology

Excel: Creating a Worksheet and a Chart

Excel: Formulas, Functions, and Formatting

Excel: Working With Large Worksheets, Charting, and What-If Analysis

Access: Databases and Database Objects: an Introduction

Access: Maintaining a Database

Filters