Exam 6: Creating Advanced Queries and Enhancing Table Design

The Like comparison operator is used to select records by matching field values to a specific pattern that includes one or more of the wildcard characters (*, ?, #) in a query. ____________________

Using the ____________________ dialog box in a datasheet is one of the best ways to view the contents of a Long Text field.

The database object rptStudentContact is an example of a ____________________ database object.

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.

When using the IIF function, each part of the function is separated by a colon . ____________________

Case Based Critical Thinking Questions Case 5-1 Janise is creating a database to keep track of her customers for her pet sitting business. She is in the process of creating the Customer table. She would like to design the table so that data entry is as consistent and accurate as possible. Using the figures below, determine which Access features Janise used to ensure consistent and accurate data entry. Figure Case 5-1-1 Figure Case 5-1-2 To ensure that all telephone numbers are entered in a consistent manner, Janise assigned a(n) ____ to the PrimaryPhone field as illustrated in Figure Case 5-1-2.

In the accompanying figure, which field property will appear on the screen if the user enters the value 5 in the InvoiceAmt field in datasheet view?

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

A ____ query uses functions, such as Sum and Count, to perform arithmetic operations on selected records.

In an input mask, the letter ____ indicates that a letter or digit must be entered, and the entry is required.

The Registrar at Ravenswood College would like to create a query which displays all students who have not yet registered for fall semester classes.  She will use the StudentInformation and TuitionPaid tables to create the query.  Which type of query will most likely create the desired results?

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

Which of the following pattern match selection criteria would return zip codes with the characters 704 in the first three spaces.

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

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

An input mask with a 0 character indicates that only a digit can be entered as the value and that the entry is optional . ____________________

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?