SharePoint Designer allows creating workflows and editing layout pages for publishing sites. However, Application Pages (.aspx files in the _layouts folder) cannot be edited with Designer - they must be modified on the file system. Site Columns are created through browser UI or Features, not directly in Designer.