Create a query using all the fields from the Customers table that will show those customers who have purchased a product with the Product ID 2. Save the query as Product and close the query.
How can I do it?
NOTE: This may be slightly different depending on what version you are using.
Using the query wizard, select the Customer Table then use the
If you want to learn more about making queries in Access, here is some free training from Microsoft.