Exam 1: Access 1: Creating Advanced Queries and Enhancing Table Design

An expression that calculates the values of the data in a field is contained in a ____________________ field.

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

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

The ____ function tests a condition and returns one of two values; the function returns the first value if the condition is true and the second value if the condition is false.

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

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

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?

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

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

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

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

Case Based Critical Thinking Questions Case 5-1 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. As Carlos plans for the fall planting season, he would like to bundle all of his shipments from the Organic Opportunities supplier into one shipment. He needs to know which products he has previously ordered from Organic Opportunities. Which method will quickly produce the results Carlos needs?

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