MS Access Complete A–Z Shortcut Reference

Below is a comprehensive list of Microsoft Access keyboard shortcuts organized by category.

Shortcut	Action
Ctrl + N	Create a new database
Ctrl + O	Open an existing database
Ctrl + S	Save current object
F12	Save As
Ctrl + P	Print
Ctrl + W	Close current window
Alt + F4	Exit Microsoft Access
F1	Help

---

File Operations

Shortcut	Action
Ctrl + F4	Close active object
Ctrl + Tab	Switch between open objects
Ctrl + Shift + Tab	Previous open object
Alt + F	Open File menu
Ctrl + Y	Repeat last action

---

Navigation

Shortcut	Action
F6	Next pane
Shift + F6	Previous pane
Tab	Next field
Shift + Tab	Previous field
Home	Beginning of field
End	End of field
Ctrl + Home	First record
Ctrl + End	Last record
Page Up	Previous screen
Page Down	Next screen
Ctrl + Page Up	Previous record
Ctrl + Page Down	Next record

---

Record Operations

Shortcut	Action
Ctrl + +	New record
Shift + Enter	Save current record
Esc	Undo field change
Esc (twice)	Undo record changes
Ctrl + ;	Insert current date
Ctrl + Shift + :	Insert current time
Ctrl + '	Copy value from previous record

---

Editing

Shortcut	Action
Ctrl + C	Copy
Ctrl + X	Cut
Ctrl + V	Paste
Ctrl + Z	Undo
Ctrl + A	Select all
Delete	Delete selection
Backspace	Delete previous character
Insert	Toggle Insert/Overwrite

---

Find & Replace

Shortcut	Action
Ctrl + F	Find
Ctrl + H	Replace
Shift + F4	Find Next

---

Form View

Shortcut	Action
Alt + Down Arrow	Open combo box
Space	Check/Uncheck checkbox
Enter	Move to next field
Shift + Enter	Previous field
Ctrl + Enter	Insert line break

---

Datasheet View

Shortcut	Action
Tab	Next column
Shift + Tab	Previous column
Enter	Next row
Shift + Enter	Previous row
Ctrl + Space	Select column
Shift + Space	Select row
Ctrl + A	Select all records

---

Design View

Shortcut	Action
F4	Property Sheet
F7	Code Builder
Shift + F2	Zoom Box
Alt + Enter	Properties
Ctrl + G	Immediate Window (VBA)

---

Query Design

Shortcut	Action
Alt + Q	Query Tools
Ctrl + R	Run query
Ctrl + L	SQL View
Alt + Enter	Properties

---

Reports

Shortcut	Action
Ctrl + P	Print report
Ctrl + F2	Print Preview
Esc	Exit Print Preview

---

VBA Editor

Shortcut	Action
Alt + F11	Open VBA Editor
F5	Run procedure
F8	Step Into
Shift + F8	Step Over
Ctrl + Break	Stop execution
Ctrl + G	Immediate Window
Ctrl + R	Project Explorer
F4	Properties Window
Ctrl + Space	IntelliSense
Ctrl + J	List Members

---

Ribbon Shortcuts

Shortcut	Action
Alt	Activate Ribbon
Alt + H	Home tab
Alt + C	Create tab
Alt + X	External Data
Alt + Y	Database Tools
Alt + F	File menu

---

Text Editing

Shortcut	Action
Ctrl + Left Arrow	Previous word
Ctrl + Right Arrow	Next word
Ctrl + Backspace	Delete previous word
Ctrl + Delete	Delete next word
Shift + Arrow Keys	Select text
Ctrl + Shift + Arrow	Select word

---

Function Keys

Key	Action
F1	Help
F2	Edit field
F4	Property Sheet
F5	Go To Record
F6	Next pane
F7	Spelling
F8	Extend Selection
F9	Refresh
F11	Navigation Pane
F12	Save As

---

Useful Alt Shortcuts

Shortcut	Action
Alt + Enter	Properties
Alt + Down Arrow	Open dropdown
Alt + Space	Window menu
Alt + Tab	Switch applications
Alt + Print Screen	Screenshot active window

---

Top 20 Most Useful MS Access Shortcuts

Shortcut	Action
Ctrl + N	New Database
Ctrl + O	Open Database
Ctrl + S	Save
Ctrl + F	Find
Ctrl + H	Replace
Ctrl + C	Copy
Ctrl + V	Paste
Ctrl + X	Cut
Ctrl + Z	Undo
Ctrl + A	Select All
Ctrl + ;	Current Date
Ctrl + Shift + :	Current Time
Ctrl + +	New Record
Ctrl + Home	First Record
Ctrl + End	Last Record
F4	Property Sheet
F7	Spelling
F11	Navigation Pane
Alt + F11	VBA Editor
Alt + F4	Exit Access

This collection covers the most commonly used Microsoft Access shortcuts for database management, forms, queries, reports, VBA, and navigation, making it a practical A–Z reference for beginners and advanced users alike.