FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 6: 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

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

A) tblBilling
B) PatientID
C) InvoiceAmt
D) InvoiceNum

E) A) and B)
F) A) and C)

Correct Answer

verified

Show Answer

Question 2

Multiple Choice

Review LaterAdd Note

Review Later

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

A) Query
B) QURY
C) qry
D) QRY#

E) B) and D)
F) C) and D)

Correct Answer

verified

C

Question 3

True/False

Review LaterAdd Note

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

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

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

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

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

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.

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

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

You can define a condition with a list of two or more values for a field by using the ____ comparison 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. ____________________

Validation Rules are entered in the ____

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

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

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

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

Match the followings.

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

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