Is there a shortcut key to go to Design View from Datasheet View?

Posted on 2008-10-28
Last Modified: 2011-10-19
Is there a shortcut key to go to Design View from Datasheet View?
Question by:k-wow
  • 3
  • 2
LVL 75
ID: 22827208
It's the same thing ... Executing puts the query in Datasheet view..

Alt --> Q --> Then R



Expert Comment

ID: 22828024
you can create a customized toolbar like below,

haven't figured out how to assign a shortcut to the toolbar yet,

so it's one easy click instead of two

Author Comment

ID: 22828055

"Alt --> Q --> Then R" does not go to Design View from Datasheet View.


I am looking for a shortcut key because i do not want to go and grab the mouse and drag it to the icon and click left-click.
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

LVL 75

Accepted Solution

DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 500 total points
ID: 22828177
Sorry ...

Alt >> V >> D


Author Closing Comment

ID: 31510982
that is exactly what i was looking for. Is there a comprehensive list for Access 2007 that has all this shortcut keys?
LVL 75
ID: 22828253
I have this for A2003 ... most would be the same.  Maybe Google.


Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

If you find yourself in this situation “I have used SELECT DISTINCT but I’m getting duplicates” then I'm sorry to say you are using the wrong SQL technique as it only does one thing which is: produces whole rows that are unique. If the results you a…
Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

840 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