Question 1

The Find ____________________ Query Wizard is used to determine whether a table contains duplicate values in one or more fields.

Accepted Answer

The answer of The Find ____________________ Query Wizard is used...

Question 2

Which operator signifies exponentiation?

Accepted Answer

A) # 
B) * 
C) / 
D) ^ 
A) # 
B) * 
C) / 
D) ^

Question 3

In the query above, what are the names of the tables are involved in the query?

Accepted Answer

One table is involve

Question 4

In the figure above, item 2 refers to a(n)____.

Accepted Answer

A) Field list 
B) One-to-many link line 
C) Query design grid 
D) Show Table window 
A) Field list 
B) One-to-many link line 
C) Query design grid 
D) Show Table window

Question 5

Which function would you use to calculate today's current date?

Accepted Answer

A) CURRENT 
B) DATE 
C) YEAR 
D) DAY 
A) CURRENT 
B) DATE 
C) YEAR 
D) DAY

Question 6

Queries evaluate sort orders from left to right .

Accepted Answer

A) True 
 B)False

Question 7

You decide to search for all last names beginning with the letter M in the query shown above. Describe how to do this.

Accepted Answer

In the query design grid, ente

Question 8

In the figure above, item 3 points to the ____.

Accepted Answer

A) field from the Payments table 
B) field from the Tours table 
C) Payments field list 
D) Sales field list 
A) field from the Payments table 
B) field from the Tours table 
C) Payments field list 
D) Sales field list

The Find ____________________ Query Wizard is used to determine whether a table contains duplicate values in one or more fields.

Which operator signifies exponentiation?

In the query above, what are the names of the tables are involved in the query?

In the figure above, item 2 refers to a(n)____.

Which function would you use to calculate today's current date?

Queries evaluate sort orders from left to right .

You decide to search for all last names beginning with the letter M in the query shown above. Describe how to do this.

In the figure above, item 3 points to the ____.

Getting Started With Microsoft Office 2010 Question

Building and Using Queries

Using Forms Question

Using Reports Question

Modifying the Database Structure Question

Enhancing Forms Question

Analyzing Data With Reports Question

Web Apps: Working With Windows Live and Office Web Apps

Getting Started With Access 2.0

Filters

Exam 6: Improving Queries Question

The Find ____________________ Query Wizard is used to determine whether a table contains duplicate values in one or more fields.

Which operator signifies exponentiation?

In the query above, what are the names of the tables are involved in the query?

In the figure above, item 2 refers to a(n)____.

Which function would you use to calculate today's current date?

Queries evaluate sort orders from left to right .

You decide to search for all last names beginning with the letter M in the query shown above. Describe how to do this.

In the figure above, item 3 points to the ____.

Getting Started With Microsoft Office 2010 Question

Building and Using Queries

Using Forms Question

Using Reports Question

Modifying the Database Structure Question

Enhancing Forms Question

Analyzing Data With Reports Question

Web Apps: Working With Windows Live and Office Web Apps

Getting Started With Access 2.0

Filters