Exam 6: Creating Advanced Queries and Enhancing Table Design

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

Free

(Short Answer)

4.8/5

(31)

Question 1

Correct Answer:

Verified

percentage

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

Free

(Multiple Choice)

4.9/5

(29)

Question 2

Correct Answer:

Verified

The standard naming convention prefix tag for a query used to identify the object type is ____.

Free

(Multiple Choice)

4.9/5

(42)

Question 3

Correct Answer:

Verified

Match the followings.

Premises:

Selects records for the designated field when the value matches one of two or more condition values.

Responses:

SQL (Structured Query Language)

list-of-values match

property propagation

Correct Answer:

Verified

Selects records for the designated field when the value matches one of two or more condition values.

(Matching)

4.9/5

(33)

Question 4

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

(True/False)

4.8/5

(37)

Question 5

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

(True/False)

4.8/5

(35)

Question 6

You can define a condition with a list of two or more values for a field by using the ____ comparison operator.

(Multiple Choice)

4.8/5

(31)

Question 7

In the accompanying figure, which checked option will include null values in the filtered results?

(Multiple Choice)

4.8/5

(25)

Question 8

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

(Short Answer)

4.8/5

(37)

Question 9

Validation Rules are entered in the ____

(Multiple Choice)

4.9/5

(38)

Question 10

Which Access object(s) may be used when creating a lookup field to select values?

(Multiple Choice)

4.8/5

(26)

Question 11

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

(Multiple Choice)

4.9/5

(29)

Question 12

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

(True/False)

4.8/5

(33)

Question 13

In the accompanying figure, the top values query is designed to return the top values for the ____ field.

(Multiple Choice)

4.8/5

(35)

Question 14

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

(Multiple Choice)

4.8/5

(25)

Question 15

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

(True/False)

4.8/5

(25)

Question 16

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

(True/False)

4.7/5

(30)

Question 17

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.

(Multiple Choice)

4.9/5

(27)

Question 18

An input mask property cannot be changed after the Input Mask Wizard closes.

(True/False)

4.9/5

(39)

Question 19

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

(Multiple Choice)

4.9/5

(35)

Question 20

Showing 1 - 20 of 100

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.

The standard naming convention prefix tag for a query used to identify the object type is ____.

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

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

You can define a condition with a list of two or more values for a field by using the ____ comparison operator.

In the accompanying figure, which checked option will include null values in the filtered results?

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

Validation Rules are entered in the ____

Which Access object(s) may be used when creating a lookup field to select values?

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

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

In the accompanying figure, the top values query is designed to return the top values for the ____ field.

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

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

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

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 property cannot be changed after the Input Mask Wizard closes.

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

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