Question 1

Figure 2-1 In the accompanying figure, you can remove a column by clicking just above the field name to select the column and then clicking the ____ key(s).

Accepted Answer

A) CTRL + DELETE 
B) CTRL + Y 
C) DELETE 
D) CTRL+ALT

Question 2

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

Accepted Answer

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

Question 3

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

Accepted Answer

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

Question 4

To include calculated fields in queries, enter a name for the calculated field, a(n)_____, and then the expression in one of the columns in the Field row.

Accepted Answer

A) colon (:) 
B) semi-colon (:) 
C) equal sign (=) 
D) exclamation point (!)

Question 5

To save a query, the query design must appear on the screen.

Accepted Answer

A) True 
 B)False

Question 6

To include the Total row in the design grid, click the _____ button on the Design tab.

Accepted Answer

A) Aggregate 
B) Statistics 
C) Calculations 
D) Totals

Question 7

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

Accepted Answer

The answer of When you create a query, you should...

Exam 4: Access: Querying a Database

Figure 2-1 In the accompanying figure, you can remove a column by clicking just above the field name to select the column and then clicking the ____ key(s) .

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

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

To include calculated fields in queries, enter a name for the calculated field, a(n) _____, and then the expression in one of the columns in the Field row.

To save a query, the query design must appear on the screen.

To include the Total row in the design grid, click the _____ button on the Design tab.

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