Solved

Query Design slower in 2010 than 2003 - Sulution?

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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Database maintenance 36 110
Parameter Query 33 52
Runtime Error -2147467259 (80004005) 7 50
Append Query Access 2010 4 26
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
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 …
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

730 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