Access 2010 - Creating query from selected table

[steveg242]

I have just upgraded from Access 2003 to 2010. Now I'm trying to relearn some of the small things I used to be able to. In 2003, I could just have a table highlighted and select "Insert, Query". It would then open a query design with that table. Is this possible to do this in 2010? Or do you have to open query design then add the table manually?

 

[ypma]

Not sure if this what you mean but in ac2010 ,
1. Select the table
2 Create tab select simple query wizard
3 the wizard pop up shows the table you selected and all you have to do is select the field you require in your filed and follow the instructions ,

Hope this is of use

Regards Ypma

 

[steveg242]

Thanks Ypma,

Yes, that would be a longer way to do it. I'm big on shortcuts...getting to things in the quickest possible way. In 2003, I could just have the table selected in the object viewer, type ALT+IQ and bam, there's my query with the table right in the field list area.

In 2010, I can at least bring up the query design view by typing ALT+CQD. But I still have to select the table from the show table list...and in my master database I have like 100 queries to sort through.

As I type this I realized I can just close the show table box and drag the table to the field list area. Still it's an extra step or two than in 2003. I was just wondering if there was something I was missing.