Exam 5: Creating Advanced Queries and Enhancing Table Design

A Social Security Number which appears in the format 123-456-7891 is an example of a(n)____.

The value of a field containing no information is a ____ value.

When using the IIf function, a condition is tested, and if the condition is false , the first value of the condition is returned by the function. ____________________

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

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. -Marie creates the following expression as a new field in the query that she will use to create the report requested by the doctor PatientName: [LastName] ", " [FirstName] . This expression is an example of ____.

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

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

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

The ____________________ aggregate function returns the average of the field values.

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?

Rich text formatting available for Long Text fields includes ____.

A select query that finds duplicate records in a table or query is a ____________________ query.

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.

When creating a find unmatched query using the query wizard, Matching fields will be joined automatically if a ____________________ is already defined between the two selected objects.