Why is Access 2010 so difficult to use?

[jsteph]

Hi all,
I don't get it, maybe someone here can help with some tips and tricks.
When I create a query, espescially after using 'query wizard', then I'm looking at the query results, I no longer have the Design View tab!! Is this not a catch 22?? How do I go back to design view?

I see the "Query Design" button, which seems logical, but it's in the "Create" tab, so when I click on that it says I have to "Save Query xxx before creating an object based on it"

What??????????

I just want to click back into design view on a query I just created? Why cant that happen?

Same with forms. I created a subform. Now I want to create a new blank form. I hit "Form" in the "Create" tab--and does it "Create" a new "Form"?? NO. It opens a copy of the last form selected with a "1" appeneded to the end of that forms name, as if it "assumed" I must want to create a new form based on that form.

I just don't get it. Why the difficulty? Why the "assumptions" and the "looking-over-my-shoulder-thinking-they're-being-helpful" arrogant disruption?

Can anyone explain how I would simply create a brand new form, that's blank, and let me add my own stuff to it--what *I* want to do and not what MS might "assume" based on some bizarre guess as to contextually what they assume I might want?

This is just such a huge departure from the 2003 version that it is almost impossible to work with.
Thanks for any help on how I can be productive with Access 2010 without this "help" from what appears to be a return of Mr Paperclip guy, only he's invisible this time.
Thanks,
--Jim

 

[dhookom]

Right click any object in the navigation pane (pain) and select Design View.

Duane
Hook'D on Access
MS Access MVP

 

[sxschech]

I too found that frustrating.

Another option in addition to Duane's suggestion is that in the lower right corner of the access window, you will see all the icons for Design View, (and depending on whether it is a query/form/report), Form View, Report View, SQL View, etc.

 

[MazeWorX]

you could always make it look like 2003

http://www.ubit.ch/software/ubitmenu-languages/

HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work" <<Edison>>

 

[MajP]

If you are not using a wizard, when you view query results the active ribbon tab becomes the "Home" tab. The very first choice in that tab is the Design icon. So I did not know what you were referring to because I do not use wizards

However testing it with a wizard the active tab becomes the "Create" tab and should probably be the "Home" tab. In this case it does not seem logical for this to be the active tab. If you switch the tab to Home that is another solution. My guess this is a bug and not the purposeful decision.

 

[jsteph]

Thanks everyone. Yes, I realized that I could do the right-click, it's just so odd that the Design tab just completely disappears.

I wouldn't even care if another tab became the 'home' tab--but the fact that the Design tab is just gone is beyond me. I guess I'll wait for the service pack...
--Jim