Exam 6: Creating Advanced Queries and Enhancing Table Design

When is it appropriate to use an input mask for a field value? List two examples of fields for which a database designer might use an input mask.

(Essay)

4.7/5

(31)

Question 21

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

(Multiple Choice)

4.8/5

(45)

Question 22

To avoid the display of a security warning when opening a database, place the database ____.

(Multiple Choice)

4.8/5

(41)

Question 23

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

(Multiple Choice)

4.8/5

(29)

Question 24

The Return box used to designate the number or percentage of records to select in a top values query is located on the ____________________ tab on the ribbon.

(Short Answer)

4.9/5

(31)

Question 25

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

(Short Answer)

4.9/5

(39)

Question 26

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

(Multiple Choice)

4.8/5

(41)

Question 27

Which query wizard allows the user to choose the field that will be calculated for each row and column intersection?

(Multiple Choice)

4.8/5

(33)

Question 28

The ____________________ operator selects records for which the designated field does not match the criterion or negates a criterion.

(Short Answer)

4.8/5

(27)

Question 29

Which comparison operator defines a condition with a list of two or more values for a field and includes records when the field matches one value from the list in the query results?

(Multiple Choice)

4.8/5

(39)

Question 30

Match the followings.

Premises:

Selects a record for the designated field with a value that matches the pattern of a simple condition value.

Responses:

table validation rule

find unmatched query

Validation Rule

Correct Answer:

Verified

Selects a record for the designated field with a value that matches the pattern of a simple condition value.

(Matching)

4.7/5

(32)

Question 31

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

(Short Answer)

4.8/5

(31)

Question 32

A query that selects records in fields that satisfy the criteria is a Select query.

(True/False)

4.9/5

(33)

Question 33

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?

(Multiple Choice)

4.7/5

(41)

Question 34

The value of a field containing no information is a ____ value.

(Multiple Choice)

4.9/5

(39)

Question 35

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

(Short Answer)

4.8/5

(33)

Question 36

Crosstab queries may use which of the following aggregate functions?

(Multiple Choice)

4.9/5

(26)

Question 37

In the accompanying figure, what is the condition for the calculated expression?

(Multiple Choice)

4.9/5

(38)

Question 38

____________________ perform arithmetic operations on selected records in a crosstab query.

(Short Answer)

4.8/5

(38)

Question 39

List five Access features that help ensure that data entered in an Access database is as error-free as possible.

(Essay)

4.7/5

(33)

Question 40

Showing 21 - 40 of 100

When is it appropriate to use an input mask for a field value? List two examples of fields for which a database designer might use an input mask.

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

To avoid the display of a security warning when opening a database, place the database ____.

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

The Return box used to designate the number or percentage of records to select in a top values query is located on the ____________________ tab on the ribbon.

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

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

Which query wizard allows the user to choose the field that will be calculated for each row and column intersection?

The ____________________ operator selects records for which the designated field does not match the criterion or negates a criterion.

Which comparison operator defines a condition with a list of two or more values for a field and includes records when the field matches one value from the list in the query results?

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

A query that selects records in fields that satisfy the criteria is a Select query.

The value of a field containing no information is a ____ value.

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

Crosstab queries may use which of the following aggregate functions?

In the accompanying figure, what is the condition for the calculated expression?

____________________ perform arithmetic operations on selected records in a crosstab query.

List five Access features that help ensure that data entered in an Access database is as error-free as possible.

Managing Your Files

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Using Form Tools and Creating Custom Forms

Creating Custom Reports

Sharing Integrating and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Managing and Sharing a Database

Filters