rgruchalski: As a workaround for #3 above, you can do the following in Access 2007. Click on the dropdown arrow to the right of the Quick Access Toolbar (QAT) -- that's just to the right of the Office button. Choose "More Commands...". From the "Choose commands
from" dropdown, choose SQL Statement Tools | Design Tab. Click on the "SQL View" item in the list below. Then click on the "Add > >" button to add it to the list on the right. Click OK. You should now have the SQL view button in your QAT. It's still an extra
button click (open from the nav pane first, then choose SQL view from the QAT), but at least you save yourself the right-click.