Question 1

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 2

Any type of Access object may be deleted from the Tables Pane using the Delete command on the shortcut menu. ____________________

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

The answer of Table Validation Rules are entered using the...

Question 4

Valid values that may be entered in a field are specified using the ____________________ propoerty.

Accepted Answer

The answer of Valid values that may be entered in...

Question 5

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

Question 6

Case Based Critical Thinking Questions
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 7

Case Based Critical Thinking Questions
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?

Accepted Answer

A) parameter query 
B) top values query 
C) crosstab query 
D) pattern match query 
A) parameter query 
B) top values query 
C) crosstab query 
D) pattern match query

Question 8

A ____ query uses functions, such as Sum and Count, to perform arithmetic operations on selected records.

Accepted Answer

A) parameter 
B) select 
C) crosstab 
D) simple 
A) parameter 
B) select 
C) crosstab 
D) simple

Question 9

Yes/No field values are stored in an Access database as a --1 for a checked value and a 0 for an unchecked value.

Accepted Answer

A) True 
 B)False

Question 10

The calculated expression =City "," State " " ZipCode is an example of ____.

Accepted Answer

A) concatenation 
B) ampersand 
C) AutoFilter 
D) a parameter query 
A) concatenation 
B) ampersand 
C) AutoFilter 
D) a parameter query

Question 11

A value of true will be returned if a field is empty when the IsNull function is used.

Accepted Answer

A) True 
 B)False

Question 12

Setting the ____ field property to Yes instructs Access to keep an historical record of all versions of the Long Text field value.

Accepted Answer

A) Append Only 
B) Validation Rule 
C) Input Max 
D) Default Value 
A) Append Only 
B) Validation Rule 
C) Input Max 
D) Default Value

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) Find Duplicates Query Wizard 
B) Crosstab Query Wizard 
C) Simple Query Wizard 
D) Find Unmatched Query Wizard 
A) Find Duplicates Query Wizard 
B) Crosstab Query Wizard 
C) Simple Query Wizard 
D) Find Unmatched Query Wizard

Question 15

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

Accepted Answer

A) True 
 B)False

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

Any type of Access object may be deleted from the Tables Pane using the Delete command on the shortcut menu. ____________________

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

Valid values that may be entered in a field are specified using the ____________________ propoerty.

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

A ____ query uses functions, such as Sum and Count, to perform arithmetic operations on selected records.

Yes/No field values are stored in an Access database as a --1 for a checked value and a 0 for an unchecked value.

The calculated expression =City "," State " " ZipCode is an example of ____.

A value of true will be returned if a field is empty when the IsNull function is used.

Setting the ____ field property to Yes instructs Access to keep an historical record of all versions of the Long Text field value.

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

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

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

Access-Module 1: 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 Securing a Database

Relational Databases and Database Design

Filters

Exam 5: Creating Advanced Queries and Enhancing Table Design

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

Any type of Access object may be deleted from the Tables Pane using the Delete command on the shortcut menu. ____________________

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

Valid values that may be entered in a field are specified using the ____________________ propoerty.

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

A ____ query uses functions, such as Sum and Count, to perform arithmetic operations on selected records.

Yes/No field values are stored in an Access database as a --1 for a checked value and a 0 for an unchecked value.

The calculated expression =City "," State " " ZipCode is an example of ____.

A value of true will be returned if a field is empty when the IsNull function is used.

Setting the ____ field property to Yes instructs Access to keep an historical record of all versions of the Long Text field value.

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

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

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

Access-Module 1: 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 Securing a Database

Relational Databases and Database Design

Filters