MS ACCESS shortcut keys

MS ACCESS

General shortcut

Ctrl +  N - To Open or create new database
Ctrl + O  - To Open the existing database
Ctrl + P    - To Print the current and

 selected object
Ctrl + S - To Save the  database object
F12  - To Open the Save as  dialog box
Alt + F4  - To Quit and exit to the  Access
Ctrl + F - To Find and replace dialog box

Ctrl + H -  To replace the dialog box

Ctrl + F4   - To find next

Ctrl + x -  To cut

Ctrl + C  - To copy

Ctrl + V  - To paste

Arrow keys  - To move the selected contents

Ctrl + P + S   - To open the page setup of dialog

box

Ctrl + P + C   - To cancel the print command or

layout preview

F2 - To display the hyperlink

F7 - To check the spelling mistakes

Shift + F2 - To open the zoom box

Shift + F10 - To show the context menu

Alt + enter - To open the display properties

sheet in design view
Menus

Shift + F10 - To open the shortcut menu

Alt - To show the access key

Alt + space - To show the program icon menu

Arrow down - To use to select the next

command in menu

Arrow up - To select previous command in

menu

Arrow left and - To select the menu to the left or

right right

Home Tab - To select the first command in

menu

End Tab - To select the last command in

menu

Alt - To close the visible menu or

submenu at the same time

ESC - To close the visible menu only

Dialog box

Ctrl +Tab  - To switch to next tab in dialog

box

Ctrl + shift + Tab -  To switch to previous tab in

dialog box

Shift + Tab - To switch to previous option or

option group

Tab - To move to the next option or

option group

Arrow keys -  To move between options

Space - To select the current button

Alt + arrow down - To open the selected drop down

list box

ESC - To close  the selected drop

down list box

Enter - To perform the action assigned

to the default button in the

dialog box

ESC - To close the command and close the dialog box

Alt + F4 - To close the dialog box

Text boxes

Home Tab - To move to the beginning of an entry

End Tab -  To move to the end  of an entry

Ctrl + arrow left - To move one word to the left

Ctrl + arrow right - To move one word to the right

Shift + home - To select from the corser to the end

Shift + end  - To select from the corser to the beginning

Shift + arrow left -  To extend the selected one word to the left

Shift + arrow right  - To extend the selected one word to the right

Field list pane

Alt + F8 -  To toggle the field list pane

Arrow up - To move up the field list pane

Arrow down -  To move down the field list pane

Shift + Tab - To move to the upper field list pane from the lower pane

Tab - To move to the lower field list pane from the upper pane.

Text and data

Arrow right - To move cursor to the one character  to the right

Arrow left - To move cursor to the one character  to the left

Ctrl + arrow left - To move the cursor to the one word to the left

Ctrl + arrow right - To move the cursor one word to the right

Home Tab - To move the cursor to the beginning

End Tab -  To move the cursor to the end of the field

Ctrl +delete –  To delete all the character to the right of the insertion point

Ctrl + Z –  to undo the last change  

Ctrl + Y – to redo the last change

Ctrl +; –  To insert the current date

Ctrl + : – TO insert the current time

Ctrl + Alt + space – TO insert the default value for a field

Esc – To cancel or undo changes in the current field or current record

Ctrl + ‘ –  To insert the value from the same field in the previous record

Ctrl +  + – To add a new record

Ctrl + -  – TO delete the current record in a database

Shift + Enter – TO save changes to the current record

Space – To switch between the values in a check box or option button

Ctrl + Enter – To insert  a new line

Design

F7 – TO open the visual basic  editor from a selected property in the property sheet for a form or report

Alt + F8 – To invokes the field list pane in a from , report , or data access page . If the field list pane is already open focus moves to the field list pane

Shift + F7 –  To switch form or report design view ( from visual basic Editor with code module open)

Alt + Enter – TO display a property sheet

Arrow keys – TO move selected control  up /down /left /right along the rigid

Ctrl + arrow keys – To move selected control in any direction by one pixel

Shift +arrow down – To increase hight of the selected control

Shift +arrow up  – To decrease hight of the selected control

Shift +arrow right   – To increase hight width  of the selected control

Shift +arrow left   – To decrease width of the selected control

Data sheet, sub datasheet and form view

F5 – To move the record number box, type in number and press enter

