Question 1

The ____________________ wildcard represents any individual character.

Accepted Answer

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

Question 2

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 3

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

Accepted Answer

A) True 
 B)False

Question 4

In the accompanying figure, Book Rep Number is the ____ key.

Accepted Answer

A)  major 
B)  minor 
C)  primary sort 
D)  secondary sort 
A)  major 
B)  minor 
C)  primary sort 
D)  secondary sort

Question 5

In the accompanying figure, you can enter CSU10 in the ____ row of the Customer Number field to find all customers whose customer number is CSU10.

Accepted Answer

A)  Sort 
B)  Show 
C)  or 
D)  Criteria 
A)  Sort 
B)  Show 
C)  or 
D)  Criteria

Question 6

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

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

Explain the difference between an inner join and an outer join.

Accepted Answer

An inner join is a join that finds recor

Question 9

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 10

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

Accepted Answer

A) True 
 B)False

Question 11

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 12

To include all fields for a table in the design grid, double-tap or double-click the ____________________ in the field list.

Accepted Answer

The answer of To include all fields for a table...

The ____________________ wildcard represents any individual character.

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.

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

In the accompanying figure, Book Rep Number is the ____ key.

In the accompanying figure, you can enter CSU10 in the ____ row of the Customer Number field to find all customers whose customer number is CSU10.

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

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

Explain the difference between an inner join and an outer join.

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

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

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 include all fields for a table in the design grid, double-tap or double-click the ____________________ in the field list.

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

The ____________________ wildcard represents any individual character.

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.

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

In the accompanying figure, Book Rep Number is the ____ key.

In the accompanying figure, you can enter CSU10 in the ____ row of the Customer Number field to find all customers whose customer number is CSU10.

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

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

Explain the difference between an inner join and an outer join.

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

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

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 include all fields for a table in the design grid, double-tap or double-click the ____________________ in the field list.

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