Question 1

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 2

When you sort data in a query, the records in the underlying table are actually rearranged.

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)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 find all customers whose current due amount is greater than $1,000.00, enter ____ in the Criteria row of the Current Due column.

Accepted Answer

A)  > $1000 
B)  > 1000 
C)  > 1,000 
D)  > $1,000 
A)  > $1000 
B)  > 1000 
C)  > 1,000 
D)  > $1,000

Question 6

Match between columns
                        Premises: A mathematical operator for division.

Accepted Answer

The Answer of AND criterion and IN and Total and is...

Question 7

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 8

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 9

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 10

The ____________________ wildcard represents any collection of characters.

Accepted Answer

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

Question 11

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 12

You cannot create a report for a query.

Accepted Answer

A) True 
 B)False

Question 13

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 14

To order the records in the answer to a query in a particular way, you ____ the records.

Accepted Answer

A)  index 
B)  sort 
C)  arrange 
D)  list 
A)  index 
B)  sort 
C)  arrange 
D)  list

Question 15

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

Accepted Answer

The answer of ____________________ are symbols that represent any character...

Question 16

Modified Multiple Choice 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 17

Match between columns
                        Premises: Represents any collection of characters.

Accepted Answer

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

Question 18

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

Accepted Answer

A) True 
 B)False

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

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

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.

When you sort data in a query, the records in the underlying table are actually rearranged.

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

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

To find all customers whose current due amount is greater than $1,000.00, enter ____ in the Criteria row of the Current Due column.

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.

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 indicate grouping in Access, select ____ as the entry in the Total row for the field to be used for grouping.

The ____________________ wildcard represents any collection of characters.

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

You cannot create a report for a query.

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

To order the records in the answer to a query in a particular way, you ____ the records.

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

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

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

The arithmetic symbols for use in query calculations are ____.

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

Office 2013 and Windows 8: Essential Concepts and Skills

Office 365 Essentials

Databases and Database Objects: an Introduction

Maintaining a Database

Creating Reports and Forms

Multiple-Table Forms

Advanced Report Techniques

Filters

Exam 4: Querying a Database

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.

When you sort data in a query, the records in the underlying table are actually rearranged.

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

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

To find all customers whose current due amount is greater than $1,000.00, enter ____ in the Criteria row of the Current Due column.

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.

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 indicate grouping in Access, select ____ as the entry in the Total row for the field to be used for grouping.

The ____________________ wildcard represents any collection of characters.

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

You cannot create a report for a query.

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

To order the records in the answer to a query in a particular way, you ____ the records.

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

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

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

The arithmetic symbols for use in query calculations are ____.

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

Office 2013 and Windows 8: Essential Concepts and Skills

Office 365 Essentials

Databases and Database Objects: an Introduction

Maintaining a Database

Creating Reports and Forms

Multiple-Table Forms

Advanced Report Techniques

Filters