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?

A. create a calculated query using the Products table
B. create a find unmatched query using the Suppliers table
C. use a lookup field in the Products table
D. use the AutoFilter option in the Supplier table for the appropriate field


Answer: D

Computer Science & Information Technology

You might also like to view...

Case-Based Critical Thinking QuestionsCase 9-1Kyra is preparing speaker notes and handouts for her presentation. Please answer the questions below.Kyra wants the speaker notes on the computer screen she will use at the lectern, but displaying the notes-free slides on the projection image seen by the audience. She uses _____________.

A. Speaker View B. Slide View C. Presenter View D. Normal View

Computer Science & Information Technology

Can password cracking be prevented? How?

What will be an ideal response?

Computer Science & Information Technology

FIGURA OFF 1-1 En relación con la figura anterior OFF 1-1, si se hiciera clic en otra parte de la pantalla (y ya no se seleccionara la forma), la pestaña de herramientas de dibujo ____.

A. permanecería visible como pestaña pero no sería la pestaña activa B. permanecería visible como pestaña y seguiría siendo la pestaña activa C. desaparecería D. se minimizaría en la barra de tareas

Computer Science & Information Technology

How does software differ from the artifacts produced by other engineering disciplines?

What will be an ideal response?

Computer Science & Information Technology