Question 1

To find all customers whose names begin with Sr,enter ____________________ as the criterion for the Customer Name field.

Accepted Answer

Sr*

Question 2

To omit duplicates from a query,use the property sheet and change the Unique Values property to ____.

Accepted Answer

A)  No 
B)  Yes 
C)  Off 
D)  On 
A)  No 
B)  Yes 
C)  Off 
D)  On B

Question 3

You can include ____ in calculations to indicate which calculation should be done first.

Accepted Answer

A)  curly braces { } 
B)  brackets [ ] 
C)  parentheses ( ) 
D)  slashes // 
A)  curly braces { } 
B)  brackets [ ] 
C)  parentheses ( ) 
D)  slashes // C

Question 4

To save a query,tap or click the Save button on the ____.

Accepted Answer

A)  status bar 
B)  Quick Access Toolbar 
C)  CREATE tab on the ribbon 
D)  HOME tab on the ribbon 
A)  status bar 
B)  Quick Access Toolbar 
C)  CREATE tab on the ribbon 
D)  HOME tab on the ribbon

Question 5

The type of join that finds records from both tables that have identical values in matching fields is called a(n)____________________ join.

Accepted Answer

The answer of The type of join that finds records...

Question 6

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 7

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

Accepted Answer

major
prim

Question 8

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

Question 9

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 10

If the criterion for Current Due field is 0,the query results for this query will display ____ in the Current Due field.

Accepted Answer

A)  0.00 
B)  $0 
C)  0 
D)  $0.00 
A)  0.00 
B)  $0 
C)  0 
D)  $0.00

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

To create a new query in Design view,tap or click CREATE on the ribbon to display the CREATE tab and then tap or click the ____ button to create a new query.

Accepted Answer

A)  Query 
B)  Design View 
C)  Query Design 
D)  Select Query 
A)  Query 
B)  Design View 
C)  Query Design 
D)  Select Query

Question 13

-In the accompanying figure,the Customer table was added to the query by selecting the table and tapping or clicking the Add button in the ____ dialog box.

Accepted Answer

A)  Show Table 
B)  Add Table 
C)  Select Table 
D)  Field List 
A)  Show Table 
B)  Add Table 
C)  Select Table 
D)  Field List

Question 14

Case 2-2
Bavant Publishing needs to find the book reps whose start date is earlier than 1/1/2013.
-The caption for the Start Date field should be Started when the query results display.How can Bavant change the caption?

Accepted Answer

Click the Start Date field in the design

Question 15

-The accompanying figure illustrates using a query to ____ tables;that is,to find records in two tables that have identical values in matching fields.

Accepted Answer

A)  combine 
B)  concatenate 
C)  interleave 
D)  join 
A)  combine 
B)  concatenate 
C)  interleave 
D)  join

Question 16

A(n)____________________ function is a function that performs some mathematical function against a group of records.

Accepted Answer

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

Question 17

The ____ operator allows you to search for a range of values in one field.

Accepted Answer

A)  BETWEEN 
B)  RANGE 
C)  IN 
D)  SEARCH 
A)  BETWEEN 
B)  RANGE 
C)  IN 
D)  SEARCH

Question 18

To enter a number in a criterion,type the number without any dollar signs or commas.

Accepted Answer

A) True 
 B)False

Question 19

The ____________________ wildcard represents any collection of characters.

Accepted Answer

The answer of The ____________________ wildcard represents any collection of...

Question 20

The question mark (?)wildcard represents any collection of characters.

Accepted Answer

A) True 
 B)False

To find all customers whose names begin with Sr,enter ____________________ as the criterion for the Customer Name field.

To omit duplicates from a query,use the property sheet and change the Unique Values property to ____.

You can include ____ in calculations to indicate which calculation should be done first.

To save a query,tap or click the Save button on the ____.

The type of join that finds records from both tables that have identical values in matching fields is called a(n)____________________ join.

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

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

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.

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

If the criterion for Current Due field is 0,the query results for this query will display ____ in the Current Due field.

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

To create a new query in Design view,tap or click CREATE on the ribbon to display the CREATE tab and then tap or click the ____ button to create a new query.

-In the accompanying figure,the Customer table was added to the query by selecting the table and tapping or clicking the Add button in the ____ dialog box.

Case 2-2 Bavant Publishing needs to find the book reps whose start date is earlier than 1/1/2013. -The caption for the Start Date field should be Started when the query results display.How can Bavant change the caption?

-The accompanying figure illustrates using a query to ____ tables;that is,to find records in two tables that have identical values in matching fields.

A(n)____________________ function is a function that performs some mathematical function against a group of records.

The ____ operator allows you to search for a range of values in one field.

To enter a number in a criterion,type the number without any dollar signs or commas.

The ____________________ wildcard represents any collection of characters.

The question mark (?)wildcard represents any collection of characters.

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

To find all customers whose names begin with Sr,enter ____________________ as the criterion for the Customer Name field.

To omit duplicates from a query,use the property sheet and change the Unique Values property to ____.

You can include ____ in calculations to indicate which calculation should be done first.

To save a query,tap or click the Save button on the ____.

The type of join that finds records from both tables that have identical values in matching fields is called a(n)____________________ join.

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

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

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.

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

If the criterion for Current Due field is 0,the query results for this query will display ____ in the Current Due field.

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

To create a new query in Design view,tap or click CREATE on the ribbon to display the CREATE tab and then tap or click the ____ button to create a new query.

-In the accompanying figure,the Customer table was added to the query by selecting the table and tapping or clicking the Add button in the ____ dialog box.

Case 2-2 Bavant Publishing needs to find the book reps whose start date is earlier than 1/1/2013. -The caption for the Start Date field should be Started when the query results display.How can Bavant change the caption?

-The accompanying figure illustrates using a query to ____ tables;that is,to find records in two tables that have identical values in matching fields.

A(n)____________________ function is a function that performs some mathematical function against a group of records.

The ____ operator allows you to search for a range of values in one field.

To enter a number in a criterion,type the number without any dollar signs or commas.

The ____________________ wildcard represents any collection of characters.

The question mark (?)wildcard represents any collection of characters.

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