Comment that is just venting
I like tools that are fast - I could have a whole discussion on what MS took out of 2003 when making 2010 (don't get me started on renaming objects.)
Is there a way to be sitting on a table/query - click a button (doing it in code is OK) and creating a new query that is sitting in design view ready for me to work with?
In 2003 I could be sitting on a table or query in the database window or an open table or query click a new Query button and I had a query (in design view - ready to work with) sitting in front of me with the source being the table/query I was sitting on. This speeded up my work.
In 2010 it appears the best I can do when sitting on a table/query is 5 steps instead of 1
1) Query Wizard
2) Simple Query Wizard (OK)
3) Add 1 field
4) Finished button
5) Design View