FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

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

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

True/False

Review LaterAdd Note

Review Later

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.

A) True
B) False

Correct Answer

verified

Show Answer

Question 2

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

False

Question 3

Multiple Choice

Review LaterAdd Note

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?

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.

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

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

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

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

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

Crosstab queries may use which of the following aggregate functions?

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.

Rich text formatting available for Long Text fields includes ____.

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

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

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

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.

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

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

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