Exam 6: Improving Queries Question

____________________ queries summarize data in which one or more fields are chosen for the row headings, another for the column heading, and yet another for the field summarized within the datasheet itself.

(Short Answer)

4.8/5

(68)

Question 41

In the query above, the criteria in the first row would be considered AND criteria.

(True/False)

4.8/5

(77)

Question 42

In Query Design View, primary key fields in a field list are ____.

(Multiple Choice)

4.8/5

(65)

Question 43

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

(Multiple Choice)

4.8/5

(69)

Question 44

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

(Short Answer)

4.8/5

(81)

Question 45

A(n)____ character is used in criteria to represent any combination of characters.

(Multiple Choice)

4.9/5

(88)

Question 46

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

(Short Answer)

4.9/5

(81)

Question 47

When you open a query in Datasheet View, you run it.

(True/False)

4.9/5

(73)

Question 48

In the figure above, how many fields will display on the resulting datasheet?

(Multiple Choice)

5.0/5

(79)

Question 49

In Query Design View, one-to-many join lines identify linking fields between related tables.

(True/False)

5.0/5

(79)

Question 50

Discuss the use of wildcard characters in query criteria: 1. Why are they used? 2. What two wildcard characters are provided to search for a single character or any number of characters?

(Essay)

4.8/5

(80)

Question 51

The data displayed in a query is sometimes called a(n)____________________ view of the data.

(Short Answer)

4.7/5

(82)

Question 52

The ____________________ function returns a number of characters from the first part of a field.

(Short Answer)

4.9/5

(92)

Question 53

A(n)____________________ calculates a statistic such as a sum or average by grouping records like a crosstab query with the additional benefit of allowing you to filter the presented data.

(Short Answer)

4.8/5

(83)

Question 54

The operator > means ____.

(Multiple Choice)

4.7/5

(71)

Question 55

The operator Null used as criteria in the query design grid finds records in which _____.

(Multiple Choice)

4.8/5

(85)

Question 56

Match each of the following with the correct definition or statement.

A datasheet's records are placed in a determined order

Sort

An asterisk or question mark used in a query

Wildcard character

A statistic such as a subtotal or count is determined on a given field in a group of records

Function

Correct Answer:

Verified

A datasheet's records are placed in a determined order

An asterisk or question mark used in a query

A statistic such as a subtotal or count is determined on a given field in a group of records

A combination of field names, operators and functions

A predefined Access formula that returns a value such as a subtotal or count

A field of data that is created based on values of other fields

(Matching)

4.8/5

(84)

Question 57

A select query is the most common type of query.

(True/False)

4.9/5

(92)

Question 58

Use the ____________________ check box in the query design grid to select or unselect a field to display in the resulting datasheet.

(Short Answer)

4.8/5

(77)

Question 59

The operator < means ____.

(Multiple Choice)

4.7/5

(81)

Question 60

Showing 41 - 60 of 68

____________________ queries summarize data in which one or more fields are chosen for the row headings, another for the column heading, and yet another for the field summarized within the datasheet itself.

In the query above, the criteria in the first row would be considered AND criteria.

In Query Design View, primary key fields in a field list are ____.

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

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

A(n)____ character is used in criteria to represent any combination of characters.

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

When you open a query in Datasheet View, you run it.

In the figure above, how many fields will display on the resulting datasheet?

In Query Design View, one-to-many join lines identify linking fields between related tables.

Discuss the use of wildcard characters in query criteria: 1. Why are they used? 2. What two wildcard characters are provided to search for a single character or any number of characters?

The data displayed in a query is sometimes called a(n)____________________ view of the data.

The ____________________ function returns a number of characters from the first part of a field.

A(n)____________________ calculates a statistic such as a sum or average by grouping records like a crosstab query with the additional benefit of allowing you to filter the presented data.

The operator > means ____.

The operator Null used as criteria in the query design grid finds records in which _____.

A select query is the most common type of query.

Use the ____________________ check box in the query design grid to select or unselect a field to display in the resulting datasheet.

The operator < means ____.

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