MS Access | Shortcut Keys

Task to perform

Shortcut Key

Open the Home tab

Alt+H

Display the shortcut menu for the selected item

Shift+F10

Show or hide a property sheet

F4

Switch between Edit mode and Navigation mode in the Datasheet or Design view

F2

Switch to Form view from the form Design view

F5

Move to the next or previous field in the Datasheet view

Tab or Shift+Tab

Go to a specific record in the Datasheet view

Alt+F5

Open the Print dialog box from Print (for da    tasheets, forms, and reports)

Ctrl+P

Open the Page Setup dialog box (for forms and reports)

S

Zoom in or out on a part of the page

Z

Open the Find tab

Ctrl+F

Open the Replace tab

Ctrl+H

Add a new record in Datasheet view or Form view

Ctrl+Plus Sign (+)

Open the Help window

F1

Exit Access

Alt+F4

Open the File page

Alt+F

Open the Home tab

Alt+H

Open the Create tab

Alt+C

Open the External Data tab

Alt+X or Alt+X,1

Open the Database Tools tab

Alt+Y

Open the Fields tab

Alt+J, B

Open the Table tab

Alt+J, T

Open a New Database

Ctrl+N

Open an Existing Database

Ctrl+O or Ctrl+F12

Show KeyTips

Alt or F10

Close the Active Database Window

Ctrl+W or Ctrl+F4

Switch between the Visual Basic Editor and the previous active window

Alt+F11

Maximize or Restore a selected window.

Ctrl+F10

Text Box Editing

Move to the beginning of the entry

Home

Move to the end of the entry

End

Move one character to the left or right

The Left or Right Arrow

Move one word to the left or right

Ctrl+Left Arrow or Ctrl+Right Arrow

Select from the insertion point to the beginning of the text

Shift+Home

Select from the insertion point to the end of the text

Shift+End

Change the selection by one character to the left

Shift+Left arrow

Change the selection by one character to the right

Shift+Right arrow

Change the selection by one word to the left

Ctrl+Shift+Left Arrow

Change the selection by one word to the right

Ctrl+Shift+Right Arrow

Combo or List Box

Open a Combo Box

F4 or Alt+Down Arrow

Move down one line

Down Arrow

Move down one page

Page Down

Move up one line

Up Arrow

Move up one page

Page Up

Exit the combo box or list box

Tab key

Navigate between Fields and Records

Move to the next field

Tab key or Right Arrow

Move to the last field in the current record

End

Move to the previous field

Shift+Tab or Left Arrow

Move to the first field in the current record

Home

Move to the current field in the next record

Down Arrow

Move to the current field in the last record

Ctrl+Down Arrow

Move to the last field in the last record

Ctrl+End

Move to the current field in the previous record

Up Arrow

Move to the current field in the first record

Ctrl+Up Arrow

Move to the first field in the first record

Ctrl+Home

Go to a specific record

Alt+F5

Enter data in a Datasheet or Form view

Insert the current date

Ctrl+Semicolon (;)

Insert the current time

Ctrl+Shift+Colon (:)

Insert the default value for a field

Ctrl+Alt+Spacebar

Insert the value from the same field in the previous record

Ctrl+Apostrophe (')

Add a new record

Ctrl+Plus Sign (+)

In a datasheet, delete the current record

Ctrl+Minus Sign (-)

Save changes to the current record

Shift+Enter

Switch between the values in a check box or option button

Spacebar

Insert a new line in a Short Text or Long Text field

Ctrl+Enter