Question 1

To sort records in a query, specify the sort order in the ____ row of the design grid below the field that is the sort key.

Accepted Answer

A)  Show 
B)  List 
C)  Sort 
D)  Order 
A)  Show 
B)  List 
C)  Sort 
D)  Order

Question 2

Match between columns
                        Premises: Represents any individual character.

Accepted Answer

The Answer of AND criterion and (?) and NOT and is...

Question 3

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

Accepted Answer

The answer of To change the design of a query...

Question 4

The asterisk (*) wildcard represents any collection of characters.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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 7

The results of a query display in ____________________ view.

Accepted Answer

The answer of The results of a query display in...

Question 8

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 9

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

Accepted Answer

A) True 
 B)False

Question 10

Match between columns
                        Premises: A comparison operator.

Accepted Answer

The Answer of NOT and IN and FIRST and (?) is...

Question 11

The expression for a calculated field can be typed directly into the Field row.

Accepted Answer

A) True 
 B)False

Question 12

A(n) ____________________ query is a query that prompts for input whenever it is used.

Accepted Answer

The answer of A(n) ____________________ query is a query that...

Question 13

Which aggregate function will find the customer with the largest amount paid?

Accepted Answer

The answer of Which aggregate function will find the customer...

Question 14

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 15

To find all customers whose returns are greater than $0.00 and whose book rep is book rep number 42, enter each criterion on the same row.

Accepted Answer

A) True 
 B)False

Question 16

To display the entire entry for a calculated field, select the column in the Field row, right-click to display the shortcut menu, and then click ____.

Accepted Answer

A)  Enlarge 
B)  Resize 
C)  Magnify 
D)  Zoom 
A)  Enlarge 
B)  Resize 
C)  Magnify 
D)  Zoom

Question 17

The ____________________ function finds the smallest value in a group of records.

Accepted Answer

The answer of The ____________________ function finds the smallest value...

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

To use a parameter query, press and hold or right-click the query in the Navigation Pane and then tap or click ____ on the shortcut menu.

Accepted Answer

A)  Use Parameter 
B)  Enter Values 
C)  Open 
D)  Run 
A)  Use Parameter 
B)  Enter Values 
C)  Open 
D)  Run

Question 20

To sort records by amount paid within book rep number, specify Book Rep Number as the ____________________ key.

Accepted Answer

The answer of To sort records by amount paid within...

To sort records in a query, specify the sort order in the ____ row of the design grid below the field that is the sort key.

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

The asterisk (*) wildcard represents any collection of characters.

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

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 ____.

The results of a query display in ____________________ view.

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.

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

The expression for a calculated field can be typed directly into the Field row.

A(n) ____________________ query is a query that prompts for input whenever it is used.

Which aggregate function will find the customer with the largest amount paid?

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 find all customers whose returns are greater than $0.00 and whose book rep is book rep number 42, enter each criterion on the same row.

To display the entire entry for a calculated field, select the column in the Field row, right-click to display the shortcut menu, and then click ____.

The ____________________ function finds the smallest value in a group of records.

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

To use a parameter query, press and hold or right-click the query in the Navigation Pane and then tap or click ____ on the shortcut menu.

To sort records by amount paid within book rep number, specify Book Rep Number as the ____________________ key.

Office 2013 and Windows 8 Essential Concepts and Skills

Digital Literacy: Introducing a World of Technology

The Internet: Accessing, Searching, Sharing, and Communicating

Computers and Mobile Devices: Evaluating the Possibilities

Programs and Apps: Using Software at Work, School, and Home

Digital Safety and Security: Identifying Threats, Issues, and Defenses

Access: Databases and Database Objects: an Introduction

Excel: Creating a Worksheet and a Chart

Excel: Formulas, Functions, and Formatting

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

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

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

Filters

Exam 8: Access: Querying a Database

To sort records in a query, specify the sort order in the ____ row of the design grid below the field that is the sort key.

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

The asterisk (*) wildcard represents any collection of characters.

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

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 ____.

The results of a query display in ____________________ view.

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.

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

The expression for a calculated field can be typed directly into the Field row.

A(n) ____________________ query is a query that prompts for input whenever it is used.

Which aggregate function will find the customer with the largest amount paid?

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 find all customers whose returns are greater than $0.00 and whose book rep is book rep number 42, enter each criterion on the same row.

To display the entire entry for a calculated field, select the column in the Field row, right-click to display the shortcut menu, and then click ____.

The ____________________ function finds the smallest value in a group of records.

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

To use a parameter query, press and hold or right-click the query in the Navigation Pane and then tap or click ____ on the shortcut menu.

To sort records by amount paid within book rep number, specify Book Rep Number as the ____________________ key.

Office 2013 and Windows 8 Essential Concepts and Skills

Digital Literacy: Introducing a World of Technology

The Internet: Accessing, Searching, Sharing, and Communicating

Computers and Mobile Devices: Evaluating the Possibilities

Programs and Apps: Using Software at Work, School, and Home

Digital Safety and Security: Identifying Threats, Issues, and Defenses

Access: Databases and Database Objects: an Introduction

Excel: Creating a Worksheet and a Chart

Excel: Formulas, Functions, and Formatting

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

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

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

Filters