Exam 5: Creating Advanced Queries and Enhancing Table Design

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

The standard naming convention prefix tag for a query used to identify the object type is ____.

Crosstab queries may use which of the following aggregate functions?

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

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?

A standard language used in querying, updating, and managing relational databases is ____________________.

To avoid the display of a security warning when opening a database, place the database ____.

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

Fields and criteria that will be used in a query are contained in the ____________________ when creating a query.

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.

You can define a condition with a list of two or more values for a field by using the ____ comparison operator.

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

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

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

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

Validation Rules are entered in the ____

Case Based Critical Thinking Questions Carlos has developed a database for his organic farm.The farm sells organic produce and meat. In addition to the retail sales of his products, he offers cooking demonstrations five times each month for a small fee. The demonstrations are limited to 10 people. The database contains the following tables: Products, ProductPrices, ProductCosts, Suppliers, Customers, and CookingDemos. The Products, Product Prices, Product Costs and Suppliers tables are related using the ProductID field. The Customers and CookingDemos tables are related on the CustomerID field. Carlos needs to make some decisions using his database. Determine the best method for Carlos to use to achieve the results he wants. -Carlos has decided to market his cooking demonstrations based on his most abundant products. To do that he needs to know the quantity of each product by category (such as beef, green vegetables, peppers, etc.)Because each product in the Products table is assigned a category in the Category field, he will create a query that lists the categories in rows in the datasheet and the product totals as columns in the datasheet when the query is run. Which type of query will Carlos create?