Question 1

The aggregate function which returns the number of nonnull field values is the ____ function.

Accepted Answer

A) Max 
B) Sum 
C) Avg 
D) Count 
A) Max 
B) Sum 
C) Avg 
D) Count D

Question 2

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 C

Question 3

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

Accepted Answer

A) A 
B) C 
C) L 
A) A 
B) C 
C) L C

Question 4

Match between columns
                        Premises: Selects a record for the designated field with a value that matches the pattern of a simple condition value.

Accepted Answer

The Answer of Validation Rule and list-of-values match and find is...

Question 5

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?

Accepted Answer

A) Like 
B) Between 
C) In 
D) Or 
A) Like 
B) Between 
C) In 
D) Or

Question 6

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

Accepted Answer

The answer of An expression that calculates the values of...

Question 7

Case Based Critical Thinking Questions
Marie works for a busy pediatrician's office. The practice has a sophisticated database for all records and information that pertain to the practice. The doctor for whom she works is participating in an academic study, and she needs a report that lists the patient's name, date of birth, and the names of parents or guardians. The doctor would like to see the patient's full name in the format Lastname, Firstname even though they are separate fields in the database. She would also like to see the data for the fields Mother, Father, and Guardian, regardless of whether or not data is actually entered in those fields. Based on the doctor's requirements for the report, Marie must create a query on which to base the report.
- Because the doctor wants all data entered for parents and guardians regardless of the data in the field, Marie must create a calculated field in the query with a function that tests the Mother, Father, and Guardian fields for a condition that is either true or false. If the condition is true, one result will be displayed, and if the condition is false a different result will be displayed. Which function should Marie use for this calculated field?

Accepted Answer

A) Input 
B) IIf 
C) nonnull 
D) IsError 
A) Input 
B) IIf 
C) nonnull 
D) IsError

Question 8

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 needs to decide which cooking demonstrations to offer next month. He would like to offer his five most popular demonstrations. Which method would be best for Carlos to use to find this information from his database?

Accepted Answer

A) use a calculated field in the CookingDemo table to calculate how many people signed up for each demonstration 
B) manually count the number of people who attended each demonstration 
C) create a top values query based on the field in the CookingDemo table that lists the number of participants 
D) create a pattern match in a query based on the Customer table 
A) use a calculated field in the CookingDemo table to calculate how many people signed up for each demonstration 
B) manually count the number of people who attended each demonstration 
C) create a top values query based on the field in the CookingDemo table that lists the number of participants 
D) create a pattern match in a query based on the Customer table

Question 9

It is a good idea to ____ the database before using compact and repair to keep the database safe from hardware and software malfunctions.

Accepted Answer

A) use a second computer to save 
B) run a virus check on 
C) make a backup copy of 
D) proofread 
A) use a second computer to save 
B) run a virus check on 
C) make a backup copy of 
D) proofread

Question 10

Which of the following is an example of a parameter query prompt criterion?

Accepted Answer

A) [Type the state:] 
B) Prompt: "Type the state:" 
C) *Type the state:* 
D) {Type the state:} 
A) [Type the state:] 
B) Prompt: "Type the state:" 
C) *Type the state:* 
D) {Type the state:}

Question 11

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

Accepted Answer

A) And 
B) Or 
C) Like 
D) Not 
A) And 
B) Or 
C) Like 
D) Not

Question 12

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 13

Match between columns
                        Premises: Selects records for the designated field when the value matches one of two or more condition values.

Accepted Answer

The Answer of pattern match and table validation rule and is...

Question 14

The Top Values query property allows the user to limit the number of records in the query results by using a preset value, by entering an integer, or by selecting a(n)____________________.

Accepted Answer

The answer of The Top Values query property allows the...

Question 15

To add more flexibility and functionality to a parameter query, comparison operators, such as ___, may be added to the original criterion.

Accepted Answer

A) Like 
B) Unlike 
C) IsIn 
D) IsNull 
A) Like 
B) Unlike 
C) IsIn 
D) IsNull

Question 16

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 17

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

Accepted Answer

A) True 
 B)False

Question 18

A pattern match selects records whose values for the designated field matches one of two or more simple condition values.

Accepted Answer

A) True 
 B)False

Question 19

The ____________________ button in the Sort Filter group on the Home tab is used to remove the current filter in a dataset or to reapply a filter.

Accepted Answer

The answer of The ____________________ button in the Sort Filter...

Question 20

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

Accepted Answer

A) True 
 B)False

The aggregate function which returns the number of nonnull field values is the ____ function.

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

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

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.

It is a good idea to ____ the database before using compact and repair to keep the database safe from hardware and software malfunctions.

Which of the following is an example of a parameter query prompt criterion?

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

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. ____________________

The Top Values query property allows the user to limit the number of records in the query results by using a preset value, by entering an integer, or by selecting a(n)____________________.

To add more flexibility and functionality to a parameter query, comparison operators, such as ___, may be added to the original criterion.

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

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

A pattern match selects records whose values for the designated field matches one of two or more simple condition values.

The ____________________ button in the Sort Filter group on the Home tab is used to remove the current filter in a dataset or to reapply a filter.

Max is an example of a(n)logical function used 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

The aggregate function which returns the number of nonnull field values is the ____ function.

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

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

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.

It is a good idea to ____ the database before using compact and repair to keep the database safe from hardware and software malfunctions.

Which of the following is an example of a parameter query prompt criterion?

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

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. ____________________

The Top Values query property allows the user to limit the number of records in the query results by using a preset value, by entering an integer, or by selecting a(n)____________________.

To add more flexibility and functionality to a parameter query, comparison operators, such as ___, may be added to the original criterion.

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

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

A pattern match selects records whose values for the designated field matches one of two or more simple condition values.

The ____________________ button in the Sort Filter group on the Home tab is used to remove the current filter in a dataset or to reapply a filter.

Max is an example of a(n)logical function used 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