Microsoft Access: Update Query with "Where","and" and "Or" Clauses

Suppose we have a table in Microsoft Access with various fields including - Title: Mr., Mrs, Ms, Dr. Er. etc. Name: Name of the person Gende...