Just upgraded to Access 2007 from 2003....In the older version you could create a query relating to the table you had open just by opening a query while being in the table. I can't figure out a shortcut to do this in 2007. In 2007 I can be in a table, create a queries and I still have to go thru my list of tables to select the table the query is related to. Any shortcuts for this?
-
-
Guess when you use "Create query" the selection of the table(s) is rather straight forward.
In general I use multiple tables in my queries, thus the Add table dialog is needed. You can add the create query button to the top of Access to have it always available, but that's the only "shortcut" I can think of.
Nic;o)
Comment