Question 1

Unless you specify otherwise,Access assumes that the criteria you enter involve equality (exact matches).

Accepted Answer

A) True 
 B)False

Question 2

You cannot create a report for a query.

Accepted Answer

A) True 
 B)False

Question 3

A(n)____________________ is a window containing the various properties of the object.

Accepted Answer

The answer of A(n)____________________ is a window containing the various...

Question 4

To create a top-values query,use the Top Values box on the DESIGN tab to change the number of records to be included from All to the desired number.

Accepted Answer

A) True 
 B)False

Question 5

To combine criteria with ____________________,place the criteria on the same row.

Accepted Answer

The answer of To combine criteria with ____________________,place the criteria...

Question 6

To create a crosstab,click the ____ button on the CREATE tab.

Accepted Answer

A)  Crosstab Wizard 
B)  Query Wizard 
C)  Statistics 
D)  Chart 
A)  Crosstab Wizard 
B)  Query Wizard 
C)  Statistics 
D)  Chart

Question 7

To indicate grouping in Access,select ____ as the entry in the Total row for the field to be used for grouping.

Accepted Answer

A)  Like 
B)  Where 
C)  Same 
D)  Group By 
A)  Like 
B)  Where 
C)  Same 
D)  Group By

Question 8

A question that is asked of Access or any other database management system is called a(n)____________________.

Accepted Answer

The answer of A question that is asked of Access...

Question 9

A property sheet is a window containing the various properties of the object.

Accepted Answer

A) True 
 B)False

Question 10

-In the accompanying figure,press and hold or right-click the join line and tap or click ____ on the shortcut menu to display the Join Properties dialog box.

Accepted Answer

A)  Properties 
B)  Join Properties 
C)  Property Sheet 
D)  Modify Properties 
A)  Properties 
B)  Join Properties 
C)  Property Sheet 
D)  Modify Properties

Question 11

If you specify more than one sort key,the sort key on the left will be the major sort key and the one on the right will be the minor sort key.

Accepted Answer

A) True 
 B)False

Question 12

To create a parameter query that will prompt users to enter a city name as input,place [Enter City] as the criterion in the City field.

Accepted Answer

A) True 
 B)False

Question 13

Identify the letter of the choice that best matches the phrase or definition.
-Represents any collection of characters.

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 print the results of a query that is open,tap or click FILE on the ribbon,tap or click the ____ tab in the Backstage view,and then tap or click Quick Print.

Accepted Answer

A)  Preview 
B)  Query 
C)  Print Query 
D)  Print 
A)  Preview 
B)  Query 
C)  Print Query 
D)  Print

Question 15

Identify the letter of the choice that best matches the phrase or definition.
-A comparison operator.

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 16

-In the accompanying figure,Amount Paid is the ____ key.

Accepted Answer

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

Question 17

To change the design of a query that is not currently open,press and hold or right-click the query and then tap or click ____ on the shortcut menu.

Accepted Answer

A)  Datasheet View 
B)  Layout View 
C)  Change View 
D)  Design View 
A)  Datasheet View 
B)  Layout View 
C)  Change View 
D)  Design View

Question 18

Grouping means creating groups of records that share some common characteristic.

Accepted Answer

A) True 
 B)False

Question 19

A query that prompts for input whenever it is run is a dialog query.

Accepted Answer

A) True 
 B)False

Question 20

Less than (),and NOT (not equal to)are examples of ____.

Accepted Answer

A)  compound conditions 
B)  comparison operators 
C)  compound values 
D)  conditions 
A)  compound conditions 
B)  comparison operators 
C)  compound values 
D)  conditions

Unless you specify otherwise,Access assumes that the criteria you enter involve equality (exact matches).

You cannot create a report for a query.

A(n)____________________ is a window containing the various properties of the object.

To create a top-values query,use the Top Values box on the DESIGN tab to change the number of records to be included from All to the desired number.

To combine criteria with ____________________,place the criteria on the same row.

To create a crosstab,click the ____ button on the CREATE tab.

To indicate grouping in Access,select ____ as the entry in the Total row for the field to be used for grouping.

A question that is asked of Access or any other database management system is called a(n)____________________.

A property sheet is a window containing the various properties of the object.

-In the accompanying figure,press and hold or right-click the join line and tap or click ____ on the shortcut menu to display the Join Properties dialog box.

If you specify more than one sort key,the sort key on the left will be the major sort key and the one on the right will be the minor sort key.

To create a parameter query that will prompt users to enter a city name as input,place [Enter City] as the criterion in the City field.

Identify the letter of the choice that best matches the phrase or definition. -Represents any collection of characters.

To print the results of a query that is open,tap or click FILE on the ribbon,tap or click the ____ tab in the Backstage view,and then tap or click Quick Print.

Identify the letter of the choice that best matches the phrase or definition. -A comparison operator.

-In the accompanying figure,Amount Paid is the ____ key.

To change the design of a query that is not currently open,press and hold or right-click the query and then tap or click ____ on the shortcut menu.

Grouping means creating groups of records that share some common characteristic.

A query that prompts for input whenever it is run is a dialog query.

Less than (<),greater than (>),and NOT (not equal to)are examples of ____.

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

Unless you specify otherwise,Access assumes that the criteria you enter involve equality (exact matches).

You cannot create a report for a query.

A(n)____________________ is a window containing the various properties of the object.

To create a top-values query,use the Top Values box on the DESIGN tab to change the number of records to be included from All to the desired number.

To combine criteria with ____________________,place the criteria on the same row.

To create a crosstab,click the ____ button on the CREATE tab.

To indicate grouping in Access,select ____ as the entry in the Total row for the field to be used for grouping.

A question that is asked of Access or any other database management system is called a(n)____________________.

A property sheet is a window containing the various properties of the object.

-In the accompanying figure,press and hold or right-click the join line and tap or click ____ on the shortcut menu to display the Join Properties dialog box.

If you specify more than one sort key,the sort key on the left will be the major sort key and the one on the right will be the minor sort key.

To create a parameter query that will prompt users to enter a city name as input,place [Enter City] as the criterion in the City field.

Identify the letter of the choice that best matches the phrase or definition. -Represents any collection of characters.

To print the results of a query that is open,tap or click FILE on the ribbon,tap or click the ____ tab in the Backstage view,and then tap or click Quick Print.

Identify the letter of the choice that best matches the phrase or definition. -A comparison operator.

-In the accompanying figure,Amount Paid is the ____ key.

To change the design of a query that is not currently open,press and hold or right-click the query and then tap or click ____ on the shortcut menu.

Grouping means creating groups of records that share some common characteristic.

A query that prompts for input whenever it is run is a dialog query.

Less than (<),greater than (>),and NOT (not equal to)are examples of ____.

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