Microsoft Access – updating query data

When writing an sql query referring to one table, I have the ability to update data inside the table created by the query, for instance:
SELECT * FROM products;

When the query involves more than one table updateing data in the table created is not possible. for instance:

SELECT BI.bidNum, CO.ColorName
FROM Bids AS BI, Colors AS CO
WHERE BI.Color=CO.colornum;

Is there an possibility of writing such a query and still have the option of updating data in the table created ?