Exam 6: Creating Advanced Queries and Enhancing Table Design

The accompanying figure is an example of criteria for a ____ query using the Query Wizard.

Joining two or more fields in a calculated field using an expression such as   =Title & " "& FirstName & " " & LastName is an example of concatenation . ____________________

In the accompanying figure, what is the Top Values property that has been set for the qryLargeInvoiceAmounts?

Which type of query would show results indicating two different student ID numbers have been assigned to the same student?

Setting the ____ field property to Yes instructs Access to keep an historical record of all versions of the Long Text field value.

The Access database object named tblProductCatalog is mostly likely an Access form object.

Case Based Critical Thinking Questions Case 5-3 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 ____.

A parameter query displays a dialog box that prompts the user to enter one or more values when the query is run. ____________________

Rich text formatting available for Long Text fields includes ____.

Any type of Access object may be deleted from the Tables Pane using the Delete command on the shortcut menu. ____________________

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

A summarized record for each unique field value is displayed in a crosstab query.

In the accompanying figure, the frmPatient object is dependent on the ____ object.

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

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

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

In the accompanying figure, object dependencies are shown for the ____ object.

Why is it important to use industry standard naming conventions when naming Access database objects?

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