MS Access 2010 adds unwanted wildcard at end of select clause MS Access 2010 has a vey weird behaviour for me. Whenever I create a new Query, it silently adds a wildcard (i.e. ', *') to the end of the SELECT clause.

The wildcard is visible only in the SQL and Data views, but not in the Query Structure view.

For example, I start a new query via 'Create > Query Structure', add a table, add one column, and the SQL result is:

SELECT TABLE1.COLUMN1, *
FROM TABLE1;


What can I do to prevent that unwanted trailing wildcard?
You apparently have the "Output all fields" option enabled for query design. To turn it off, 


choose "Options" from the "File" tab of the ribbon, 
on the "Object Designers" tab, remove the checkmark beside "Output all fields" in the "Query design" section.