MS ACCESS SHORTCUT KEYS

MS ACCESS SHORTCUT KEYS 

MS ACCESS SHORTCUT KEYS

MS Access is one most important members of the Microsoft office applications MS Access is a Database Management system that stores data in a very unique way. Microsoft Access is as same as like Microsoft Excel. The most attention-grabbing feature of MS Access is that it manages connected information additional with efficiency than Microsoft Excel. Using this application daily to store and manage information, it's judicious to learn. Microsoft Access short keys learning these shortcuts won't solely save some time however can also perform tasks quickly. Here get the foremost used MS Access Short keys. 

DATABASE MANAGEMENT SHORTCUT KEYS

Ctrl+ N>>                      Open & Create new database

Ctrl+ O>>                      Open an existing database

Alt +F4>>                      Quit and Exit access

Ctrl +P>>                      Print the current object

Ctrl +S>>                      Save a database object

F12>>>>                       Open the save as dialog box

FIND & REPLACE SHORTCUT KEYS

Ctrl+ F>>                      Find & Replace dialog box

Ctrl+ H>>                      Replace dialog box

Shift+ F4>>                  Find next

Alt+ Ctrl+ F>>              to Navigation pane search box

CONTROL FORM SHORTCUT KEYS

Ctrl+ X>>                      Cut

Ctrl+ C>>                      Copy

Ctrl+ P>>                      Paste

⇧>>                                Move selected control up

⇩>>                                Move selected control down

⇦>>                               Move selected control left

⇨>>                               Move selected control right

Shift+⇧>>                     Increase the height of the selected control

Shift+ ⇩>>                    Decrease height of the selected control

Shift+ ⇨>>                            Increase the width of the selected control Shift

Shift+⇦>>                    Decrease width of the selected control Shift

DATABASE MENU SHORTCUT KEYS

Shift+ F10>>                Show shortcut menu

Alt>>                             Show the access keys

Alt+ Space>>               Show the program icon menu

⇧>>                                Select the next command in the menu

⇩>>                                Select the previous command in the menu

⇦>>                               Select the menu to the left

⇨>>                               Select the menu to the right

Home>>                        Select the first command in the menu

End>>                           Select the last command in the menu

DIALOG & TEXT BOX SHORTCUT KEYS

Ctrl+ Tab>>                 Switch to next tab in a dialog box

Ctrl+ Shift+ Tab>>      To Switch the previous tab into a dialog box

Tab>>                           Move to the next option

Shift+ Tab>>               Move to the previous option

Spacebar>>                Select current button

Alt+ ⇩>>                       Open the selected drop-down list box

Esc>>                           Close the selected drop-down list box

Esc>>                           Close the dialog box

Home>>                       Move to the startup of an entry 

Ctrl+ ⇨>>                     Move one word to the right

End>>                           Move to end of an entry

Ctrl+ ⇦>>                     Move one word to the left 

DIALOG & TEXT BOXES SHORTCUTS

Shift+ Home>>            Select from cursor to end

Shift+ End>>               Select from cursor to beginning

Shift+ ⇦>>                             Extend selection one character to the left

Shift+ ⇨>>                             Extend selection one character to the right

WIZARDS SHORTCUT KEYS

Alt+ N>>                       Move to the next page of the wizard

Alt+ B>>                       Move to the previous page of the wizard

Alt+ F>>                       Complete the wizard

SELECT & MOVE FIELDS SHORTCUTS

Tab>>                           Select next field

Shift+ Tab>>               Select previous field

Ctrl+ A>>                      Select all records

F8>>                             Turn on extend mode

Shift+ F8>>                  Undo the previous extension

Esc>>                           Cancel Extend mode

Ctrl+ Space>>             Select current column

Ctrl+ Shift+ F8 >>       Turn on move mode

INSERT DATA SHORTCUT KEYS

Ctrl+;         >>               Insert the current date

Ctrl+ : >>                      Insert the current date

Ctrl+ Alt+ Spacebar>>        to set the default value in working field

Ctrl+ ‘>>                       Insert the value from the same field

