Question 1

A select query that finds duplicate records in a table or query is a ____________________ query.

Accepted Answer

find duplicates

Question 2

Which type of query would show results indicating two different student ID numbers have been assigned to the same student?

Accepted Answer

A)  simple query 
B)  find unmatched query 
C)  find duplicates query 
D)  crosstab query 
A)  simple query 
B)  find unmatched query 
C)  find duplicates query 
D)  crosstab query C

Question 3

Max is an example of a(n) logical function used in a crosstab query.

Accepted Answer

A) True 
 B)False  False

Question 4

In the accompanying figure, which of the following is the truepart of the calculated expression?

Accepted Answer

A)  Patient: 
B)  IsNull(Parent) 
C)  LastName & ", " & FirstName 
D)  Parent & "(Parent)" 
A)  Patient: 
B)  IsNull(Parent) 
C)  LastName & ", " & FirstName 
D)  Parent & "(Parent)"

Question 5

Fields and criteria that will be used in a query are contained in the ____________________ when creating a query.

Accepted Answer

The answer of Fields and criteria that will be used...

Question 6

Rich text formatting available for Long Text fields includes ____.

Accepted Answer

A)  paragraph styles 
B)  font options 
C)  themes 
D)  borders 
A)  paragraph styles 
B)  font options 
C)  themes 
D)  borders

Question 7

A Social Security Number which appears in the format 123-456-7891 is an example of a(n) ____.

Accepted Answer

A)  field value 
B)  predefined input mask 
C)  aggregate function 
D)  variance 
A)  field value 
B)  predefined input mask 
C)  aggregate function 
D)  variance

Question 8

Which of the following illustrates a calculated field with the name of the calculated field in the proper format?

Accepted Answer

A)  [Donation]>=2500 
B)  DonationsGreaterThan2500: [Donation]>=2500 
C)  >=2500[Donation] 
D)  [Donation]:DonationsGreaterThan2500:>=2500 
A)  [Donation]>=2500 
B)  DonationsGreaterThan2500: [Donation]>=2500 
C)  >=2500[Donation] 
D)  [Donation]:DonationsGreaterThan2500:>=2500

Question 9

When using the IIf function, a condition is tested, and if the condition is false , the first value of the condition is returned by the function.

Accepted Answer

A) True 
 B)False

Question 10

An input mask with a 0 character indicates that only a digit can be entered as the value and that the entry is optional .

Accepted Answer

A) True 
 B)False

Question 11

Case Based Critical Thinking Questions Case 5-2
Carlos has developed a database for his organic farm. The farm sells organic produce and meat. In addition to the retail sales of his products, he offers cooking demonstrations five times each month for a small fee. The demonstrations are limited to 10 people. The database contains the following tables: Products, ProductPrices, ProductCosts, Suppliers, Customers, and CookingDemos. The Products, Product Prices, Product Costs and Suppliers tables are related using the ProductID field. The Customers and CookingDemos tables are related on the CustomerID field. Carlos needs to make some decisions using his database. Determine the best method for Carlos to use to achieve the results he wants.
As Carlos plans for the fall planting season, he would like to bundle all of his shipments from the Organic Opportunities supplier into one shipment. He needs to know which products he has previously ordered from Organic Opportunities. Which method will quickly produce the results Carlos needs?

Accepted Answer

A)  create a calculated query using the Products table 
B)  create a find unmatched query using the Suppliers table 
C)  use a lookup field in the Products table 
D)  use the AutoFilter option in the Supplier table for the appropriate field 
A)  create a calculated query using the Products table 
B)  create a find unmatched query using the Suppliers table 
C)  use a lookup field in the Products table 
D)  use the AutoFilter option in the Supplier table for the appropriate field

Question 12

Tables used in a find unmatched query must have a common field .

Accepted Answer

A) True 
 B)False

Question 13

A nonnull field is a field that contains any data at all, including a single space.

Accepted Answer

A) True 
 B)False

Question 14

The format field command freezes a field (column) in a datasheet so that the field stays visible when the user scrolls to the right while viewing the datasheet.

Accepted Answer

A) True 
 B)False

Question 15

In crosstab query results, the value of a checked Yes/No data type field will display as ____.

Accepted Answer

A)  0 
B)  1 
C)  -1 
D)  +1 
A)  0 
B)  1 
C)  -1 
D)  +1

Question 16

The ____ function tests a condition and returns one of two values; the function returns the first value if the condition is true and the second value if the condition is false.

Accepted Answer

A)  IIf 
B)  Pmt 
C)  IsNull 
D)  NPV 
A)  IIf 
B)  Pmt 
C)  IsNull 
D)  NPV

Question 17

Crosstab queries may use which of the following aggregate functions?

Accepted Answer

A)  Like 
B)  Not 
C)  Var 
D)  Between 
A)  Like 
B)  Not 
C)  Var 
D)  Between

