Search notes:

Access menu: File -> Options -> Object Designers -> Query design

Show table names
Output all fields
Enable AutoJoin
Query design font:
MS Access: SQL Server Compatible Syntax (ANSI-92)

Index