There are no shortcut keys for these actions.
To execute a query from design view using the keyboard, press and release
the Alt key to activate the menu bar, then the q key to drop down the Query
menu, then the r key to choose the Run menu item.
To switch from design view to datasheet view, press and release Alt, then v
for View, then s for dataSheet (yeah, I know, but they'd already used d for
Design). To switch from datasheet view to design view, press and release
Alt, then v, then d.
--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com
The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.