51 Shortcuts for Access 2016

Jump to: Database Operation, Windows/Content Switching/Navigation, Design/Content Operation(on selected control)

1. Database Operation

Ctrl+N

New database

Ctrl+O

Open existing database

Ctrl+S/Shift+F12

Save Database

Tab

Move to next cell

F12

Open the Save As Box

Ctrl+P

Print the current object

Ctrl+F

Open Find tab in dialog box

Ctrl+H

Open Replace tab in dialog box

2. Windows/Content Switching/Navigation

Arrow Down

Move down a line

Arrow Up

Move Up a line

PgUp

Move up a page

PgDn

Move down a page

F4

Switch to propery sheet

F2

Switch betwwn edit mode

F6

Switch windows(between upper and lower portion)

F5

Switch to form view from form design view

F7

Open VB Editor/Open the choose builder dialog box

Alt+F11

Switch from the VB editor back to form

F11

Toggle between Navigation Pane

Ctrl+F6

Cycle between windows

Enter

Restore the window

Alt+Space

Display Control Menu

ShortcutMenuKey

Display shortcut menu(key exist on right of Alt Rt)

Alt+N

Move to next page of wizard

Alt+B

MOve to previous page of wizard

Alt+F

Complete the wizard

Home

Move to beginning

End

Move to End

Ctrl+Tab

Switch to the next tab in dialog box

Ctrl+Shift+Tab

Switch to the previous tab in dialog box

3. Design/Content Operation(on selected control)

Ctrl+C

Copy

Ctrl+V

Paste

Ctrl+X

Cut

Arrow Right/Ctrl+Arrow Right

Move to Right

Arrow Left/Ctrl+Arrow Left

Move to Left

Arrow Up/Ctrl+Arrow Up

Move to Up

Arrow Down/Ctrl+Arrow Down

Move to down

Shift+Arrow Down

Increase the height

Shift+Arrow Up

Decrease the height

Shift+Arrow Right

Increase the width

Shift+Arrow Left

decrease the width

F2

Display complete hyperlink

F7

Check Spelling

Alt+Enter

Display Property sheet

Alt+F4

Exit access 16

Ctrl+F2

Invoke builder

Shift+F2

Open the zoom box

Ctrl+Z/Alt+ Bkspace

Undo

Ctrl+Delete

Delete all character to the right

F5

Move the record number box

Created by rank17 on 2/9/2017. Last updated by guest on 1/1/2010

 

8 Comments for 'Access 2016'   

 
Email me replies   

Comment #8 by vbrat Aug 13, 2015 at 10:13 am  Reply

To sort a column in datasheet view: 1. Move to the column you want to sort 2. Select the column (Ctrl + space) 3. Display the dropdown menu (Alt + down)

Comment #7 by guru Jul 14, 2015 at 03:33 am  Reply

It is nice learn with excel so nice shark-at keys in hear ,,, nice ..,,

Comment #6 by Crystal Schneider Aug 19, 2014 at 10:42 am  Reply

I am working in an access table entering data and the extended mode got turned on in the process of me trying to turn it off i also changed the way the entries are entered. They now all pop to the top after i unselect the row. Does any one know what iu have done?!

Comment #5 by Shannon May 5, 2014 at 08:52 pm  Reply

Does anyone know, when in datasheet view of an MS access table and you have a list box of items to select from, using the keyboard how can you cycle through it? i know on a webpage you tab to the list box and use the arrow keys (up and down), however, up and down in the datasheet view goes up to the next record and vise versa?

Reply #1 Chocka May 27, 2014 at 08:06 pm

when on table field with list of items, press ALT+arrow down to open up the listNavigate up and down using the up and down arrow key; press Enter to select the item of your choice

Comment #4 by Shariff Oct 14, 2013 at 12:12 pm  Reply

Thanks a lot for providing a list of detailed shortcuts for different OS environments.
It is very helpful and easy to work with using these shortcuts when you have multiple tasks to perform with less time.

Comment #3 by stutigupta Jun 18, 2013 at 06:49 am  Reply

seriously its awsm.......these are very usefull ...

Comment #2 by Dilawar katawazai Jan 9, 2012 at 10:08 am  Reply

Very good all the best this shurt cuts

Reply #1 dinesh Jul 19, 2013 at 08:15 am

yes this is very very useful for a person who reagurly working on pc

Comment #1 by drifter Jan 2, 2012 at 08:18 pm  Reply

The Access short cuts are are very comprehensive. That said, I am looking for a keyboard shortcut to select a join line between two tables within a Query Design View Diagram so that the Join Properties can be edited. Didn't see it in the current page. Any ideas?

icon

Access Shortcuts

Advertising for Consideration:

Ads for Consideration:

Related:

Please kindly review and accept Terms of Use and Cookie & Policy Policy