Question 18

Why is it important to use industry standard naming conventions when naming Access database objects?

Accepted Answer

It is important to use industry standard

Question 19

Joining two or more fields in a calculated field using an expression such as =Title & " "& FirstName & " " & LastName is an example of concatenation .

Accepted Answer

A) True 
 B)False

Question 20

The accompanying figure is an example of criteria for a ____ query using the Query Wizard.

Accepted Answer

A)  simple 
B)  find unmatched 
C)  find matched 
D)  crosstab 
A)  simple 
B)  find unmatched 
C)  find matched 
D)  crosstab

A select query that finds duplicate records in a table or query is a ____________________ query.

Which type of query would show results indicating two different student ID numbers have been assigned to the same student?

Max is an example of a(n) logical function used in a crosstab query.

In the accompanying figure, which of the following is the truepart of the calculated expression?

Fields and criteria that will be used in a query are contained in the ____________________ when creating a query.

Rich text formatting available for Long Text fields includes ____.

A Social Security Number which appears in the format 123-456-7891 is an example of a(n) ____.

Which of the following illustrates a calculated field with the name of the calculated field in the proper format?

When using the IIf function, a condition is tested, and if the condition is false , the first value of the condition is returned by the function.

An input mask with a 0 character indicates that only a digit can be entered as the value and that the entry is optional .

Tables used in a find unmatched query must have a common field .

A nonnull field is a field that contains any data at all, including a single space.

The format field command freezes a field (column) in a datasheet so that the field stays visible when the user scrolls to the right while viewing the datasheet.

In crosstab query results, the value of a checked Yes/No data type field will display as ____.

The ____ function tests a condition and returns one of two values; the function returns the first value if the condition is true and the second value if the condition is false.

Crosstab queries may use which of the following aggregate functions?

Why is it important to use industry standard naming conventions when naming Access database objects?

Joining two or more fields in a calculated field using an expression such as =Title & " "& FirstName & " " & LastName is an example of concatenation .

The accompanying figure is an example of criteria for a ____ query using the Query Wizard.

Access: Using Form Tools and Creating Custom Forms

Access: Creating Custom Reports

Access: Sharing, Integrating, and Analyzing Data

Excell: Working With Excel Tables, Pivottables, and Pivotcharts

Excell: Managing Multiple Worksheets and Workbooks

Excell: Developing an Excel Application

Excell: Working With Advanced Functions

Powerpoint: Applying Advanced Formatting to Objects

Powerpoint: Advanced Animations and Distributing Presentations

Word: Working With Templates, Themes, and Styles

Word: Using Mail Merge

Word: Collaborating With Others and Integrating Data

Filters

Exam 1: Access: Creating Advanced Queries and Enhancing Table Design

A select query that finds duplicate records in a table or query is a ____________________ query.

Which type of query would show results indicating two different student ID numbers have been assigned to the same student?

Max is an example of a(n) logical function used in a crosstab query.

In the accompanying figure, which of the following is the truepart of the calculated expression?

Fields and criteria that will be used in a query are contained in the ____________________ when creating a query.

Rich text formatting available for Long Text fields includes ____.

A Social Security Number which appears in the format 123-456-7891 is an example of a(n) ____.

Which of the following illustrates a calculated field with the name of the calculated field in the proper format?

When using the IIf function, a condition is tested, and if the condition is false , the first value of the condition is returned by the function.

An input mask with a 0 character indicates that only a digit can be entered as the value and that the entry is optional .

Tables used in a find unmatched query must have a common field .

A nonnull field is a field that contains any data at all, including a single space.

The format field command freezes a field (column) in a datasheet so that the field stays visible when the user scrolls to the right while viewing the datasheet.

In crosstab query results, the value of a checked Yes/No data type field will display as ____.

The ____ function tests a condition and returns one of two values; the function returns the first value if the condition is true and the second value if the condition is false.

Crosstab queries may use which of the following aggregate functions?

Why is it important to use industry standard naming conventions when naming Access database objects?

Joining two or more fields in a calculated field using an expression such as =Title & " "& FirstName & " " & LastName is an example of concatenation .

The accompanying figure is an example of criteria for a ____ query using the Query Wizard.

Access: Using Form Tools and Creating Custom Forms

Access: Creating Custom Reports

Access: Sharing, Integrating, and Analyzing Data

Excell: Working With Excel Tables, Pivottables, and Pivotcharts

Excell: Managing Multiple Worksheets and Workbooks

Excell: Developing an Excel Application

Excell: Working With Advanced Functions

Powerpoint: Applying Advanced Formatting to Objects

Powerpoint: Advanced Animations and Distributing Presentations

Word: Working With Templates, Themes, and Styles

Word: Using Mail Merge

Word: Collaborating With Others and Integrating Data

Filters