Tab – TO move the next field in current record

Shift +Tab  - TO move to the previous field in current record

Home – TO move to first  field in current record

End – TO move to last field in current record

Arrow down – TO move the next record

Arrow up – To move to previous record

Ctrl +arrow down – TO move to the last record

Ctrl +arrow up – TO move to the first record

Ctrl + home – TO move to first field in first record

Ctrl + end -   TO move to last field in last record

Page down – TO move down the one screen

Page up  – TO move up  the one screen

Ctrl  + Page up  – TO move left  the one screen

Ctrl  + Page down   – TO move right  the one screen

Ctrl + Tab – To exit to next record

Ctrl + shift + Tab –  To exit to the previous record

Ctrl + shift + arrow down  – To expend sub datasheet

Ctrl + shift + arrow up   – To collapse sub datasheet

Data diagram

Esc – To move from a table cell to the table’s title bar

Enter – TO from a table’s title bar to the last cell you edited

Tab – To move table title bar to table title bar ,or from cell to cell inside a table

Alt + arrow down – expand a list inside a table

Arrow down – To move  up in a list

Arrow up -  To move down in a list

Space – To change the setting in a check box

Home – To go to first cell in row

End – TO go to last cell in row

Page down – To go to next page of the diagram

Page up – To go to previous page of the diagram

Query designer  

F6 – TO move forward among the Query designer panes

Shift + F6 – To move backward among the Query designer panes

Tab – To move forward among tables , views functions, or join line.

Shift + Tab – TO move backward among tables, views , functions or join line.

Arrow keys – To move to between columns in a tables, view or function

Space – To choose the selected data column for output

Delete – TO remove the selected table, view function or join line

F2 – In Grid pane : toggle between edit mode and cell selection mode

Insert – TO insert row between existing columns

Pivot table

Tab – TO move to the right

Shift + Tab – To move to the left

Enter – TO move down

Shift + enter – To move up

Ctrl + enter –  To detail cell for next item in row

Ctrl + shift +  enter – To detail cell for previous  item in row

Shift + arrow keys – TO expand selection

Ctrl + A – To select entire pivot table view

Shift + F10 – TO display context menu

Alt + enter – To display property dialog box

Alt + F4  - To close property dialog box

Esc – TO cancel refresh operation in progress

Ctrl + E – To export contents to Excel

Ctrl + 8 – To toggle expand the indicator

Alt + arrow down –  To open list for currently selected item

Ctrl +T –  To toggle the auto filter

Ctrl + shift + A – To sort data ascending (A-z )

Ctrl + shift + Z –  To sort data in descending order  (A-z )

Alt +shift +arrow up – To move selected member up  

 Alt +shift +arrow down  – To move selected member down

Ctrl + L – To display field line pane

Ctrl + shift +s - To add new total field using for sum summary

Ctrl + shift + c – To add new total field using count summary

Ctrl + shift +M – To add new total field using min summary

Ctrl  + Shift  + X – To add new total field using max summary

Ctrl + shift + E – To add new total field using average summary

Ctrl + shift + D – To add new total field using standard deviation summary

Ctrl + shift + T – TO add new total field using standard deviation population

                                                           Summary

Ctrl + shift + B – To turn subtotals and grand totals on or off for selected field

Ctrl + F  - TO add a calculated detail field

Ctrl + 1 – To move selected field to row area

Ctrl + 2 – To move selected field to column area

Ctrl + 3- To move selected field to filter area

Ctrl + 4 – To move selected field to detail area

Ctrl + arrow left – To move selection up one level

Ctrl + arrow right – To move selection down one level

Ctrl + shift +  ~ – To apply for general number format to values

Ctrl + shift + $ - To apply to currency format to values

Ctrl + shift +% - To apply the percentage format to values

Ctrl + shift + ^ - To apply the exponential number format to values

Ctrl  + shift + # - To apply the data format to values

Ctrl + shift + @ - To apply the time format , with the hour, minute , and AM or PM

                             ,to values in the selected total or detail field

Ctrl + B – make text bold in the selected field of the pivot table view

Ctrl + U – To make text underlined in the selected field of the pivot table view

Ctrl + I – To make text italic in the selected field of the pivot table view



If anyone interested in craft then go my youtube chenal crafty diy

https://bit.ly/2M6R6ym