E.g. "Select T1.* from [Long Table Name] as T1". Until recently, you could edit aliases for objects in query design view, but that ability was lost in most recent update. Table aliases make queries more readable and reduce size of SQL text, for example to fit within the 255 character limit for macros like "OpenQuery".