You have a database with three tables: one each for products, suppliers, and distributors. You need to locate the product ID number for hammers and find out who supplies them. Which database component would perform this task?

A query searches and combines information from database tables. You can use one to find the hammer’s product ID in the products table and identify its supplier by matching related records in the supplier table. A form is mainly for entering or viewing records, a table stores records, and a report presents information.

AI-written and checked against the verified answer.