Exam 1: Access 1: Creating Advanced Queries and Enhancing Table Design

The ____ comparison operator is used to select records by matching field values specific to a pattern that includes one or more wildcard characters.

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

Which of the following examples shows an input mask for a telephone number with the first three digits optional and dashes separating the parts of the telephone number?

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

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

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

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

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

Rich text formatting available for Long Text fields includes ____.

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

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

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.

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

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

An input mask may be created for any field with the ____ or ____ data type.

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