Question 1

Sort orders defined in Query Design View are not saved with the query object.

Accepted Answer

A) True 
 B)False  False

Question 2

In the figure above, what is the primary key field of the Tours table?

Accepted Answer

A) TourNo 
B) Customers 
C) Sales 
D) Tours 
A) TourNo 
B) Customers 
C) Sales 
D) Tours A

Question 3

Multiple criteria added to the same line of the query design grid means that each must be true for the record to appear in the datasheet.

Accepted Answer

A) True 
 B)False  True

Question 4

The operator >= means ____.

Accepted Answer

A) Less than or greater than 
B) Within 
C) In 
D) Greater than or equal to 
A) Less than or greater than 
B) Within 
C) In 
D) Greater than or equal to

Question 5

Deleting a field from the query design grid deletes it from the table that contains that field.

Accepted Answer

A) True 
 B)False

Question 6

When a query is saved, it saves VBA statements.

Accepted Answer

A) True 
 B)False

Question 7

OR queries narrow the number of records that will appear in the datasheet because a record must be true for all criteria.

Accepted Answer

A) True 
 B)False

Question 8

This aggregate function is used to find the total of values in a field.

Accepted Answer

A) Sum 
B) Sub 
C) Subtotal 
D) Total 
A) Sum 
B) Sub 
C) Subtotal 
D) Total

Question 9

In the query above, the criteria in the TourStartDate column would be considered OR criteria.

Accepted Answer

A) True 
 B)False

Question 10

Which type of query retrieves data from one or more linked tables and displays the results in a datasheet?

Accepted Answer

A) Common 
B) Select 
C) Linking 
D) Web 
A) Common 
B) Select 
C) Linking 
D) Web

Question 11

An SQL statement determines what fields are selected after the  ____ keyword.

Accepted Answer

A) SELECT 
B) FROM 
C) ORDER BY 
D) LIST 
A) SELECT 
B) FROM 
C) ORDER BY 
D) LIST

Question 12

The wildcard character that represents any combination of characters in criteria is the ____.

Accepted Answer

A) Asterisk (*) 
B) Exclamation point (!) 
C) Tilde (~) 
D) Question mark (?) 
A) Asterisk (*) 
B) Exclamation point (!) 
C) Tilde (~) 
D) Question mark (?)

Question 13

A select query can be used to develop summary calculations, such as the sum of the values in a field.

Accepted Answer

A) True 
 B)False

Question 14

A(n)____________________ query is used to calculate information about a group of records.

Accepted Answer

The answer of A(n)____________________ query is used to calculate information...

Question 15

A query can display fields from one or more tables in a relational database.

Accepted Answer

A) True 
 B)False

Question 16

If you change a customer name from "Miller" to "Millen" in a query's datasheet, you will need to make the update in any other query that also displays this customer's name.

Accepted Answer

A) True 
 B)False

Question 17

Each criteria row of the query design grid is evaluated separately.

Accepted Answer

A) True 
 B)False

Question 18

A summary query calculates statistics about ____.

Accepted Answer

A) One record 
B) Groups of records 
C) One field 
D) Groups of fields 
A) One record 
B) Groups of records 
C) One field 
D) Groups of fields

Question 19

Access helps you with criteria syntax in the query design grid.

Accepted Answer

A) True 
 B)False

Question 20

Queries allow you to specify more than one sort field in Query Design View.

Accepted Answer

A) True 
 B)False

Sort orders defined in Query Design View are not saved with the query object.

In the figure above, what is the primary key field of the Tours table?

Multiple criteria added to the same line of the query design grid means that each must be true for the record to appear in the datasheet.

The operator >= means ____.

Deleting a field from the query design grid deletes it from the table that contains that field.

When a query is saved, it saves VBA statements.

OR queries narrow the number of records that will appear in the datasheet because a record must be true for all criteria.

This aggregate function is used to find the total of values in a field.

In the query above, the criteria in the TourStartDate column would be considered OR criteria.

Which type of query retrieves data from one or more linked tables and displays the results in a datasheet?

An SQL statement determines what fields are selected after the ____ keyword.

The wildcard character that represents any combination of characters in criteria is the ____.

A select query can be used to develop summary calculations, such as the sum of the values in a field.

A(n)____________________ query is used to calculate information about a group of records.

A query can display fields from one or more tables in a relational database.

If you change a customer name from "Miller" to "Millen" in a query's datasheet, you will need to make the update in any other query that also displays this customer's name.

Each criteria row of the query design grid is evaluated separately.

A summary query calculates statistics about ____.

Access helps you with criteria syntax in the query design grid.

Queries allow you to specify more than one sort field in Query Design View.

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

Sort orders defined in Query Design View are not saved with the query object.

In the figure above, what is the primary key field of the Tours table?

Multiple criteria added to the same line of the query design grid means that each must be true for the record to appear in the datasheet.

The operator >= means ____.

Deleting a field from the query design grid deletes it from the table that contains that field.

When a query is saved, it saves VBA statements.

OR queries narrow the number of records that will appear in the datasheet because a record must be true for all criteria.

This aggregate function is used to find the total of values in a field.

In the query above, the criteria in the TourStartDate column would be considered OR criteria.

Which type of query retrieves data from one or more linked tables and displays the results in a datasheet?

An SQL statement determines what fields are selected after the ____ keyword.

The wildcard character that represents any combination of characters in criteria is the ____.

A select query can be used to develop summary calculations, such as the sum of the values in a field.

A(n)____________________ query is used to calculate information about a group of records.

A query can display fields from one or more tables in a relational database.

If you change a customer name from "Miller" to "Millen" in a query's datasheet, you will need to make the update in any other query that also displays this customer's name.

Each criteria row of the query design grid is evaluated separately.

A summary query calculates statistics about ____.

Access helps you with criteria syntax in the query design grid.

Queries allow you to specify more than one sort field in Query Design View.

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