You do an aggregate (GROUP BY) query to sum Quantity by ProductName. Access Help has guidance on using query designer to build this query.
I am afraid you are missing my point which is would NOT 'subtract the Quantity from the product table'. Trying to maintain an aggregate (net balance) value in a table is problemmatic and loaded with potential for data errors.