Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Query Design slower in 2010 than 2003 - Sulution?

Posted on 2013-06-02
1
Medium Priority
?
350 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 29

Accepted Solution

by:
IrogSinta earned 2000 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

618 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