Solved

Query Design slower in 2010 than 2003 - Sulution?

Posted on 2013-06-02
1
302 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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
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.

744 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now