Microsoft Access is a powerful database management system that helps users create, manage, and analyze data efficiently. Whether you are a student, office worker, data entry operator, or database administrator, knowing keyboard shortcuts can significantly improve your productivity.

This guide covers the most useful MS Access shortcut keys, ranging from basic navigation shortcuts to advanced database management shortcuts.

Why Use Shortcut Keys?

Shortcut keys help you:

  • Save time
  • Work faster
  • Reduce dependence on the mouse
  • Increase productivity
  • Improve data entry efficiency

Basic MS Access Shortcut Keys

Shortcut KeyFunction
Ctrl + NCreate a new database
Ctrl + OOpen an existing database
Ctrl + SSave current object
Ctrl + PPrint
Ctrl + WClose current object
Ctrl + FFind records
Ctrl + HReplace text
Ctrl + CCopy
Ctrl + XCut
Ctrl + VPaste
Ctrl + ZUndo
Ctrl + YRedo
DeleteDelete selected item
F1Open Help
Alt + F4Exit Access

Navigation Shortcut Keys

Shortcut KeyFunction
TabMove to next field
Shift + TabMove to previous field
HomeBeginning of field
EndEnd of field
Ctrl + HomeFirst record
Ctrl + EndLast record
Page UpPrevious screen
Page DownNext screen
Arrow KeysMove between fields
EnterMove to next field or record

Record Management Shortcuts

Shortcut KeyFunction
Ctrl + Plus (+)Add new record
Shift + EnterSave current record
Ctrl + Minus (-)Delete current record
Ctrl + ;Insert current date
Ctrl + Shift + :Insert current time
Ctrl + 'Copy value from same field in previous record

Form View Shortcuts

Shortcut KeyFunction
F5Go to record number
F6Switch between sections
Shift + F6Move backward through sections
Alt + F8Open Macro dialog box
EscCancel current entry
Shift + EscUndo changes in current record

Table View Shortcuts

Shortcut KeyFunction
F2Edit selected field
Ctrl + ASelect all records
Shift + SpaceSelect current record
Ctrl + SpaceSelect current column
InsertInsert record
Ctrl + EnterInsert new line in Memo field

Query Design Shortcuts

Shortcut KeyFunction
F4Open Property Sheet
F7Open Code Builder
Shift + F2Zoom box for editing
Ctrl + RRefresh query results
Ctrl + GOpen Immediate Window (VBA)

Report Design Shortcuts

Shortcut KeyFunction
F4Property Sheet
Ctrl + PPrint report
Ctrl + RRefresh report
Page UpPrevious page
Page DownNext page

Database Window and Object Shortcuts

Shortcut KeyFunction
F11Show Navigation Pane
Alt + F11Open VBA Editor
Ctrl + GImmediate Window
Ctrl + F6Switch between open objects
Ctrl + TabMove through open objects
Ctrl + Shift + TabReverse through open objects

VBA (Visual Basic for Applications) Shortcuts

Shortcut KeyFunction
F5Run procedure
F8Step through code
Shift + F8Step over procedure
Ctrl + BreakStop execution
Ctrl + GImmediate Window
Ctrl + SpaceAuto-complete
Ctrl + JList properties and methods
Ctrl + Shift + F2Return to previous position

Advanced MS Access Shortcuts

Shortcut KeyFunction
Alt + EnterProperty Sheet
Ctrl + Shift + LToggle Filter
Alt + Down ArrowOpen Combo Box list
Ctrl + Shift + EndSelect to end
Ctrl + Shift + HomeSelect to beginning
Shift + Mouse WheelHorizontal scrolling
Ctrl + Page UpPrevious tab
Ctrl + Page DownNext tab
Ctrl + Shift + F9Recalculate fields
Alt + F8Macro dialog box

Frequently Used Data Entry Shortcuts

Shortcut KeyFunction
Ctrl + ;Current date
Ctrl + Shift + :Current time
Ctrl + 'Copy from previous record
Ctrl + EnterNew line in field
Ctrl + ZUndo typing
Shift + EnterSave record

Tips for Faster Work in MS Access

  1. Use Ctrl + S frequently to save your work.
  2. Learn navigation shortcuts to reduce mouse usage.
  3. Memorize data-entry shortcuts for faster record insertion.
  4. Use F11 to quickly access the Navigation Pane.
  5. Learn VBA shortcuts if you develop Access applications.

Mastering MS Access shortcut keys can dramatically increase your efficiency when working with databases. Beginners should start with basic navigation and editing shortcuts, while advanced users can benefit from VBA, query design, and database management shortcuts.

The more you practice these shortcuts, the faster and more productive you will become in Microsoft Access.