Online Test Banks
Score higher
See Online Test Banks
eLearning
Learning anything is easy
Browse Online Courses
Mobile Apps
Learning on the go
Explore Mobile Apps
Dummies Store
Shop for books and more
Start Shopping

Keyboard Shortcuts for Access 2007

Part of the Access 2007 For Dummies Cheat Sheet

The keyboard shortcuts available in Access 2007 give you the ability to do basic tasks, such as opening and closing the database quickly. It also gives you tools to accomplish nearly every job with the press of a couple of buttons. The following table shows Access keystrokes and their functions:

Keystroke Function Keystroke Function Keystroke Function
Ctrl+n Create a new blank database Ctrl+; Inserts the current date Ctrl+Right Arrow Moves selected control to the right in design or layout view
Ctrl+o Open an existing database Ctrl+: Inserts the current time Ctrl+ Left Arrow Moves selected control to the left in design or layout view
F11 Show/hide Navigation Pane Ctrl+’ Copies same field data from previous record. Ctrl+ Down Arrow Moves selected control down in design or layout view
Alt+f Opens the Microsoft Office Button menu F2 Selects all data in the field or places cursor in edit mode Ctrl+ Up Arrow Moves selected control up in design or layout view
Alt+h Displays Home tab on the Ribbon. F9 Recalculates fields on a form or refreshes a lookup combo or list box list Shift+Right Arrow Increases selected control width in design or layout view
Alt+c Displays the Create tab on the Ribbon Ctrl+Enter Inserts a line break in datasheet and form view Shift+ Left Arrow Decreases selected control width in design or layout view
Alt+x Displays the External Data tab on the Ribbon Ctrl+Shift++ Inserts a new record Shift+ Down Arrow Increases selected control height in design or layout view
Alt+a Displays the Database Tools tab on the Ribbon Ctrl+Shift+- Deletes current record Shift+ Up Arrow Decreases selected control height in design or layout view
Ctrl+c Copies selection to the clipboard Ctrl+Enter Opens selected object from Navigation Pane in design view F4 Toggles property sheet in design view
Ctrl+v Pastes selection to the clipboard F4 Toggles property sheet in design or layout view Shift+F2 Zooms in on current field in datasheet and form view
Ctrl+z Undoes last operation
  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus

SERIES
Access 2007 For Dummies Cheat Sheet

Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.