Question 1

The ____________________ wildcard represents any individual character.

Accepted Answer

question mark,?

Question 2

You can export data from Access to the standard Word format.

Accepted Answer

A) True 
 B)False  False

Question 3

When you sort data, duplicates are not included.

Accepted Answer

A) True 
 B)False  False

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

To show the Navigation Pane if it is hidden, click the ____ Button.

Accepted Answer

A)  Show 
B)  Shutter Bar Open/Close 
C)  Restore 
D)  Show/Hide 
A)  Show 
B)  Shutter Bar Open/Close 
C)  Restore 
D)  Show/Hide

Question 6

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

Accepted Answer

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

Question 7

To enter a criterion for a particular field without displaying the field in the results of the query, include the field in the design grid, enter the criterion, and remove the check mark from its Show check box.

Accepted Answer

A) True 
 B)False

Question 8

A summary function is a function that performs some mathematical function against a group of records. ____________________

Accepted Answer

A) True 
 B)False

Question 9

To view the results of a query, right-click the query in the Navigation Pane and then 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 10

To view the results of a query, open it by right-clicking the query in the Navigation Pane and 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 11

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

Accepted Answer

A) True 
 B)False

Question 12

Critical Thinking Questions 
Case 2-2 
PrattLast Associates needs to find the account managers whose start date is earlier than 1/1/2015. 
What criteria should PrattLast enter in the Start Date column of the design grid?

Accepted Answer

The answer of Critical Thinking Questions 
Case 2-2 
PrattLast Associates...

Question 13

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 14

To change the design of a query that is not currently open, right-click the query and then 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 15

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

Accepted Answer

A) True 
 B)False

Question 16

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 17

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

Accepted Answer

A) True 
 B)False

Question 18

Wildcards are symbols that represent any character or combination of characters. ____________________

Accepted Answer

A) True 
 B)False

Question 19

To include calculated fields in queries, enter a name for the calculated field, a(n) ____, and then the expression in one of the columns in the Field row.

Accepted Answer

A)  colon (:) 
B)  semi-colon (;) 
C)  equal sign (=) 
D)  exclamation point (!) 
A)  colon (:) 
B)  semi-colon (;) 
C)  equal sign (=) 
D)  exclamation point (!)

Question 20

To change the caption for a field in a query, click the field in the design grid, click the ____ button on the Design tab, click the Caption box, and enter the new caption.

Accepted Answer

A)  Caption 
B)  Property Sheet 
C)  Field Name 
D)  Format 
A)  Caption 
B)  Property Sheet 
C)  Field Name 
D)  Format

The ____________________ wildcard represents any individual character.

You can export data from Access to the standard Word format.

When you sort data, duplicates are not included.

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

To show the Navigation Pane if it is hidden, click the ____ Button.

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

To enter a criterion for a particular field without displaying the field in the results of the query, include the field in the design grid, enter the criterion, and remove the check mark from its Show check box.

A summary function is a function that performs some mathematical function against a group of records. ____________________

To view the results of a query, right-click the query in the Navigation Pane and then click ____ on the shortcut menu.

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

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

Critical Thinking Questions Case 2-2 PrattLast Associates needs to find the account managers whose start date is earlier than 1/1/2015. What criteria should PrattLast enter in the Start Date column of the design grid?

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

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

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

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

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

Wildcards are symbols that represent any character or combination of characters. ____________________

To include calculated fields in queries, enter a name for the calculated field, a(n) ____, and then the expression in one of the columns in the Field row.

To change the caption for a field in a query, click the field in the design grid, click the ____ button on the Design tab, click the Caption box, and enter the new caption.

Access 1 Databases and Database Objects: an Introduction

Excel 1 Creating a Worksheet and a Chart

Excel 2 Formulas, Functions, and Formatting

Ppt 1 Creating and Editing a Presentation With Pictures

Ppt 2 Enhancing a Presentation With Pictures, Shapes, and Wordart

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

Word 2 Creating a Research Paper With References and Sources

Office 2016 and Windows 10: Essential Concepts and Skills

Productivity Apps for School and Work

Filters

Exam 2: Access 2 Querying a Database

The ____________________ wildcard represents any individual character.

You can export data from Access to the standard Word format.

When you sort data, duplicates are not included.

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

To show the Navigation Pane if it is hidden, click the ____ Button.

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

To enter a criterion for a particular field without displaying the field in the results of the query, include the field in the design grid, enter the criterion, and remove the check mark from its Show check box.

A summary function is a function that performs some mathematical function against a group of records. ____________________

To view the results of a query, right-click the query in the Navigation Pane and then click ____ on the shortcut menu.

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

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

Critical Thinking Questions Case 2-2 PrattLast Associates needs to find the account managers whose start date is earlier than 1/1/2015. What criteria should PrattLast enter in the Start Date column of the design grid?

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

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

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

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

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

Wildcards are symbols that represent any character or combination of characters. ____________________

To include calculated fields in queries, enter a name for the calculated field, a(n) ____, and then the expression in one of the columns in the Field row.

To change the caption for a field in a query, click the field in the design grid, click the ____ button on the Design tab, click the Caption box, and enter the new caption.

Access 1 Databases and Database Objects: an Introduction

Excel 1 Creating a Worksheet and a Chart

Excel 2 Formulas, Functions, and Formatting

Ppt 1 Creating and Editing a Presentation With Pictures

Ppt 2 Enhancing a Presentation With Pictures, Shapes, and Wordart

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

Word 2 Creating a Research Paper With References and Sources

Office 2016 and Windows 10: Essential Concepts and Skills

Productivity Apps for School and Work

Filters