some SQL engines are more picky about the format of the SQL.
however my version of Access (OfficeXP / 2003) using JET 4.1 (I think) accepts either format. the only time I've had to overtly declare the table name in a where clause is if there is ambiguity in a where clause (ie you have more than one column with the same name). Although many would argue its good practise to fully qualify each element, which is the behaviour of the query designer, but that also adds brackets like there is no tomorrow
all in all another good reason in my books never to use select *.. its just plain lazy SQL development