Question 1

In the accompanying figure, you can enter BC76 in the ____ row of the Client Number field to find all clients whose client number is BC7
6)

Accepted Answer

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

Question 2

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 3

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

Accepted Answer

A) True 
 B)False

Question 4

In the accompanying figure, the criterion for Current Due is 0. To find all clients whose current due amount is $2,000.00, erase the 0 in the Current Due column and enter _____ in the Criteria row of the Amount Paid column.

Accepted Answer

A)  =2,000 
B)  2,000 
C)  =$2,000 
D)  2000 
A)  =2,000 
B)  2,000 
C)  =$2,000 
D)  2000

Question 5

Less than ( ), and NOT (not equal to) are examples of _____.

Accepted Answer

A)  compound conditions 
B)  comparison operators 
C)  compound values 
D)  conditions 
A)  compound conditions 
B)  comparison operators 
C)  compound values 
D)  conditions

Question 6

The ____________________ is an Access tool that helps you create complex expressions.

Accepted Answer

The answer of The ____________________ is an Access tool that...

Question 7

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 8

Which aggregate function will find the client with the smallest amount paid?

Accepted Answer

The answer of Which aggregate function will find the client...

Question 9

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 10

If a Security Warning appears when you open an Access database, click the option ____________________ button.

Accepted Answer

The answer of If a Security Warning appears when you...

Question 11

The ____________________ wildcard represents any collection of characters.

Accepted Answer

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

Question 12

When you create a query, you should follow some general guidelines for query design. What are these six guidelines?

Accepted Answer

1. Identify the fields. 
2. Identify res

In the accompanying figure, you can enter BC76 in the ____ row of the Client Number field to find all clients whose client number is BC7 6)

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

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

In the accompanying figure, the criterion for Current Due is 0. To find all clients whose current due amount is $2,000.00, erase the 0 in the Current Due column and enter _____ in the Criteria row of the Amount Paid column.

Less than ( ), and NOT (not equal to) are examples of _____.

The ____________________ is an Access tool that helps you create complex expressions.

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

Which aggregate function will find the client with the smallest amount paid?

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

If a Security Warning appears when you open an Access database, click the option ____________________ button.

The ____________________ wildcard represents any collection of characters.

When you create a query, you should follow some general guidelines for query design. What are these six guidelines?

Office 2010 and Windows 7 Essential Concepts and Skills

Databases and Database Objects: an Introduction

Maintaining a Database

Creating Reports and Forms

Multitable Forms

Advanced Report Techniques

Using SQL

Advanced Form Techniques

Macros, Navigation Forms, Pivot

Administering a Database Syste

Database Design

Filters

Exam 3: Querying a Database

In the accompanying figure, you can enter BC76 in the ____ row of the Client Number field to find all clients whose client number is BC7 6)

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

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

In the accompanying figure, the criterion for Current Due is 0. To find all clients whose current due amount is $2,000.00, erase the 0 in the Current Due column and enter _____ in the Criteria row of the Amount Paid column.

Less than ( ), and NOT (not equal to) are examples of _____.

The ____________________ is an Access tool that helps you create complex expressions.

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

Which aggregate function will find the client with the smallest amount paid?

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

If a Security Warning appears when you open an Access database, click the option ____________________ button.

The ____________________ wildcard represents any collection of characters.

When you create a query, you should follow some general guidelines for query design. What are these six guidelines?

Office 2010 and Windows 7 Essential Concepts and Skills

Databases and Database Objects: an Introduction

Maintaining a Database

Creating Reports and Forms

Multitable Forms

Advanced Report Techniques

Using SQL

Advanced Form Techniques

Macros, Navigation Forms, Pivot

Administering a Database Syste

Database Design

Filters