Question 1

The ____________________ wildcard represents any individual character.

Accepted Answer

The answer of The ____________________ wildcard represents any individual character....

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

In ____________________ files,the width of any field is the same on every record.

Accepted Answer

The answer of In ____________________ files,the width of any field...

Question 4

To find the largest amount paid amount for a client,select ____ as the entry in the Total row for the Amount Paid column.

Accepted Answer

A) Large 
B) Maximum 
C) LGE 
D) MAX 
A) Large 
B) Maximum 
C) LGE 
D) MAX

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 restrict the objects that appear on the Navigation Pane use the Retrieval Bar.____________________

Accepted Answer

The answer of To restrict the objects that appear on...

Question 7

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 8

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 9

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

Accepted Answer

A) True 
 B)False

Question 10

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 11

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 12

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

Accepted Answer

A) True 
 B)False

Question 13

When you sort data,duplicates are not included.

Accepted Answer

A) True 
 B)False

Question 14

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 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

To organize entries in the Navigation Pane by table,click ____ on the Navigation Pane menu.

Accepted Answer

A) Objects by Table 
B) Table Object 
C) Tables and Related Views 
D) Default 
A) Objects by Table 
B) Table Object 
C) Tables and Related Views 
D) Default

Question 18

The special criteria that can be used in queries are ____.

Accepted Answer

A) AND 
B) INCLUSIVE 
C) BETWEEN 
D) IN 
A) AND 
B) INCLUSIVE 
C) BETWEEN 
D) IN

Question 19

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 20

-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

The ____________________ wildcard represents any individual character.

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

In ____________________ files,the width of any field is the same on every record.

To find the largest amount paid amount for a client,select ____ as the entry in the Total row for the Amount Paid column.

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

To restrict the objects that appear on the Navigation Pane use the Retrieval Bar.____________________

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.

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.

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

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

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

When you sort data,duplicates are not included.

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

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

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

To organize entries in the Navigation Pane by table,click ____ on the Navigation Pane menu.

The special criteria that can be used in queries are ____.

The arithmetic symbols for use in query calculations are ____.

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

Introduction to Technology

Office 365 Essentials

Office 2013 and Windows 8 Essential Concepts and Skills

Access: Databases and Database Objects: an Introduction

Access: Maintaining a Database

Excel: Creating a Worksheet and a Chart

Excel: Formulas, Functions, and Formatting

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

Outlook: Managing Email Messages With Outlook

Outlook: Managing Calendars With Outlook

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 5: Access: Querying a Database

The ____________________ wildcard represents any individual character.

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

In ____________________ files,the width of any field is the same on every record.

To find the largest amount paid amount for a client,select ____ as the entry in the Total row for the Amount Paid column.

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

To restrict the objects that appear on the Navigation Pane use the Retrieval Bar.____________________

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.

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.

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

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

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

When you sort data,duplicates are not included.

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

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

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

To organize entries in the Navigation Pane by table,click ____ on the Navigation Pane menu.

The special criteria that can be used in queries are ____.

The arithmetic symbols for use in query calculations are ____.

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

Introduction to Technology

Office 365 Essentials

Office 2013 and Windows 8 Essential Concepts and Skills

Access: Databases and Database Objects: an Introduction

Access: Maintaining a Database

Excel: Creating a Worksheet and a Chart

Excel: Formulas, Functions, and Formatting

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

Outlook: Managing Email Messages With Outlook

Outlook: Managing Calendars With Outlook

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