Exam 6: Creating Advanced Queries and Enhancing Table Design

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 The State field in Figure Case 5-1-1 illustrates which of the following?

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

The aggregate function which returns the number of nonnull field values is the ____ function.

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 The 9999 included in the Input Mask property in Figure Case 5-1-2 indicates that data entry is ____ for that part of the field.

Case Based Critical Thinking Questions Case 5-2 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?

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

Case Based Critical Thinking Questions Case 5-2 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 needs to decide which cooking demonstrations to offer next month.  He would like to offer his five most popular demonstrations. Which method would be best for Carlos to use to find this information from his database?

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 According to the Field Properties in Figure Case 5-1-2, to which field has Janise assigned an input mask?

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

In the accompanying figure, the ____ for the current field is/are indicated in the box designated by the arrow.

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

Case Based Critical Thinking Questions Case 5-2 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 would like to create a query based on the Customer table that allows him to type in the name of the cooking demonstration for which the query will run.  Which type of query should Carlos create so that he can type in the name of the cooking demonstration before the query runs?

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.

Access designates all queries in the Navigation Pane with the same icon regardless of the query type.

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