Question 1

Discuss the use of the * wildcard character in query criteria.

Accepted Answer

The wildcard character * is used to represent any character in a criteria entry.  It is often used with the Like operator.

Question 2

Which function should 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 B

Question 3

Which arithmetic operator signifies division?

Accepted Answer

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

Question 4

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 5

The > comparison operator means ____.

Accepted Answer

A)  greater than 
B)  greater than or equal to 
C)  less than 
D)  less than or equal to 
A)  greater than 
B)  greater than or equal to 
C)  less than 
D)  less than or equal to

Question 6

The wildcard character that represents one character in query 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 7

In Query Design View, you can drag the edge of a(n) field list to resize it.  _________________________

Accepted Answer

A) True 
 B)False

Question 8

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 9

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 10

When the comparison operator Null is used as criteria in the query design grid, the query finds records in which ____.

Accepted Answer

A)  the value is not equal to the text "Null" 
B)  the field value is equal to the text "Null" 
C)  any value has been entered for a field 
D)  no value has been entered for a field 
A)  the value is not equal to the text "Null" 
B)  the field value is equal to the text "Null" 
C)  any value has been entered for a field 
D)  no value has been entered for a field

Question 11

When a query is saved, it saves VBA statements.  _________________________

Accepted Answer

A) True 
 B)False

Question 12

Match between columns
                        Premises: A datasheet's records are placed in a determined order
An asterisk or question mark used in a query
A predefined Access formula that returns a value such as a subtotal or count
A combination of field names, operators and functions
A field of data that is created based on values of other fields
A statistic such as a subtotal or count is determined on a given field in a group of records

Accepted Answer

The Answer of Calculated field and Expression and Aggregate function is...

Question 13

In the query design grid, what characters surround text criteria?

Accepted Answer

A)  Pound signs (#) 
B)  Dollar signs ($) 
C)  Percent signs (%) 
D)  Quotation marks ("") 
A)  Pound signs (#) 
B)  Dollar signs ($) 
C)  Percent signs (%) 
D)  Quotation marks ("")

Question 14

You want to search for all last names beginning with the letter M. The field name for last name is LName. Describe how to do this.

Accepted Answer

In the query design grid, ente

Question 15

The Find ____ Query Wizard is used to find records in one table that do not have related records in another table.

Accepted Answer

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

Question 16

The ____ function returns the number of characters in a field.

Accepted Answer

The answer of The ____ function returns the number of...

Question 17

An SQL statement determines how the resulting records are sorted after the ____ keyword.

Accepted Answer

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

Question 18

Filtering refers to reordering records in either ascending or descending order based on the values in the field. _________________________

Accepted Answer

A) True 
 B)False

Question 19

Which function should you use to calculate the monthly payment on a loan?

Accepted Answer

A)  PMT 
B)  LOAN 
C)  PAY 
D)  RATE 
A)  PMT 
B)  LOAN 
C)  PAY 
D)  RATE

Question 20

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

Discuss the use of the * wildcard character in query criteria.

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

Which arithmetic operator signifies division?

A summary query calculates statistics about ____.

The > comparison operator means ____.

The wildcard character that represents one character in query criteria is the ____.

In Query Design View, you can drag the edge of a(n) field list to resize it. _________________________

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

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

When the comparison operator Null is used as criteria in the query design grid, the query finds records in which ____.

When a query is saved, it saves VBA statements. _________________________

In the query design grid, what characters surround text criteria?

You want to search for all last names beginning with the letter M. The field name for last name is LName. Describe how to do this.

The Find ____ Query Wizard is used to find records in one table that do not have related records in another table.

The ____ function returns the number of characters in a field.

An SQL statement determines how the resulting records are sorted after the ____ keyword.

Filtering refers to reordering records in either ascending or descending order based on the values in the field. _________________________

Which function should you use to calculate the monthly payment on a loan?

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.

Getting Started With Access

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Enhancing Forms

Analyizng Data With Reports

Importing and Exporting Data

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Using Acess and the Web

Completing a Database Application

Filters

Exam 6: Improving Queries

Discuss the use of the * wildcard character in query criteria.

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

Which arithmetic operator signifies division?

A summary query calculates statistics about ____.

The > comparison operator means ____.

The wildcard character that represents one character in query criteria is the ____.

In Query Design View, you can drag the edge of a(n) field list to resize it. _________________________

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

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

When the comparison operator Null is used as criteria in the query design grid, the query finds records in which ____.

When a query is saved, it saves VBA statements. _________________________

In the query design grid, what characters surround text criteria?

You want to search for all last names beginning with the letter M. The field name for last name is LName. Describe how to do this.

The Find ____ Query Wizard is used to find records in one table that do not have related records in another table.

The ____ function returns the number of characters in a field.

An SQL statement determines how the resulting records are sorted after the ____ keyword.

Filtering refers to reordering records in either ascending or descending order based on the values in the field. _________________________

Which function should you use to calculate the monthly payment on a loan?

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.

Getting Started With Access

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Enhancing Forms

Analyizng Data With Reports

Importing and Exporting Data

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Using Acess and the Web

Completing a Database Application

Filters