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
