Allow Control-A to Select All in Query Design View
In previous versions of Access, I could use Control-A to select all fields in a table within the query design view, then Control-Click on the certain field(s) to de-select. It is not always preferential to use the asterisk, particularly if you are doing something other than a delete query. This used to be supported, but looks like it went away after I upgraded to Office365. Thanks.
Gerrit Viehmann commented
In QBE-mode (design mode) double click on the table/subquery-name rectangle to select all fields (but not *).
In SQL-text-mode try Ctrl-, Ctrl-. for a similar effect like Ctrl-A.
But I agree, the QBE-Editor and SQL-text editors are in need of a serious upgrade.