FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 5: Creating Advanced Queries and Enhancing Table Design

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

Multiple Choice

Review LaterAdd Note

Review Later

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

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

E) A) and B)
F) None of the above

Correct Answer

verified

Show Answer

Question 2

Short Answer

Review LaterAdd Note

Review Later

Table Validation Rules are entered using the ____________________ for a table.

Correct Answer

verified

Show Answer

Question 3

True/False

Review LaterAdd Note

A calculated query uses aggregate functions to perform arithmetic operations on selected records.

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

The input mask character ____ indicates that a letter only must be entered,and the entry is required.

An input mask may be created for any field with the ____ or ____ data type.

When using the IIF function,each part of the function is separated by a colon.____________________

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

Which of the following pattern match selection criteria would return zip codes with the characters 704 in the first three spaces.

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. -Carlos would like to create a query based on the Customer table that allows him to type in the name of the cooking demonstration for which the query will run.Which type of query should Carlos create so that he can type in the name of the cooking demonstration before the query runs?

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

A summarized record for each unique field value is displayed in a crosstab query.

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 ____ query uses functions,such as Sum and Count,to perform arithmetic operations on selected records.

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

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.

A criterion may be negated by using the ____ logical operator.

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?

An expression that calculates the values of the data in a field is contained in a ____________________ field.

The capability of a database to update field properties in objects automatically when a table field property is modified.