Exam 5: Creating Advanced Queries and Enhancing Table Design

A field property option that verfies a field value by comparing the value entered to a constant or set of constants.

____________________ perform arithmetic operations on selected records in a crosstab query.

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.

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

In crosstab query results,the value of a checked Yes/No data type field will display as ____.

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

A select query that finds all records in a table or query that have no related records in the second table or query.

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

Which of the following is an example of a parameter query prompt criterion?

A rule that is set when the validation involves multiple fields.

Selects a record for the designated field with a value that matches the pattern of a simple condition value.a.find unmatched query

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

Yes/No field values are stored in an Access database as a --1 for a checked value and a 0 for an unchecked value.

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

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

When creating an input mask,the ____ input mask character is used to indicate that the following character will be a literal display of that character.

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?

The office manager at Riverview Veterinary Care Center would like to create a query which displays all patients who have not yet received their yearly check up.She will use the qryAnimalsAndOwners and tblVisit table to create the query.Which type of query will most likely create the desired results?

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

The ____________________ button in the Sort &Filter group on the Home tab is used to remove the current filter in a dataset or to reapply a filter.