Ctrl+ [ ]>>                     Add a new record

Ctrl + (–)>>                   in a datasheet, delete the current record

Shift+ Enter>>             to Save changes in the current record field

Ctrl+ Enter>>               Insert a new line

PIVOT TABLE SHORTCUTS

Tab>>                           Move to the right

Shift+ Tab>>               Move to the left

Enter>>                        Move down

Shift+ Enter>>             Move up

Shift+ Enter>>             the select cell above current cell

Ctrl+ Enter>>               Select detail cell for next item in row

Ctrl+ Shift+ Enter>>   Select detail cell for the previous item in row

Shift+ Arrow keys>>  Expand selection

Ctrl+ A>>                      Select entire pivot table view

Alt+ F4>>                     Close property dialog box

Shift+ F10>>                Display context menu

Alt+ Enter>>                Display property dialog box

Esc>>                           Cancel refresh operation in progress

Ctrl+ E>>                      Export contents to Excel

Ctrl+ 8>>                      Toggle expand indicators

Alt+ ⇩>>                       Open list of currently selected item

Ctrl+ T >>                     Toggle Auto filter

Ctrl+ Shift+ A>>          Sort data ascending (a-z)

Ctrl+ Shift+ Z>>          Sort data descending (z-a)

Alt+ Shift+⇧>>             Move selected member up

Alt+ Shift+⇩>>             Move selected member down

Ctrl+ L>>                      Display field list pane

Alt+ Shift+ ⇨>>           Move selected member right

Alt+ Shift+ ⇦>>           Move selected member left

Ctrl+ Shift+ S>>          Add new total field using sum summary

Ctrl+ Shift+ C>>          Add new total field using count summary

Ctrl+ Shift+ M>>          Add new total field using min summary

Ctrl+ Shift+ X>>          Add new total field using max summary

Ctrl+ Shift+ E>>          Add new total field using average summary

Ctrl+ Shift+ D>>          Standard deviation summary

Ctrl+ Shift+ T>>          Standard deviation population summary

Ctrl+ Shift+ B>>          Turn subtotals & grand totals on/off

Ctrl+ F>>                      Add calculated detail field

Ctrl+ 4>>                      Move the selected field to detail area

Ctrl+ 1>>                      Move the selected field to row area

Ctrl+ 2>>                      Move the selected field to column area

Ctrl+ ⇦>>                     Move selection up one level

Ctrl+ ⇨>>                     Move selection down one level

Ctrl+ Shift+ (~)>>        Apply the general number format

Ctrl+ Shift+ ($)>>        Apply the currency format to values

Ctrl+ Shift+ (%)>>       Apply the percentage format to values

Ctrl+ Shift+ (^)>>        Apply the exponential number format

Ctrl+ Shift+ (#)>>        Apply the date format to values

Ctrl+ Shift+ (@)>>       Apply the time format

Ctrl+ Shift+ (!)>>         Apply the numeric format

Ctrl+ I>>                       Make text italic

Ctrl+ B>>                      Make text bold

Ctrl+ U>>                      Make text underlined

WINDOWS MANAGEMENT SHORTCUT KEYS

F11>>                           Toggle the navigation pane

Ctrl+ F6>>                    Cycle between open windows

Alt+ Spacebar>>        Display the control menu

Shift +F10>>                Display the shortcut menu

Ctrl+ W>>                     Close the active window

Alt+ F11>>                             Switch between two windows

PRINT PREVIEW SHORTCUT KEYS

Ctrl+ P>>                      Open the print dialog box

S>>                               Open the page setup dialog box

C>>                               Cancel print

EXTRA SHORTCUT KEYS

F2>>                             Display hyperlink

F7>>                             Check to spell

Shift+ F2>>                  Open the zoom box

Alt +Enter>>                Display a property sheet in design view

Ctrl= F2>>                    Invoke builder

It is very difficult to remember all the shortcut keys at once. But keep practicing daily will heighten your efficiency as well as save your time and energy. Microsoft Access can be used to develop application software.