Solved

Query Design slower in 2010 than 2003 - Sulution?

Posted on 2013-06-02
1
329 Views
Last Modified: 2013-06-03
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.)

Question
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?

Problem
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

Thanks in advance for any help.
LJG
0
Comment
Question by:LJG
1 Comment
 
LVL 29

Accepted Solution

by:
IrogSinta earned 500 total points
ID: 39214680
Not quite the same as 2003 but you can still skip other steps by selecting QueryDesign (the icon beside QueryWizard) and double-clicking on your table in the list that comes up.

Additionally, you can just ignore the list of tables that comes up and just drag tables and/or queries from the Navigation Pane to the blank QBE box.
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question