When I run my update query, it is being applied to my entire table. How can I apply my update query to just one record in my table?

Use a where clause to filter out all but one record.
Example:
UPDATE myTable SET myTable.myfld = 'abc"
WHERE (((myTable.myPkeyfld) = 001));