Search This Blog

Sunday, February 12, 2012

access 2003 shortcuts keys

general shortcuts_1

access 2003  shortcuts keys, access shortcuts keys, ctrl + n ===== new database
ctrl + o ===== open
alt + f4 ===== quit/exit 
ctrl + p ===== print
p/ctrl + p ===== print dialog box open
s ===== page setup dialog box open
c/esc ===== cancel layout preview/print preview 
ctrl + s/shift + f12/alt + shift + f2 ===== save
f12/alt + f2 ===== save as 
f4/alt + down arrow ===== combo box open
f9 ===== lookup field list box/combo box refresh
down arrow ===== one line move down
page down ===== one page move down
up arrow ===== one line move up 
page up ===== one page move up 
tab ===== combo box/list box exit

general shortcuts_2

ctrl + f ===== find/search
ctrl + h ===== replace tab in find & replace dialog box open
shift + f4 ===== (datasheet view and form view only) find & replace dialog box when the dialog box is closed 

general shortcuts_3

f2 ===== switching edit mode 
f4 ===== switching to property sheet 
f5 ===== form design view switching to form view from 
f6 ===== (design view of tables, macros, queries & advanced filter/sort window only) switching between upper & lower portions of a window 
f7 ===== (design view window/property sheet) switching to code builder from form/report design view 
shift + f7 ===== switching from report design view/visual basic editor to form
alt + v + p ===== property sheet for selected object open

general shortcuts_4

shift + enter ===== control to section add 
ctrl + c ===== copy 
ctrl + x ===== cut 
ctrl + v ===== paste
ctrl + right arrow ===== selected control to right move 
ctrl + left arrow ===== selected control to left move 
ctrl + up arrow ===== selected control up move 
ctrl + down arrow ===== selected control down move 
shift + down arrow ===== height of selected control increase 
shift + right arrow ===== width of selected control increase 
shift + up arrow ===== height of selected control reduce 
shift + left arrow ===== width of selected control reduce 

general shortcuts_5

f11 ===== bring database window to front
ctrl + f6 ===== cycling between open windows
enter ===== restore selected minimized window 
ctrl + f8 ===== turn on re-size mode for active window 
alt + spacebar ===== control menu display 
shift + f10 ===== shortcut menu display 
ctrl + w/ctrl + f4 ===== close 
alt + f11 ===== switching between previous active window & visual basic editor
alt + shift + f11 ===== from the previous active window, switching to the microsoft script editor 

general shortcuts_6

tab ===== help  button in the wizard move
alt + n ===== next window in the wizard move
alt + b ===== previous window in the wizard move
alt + f ===== wizard window close
f2 ===== complete hyperlink address for a selected hyperlink display
f7 ===== spelling check 
shift + f2 ===== other text in small input areas & zoom box to conveniently enter expressions open
alt + enter ===== property sheet in design view, display
alt + f4 ===== quit
ctrl + f2 ===== a builder invoke
ctrl + f11 ===== toggling between built-in menu bar & custom menu bar
ctrl + right arrow/crtl + , (comma) ===== toggling forward between views when in a view , pivot table list, pivotchart report, stored procedure, table, query, form, report, page, access project (.adp) function
ctrl + left arrow/crtl + . (period) ===== toggling back between views when in a view, pivot table list, pivot chart report, stored procedure,  table, query, form, report, page, .adp function

general shortcuts_7

f2 ===== rename
down arrow ===== one line move down
page down ===== one window move down
end ===== last object move
up arrow ===== one line move up 
page up ===== one window move up 
home ===== first object move 
ctrl + tab ===== cycling through objects bar top to bottom
shift + ctrl + tab ===== cycling through objects bar bottom to top
enter/alt + o ===== selected form in form view/table/query in datasheet view open
enter ===== selected report in print preview, open
enter ===== selected data access page in page view, open
enter ===== selected macro run
ctrl + enter/alt + d ===== selected module in design view/table, query, form, report, data access page, macro open
alt + n ===== a new table, query, form, report,  module, data access page, macro, create 
f5 ===== database window refresh
ctrl + g ===== immediate window in visual basic editor, display 

general shortcuts_8

shift + f10 ===== shortcut menu show
f10 ===== menu bar active make
alt + spacebar ===== (on the program title bar) program icon menu show 
down/up arrow ===== with submenu/menu is visible, to select previous/next command
left/right arrow ===== select menu to right/left; when a submenu is visible, to switching between submenu & main menu
home/end ===== select last/first command on submenu/menu
alt ===== visible submenu & menu at same time close
esc ===== visible with a submenu visible, to close submenu only/menu close
ctrl + tab/ctrl + shift + tab ===== previous/next toolbar select
tab/shift + tab ===== when a toolbar is active, to select menu on the toolbar/previous or next button
enter ===== open menu, when a menu on a toolbar is selected/when a button is selected, to perform action assigned to a button

general shortcuts_9

alt + tab ===== switching next program
alt + shift + tab ===== switching previous program
ctrl + esc ===== show windows start menu
ctrl + w ===== active database window close
ctrl + f6 ===== switching next database window
ctrl + shift + f6 ===== switching previous database window
enter ===== restore selected minimized window 
ctrl + tab/ctrl + page down ===== switching next tab in a dialog box
ctrl + shift + tab/ctrl + page up ===== switching previous tab in a dialog box
tab ===== move to option group/next option 
shift + tab ===== move to option group/previous option
arrow keys ===== move between some options in a group of options/options in the selected drop-down list box
spacebar ===== (select/clear the check box) perform the action assigned to the selected button
alt + letter key ===== select to select/option/clear the check box 
alt + down arrow ===== selected drop-down list box open 
esc ===== selected drop-down list box close
enter ===== in dialog box, perform the action assigned to the default button 
esc ===== close dialog box & cancel command
alt + f4 ===== dialog box close

general shortcuts_10

home ===== move to beginning of entry
end ===== move to end of entry
left/right arrow ===== move one character to right/left
ctrl + left/right arrow ===== move one word to right/left
shift + home ===== from insertion point to beginning of entry select
shift + end ===== from insertion point to end of entry select
shift + left arrow ===== one character to left select
shift + right arrow ===== one character to right select
ctrl + shift + left arrow ===== one word to left select
ctrl + shift + right arrow ===== one word to right select

general shortcuts_11

alt + 1 ===== go to previous folder
alt + 2 ===== open folder up one level 
alt + 3 ===== close dialog box & open web search page 
alt + 4 ===== delete selected file/folder 
alt + 5 ===== create a new subfolder in open folder 
alt + 6 ===== switching between properties,  list, details & preview views
alt + 7 ===== show tools menu 

general shortcuts_12

f6 ===== from another pane, move to a task pane 
ctrl + tab ===== when a toolbar/menu is active, move to a task pane
tab/shift + tab ===== in the task pane, when a task pane is active, select previous/next option 
ctrl + down arrow ===== on the task pane menu, display the full set of commands 
down/up arrow ===== move among choices in a selected submenu/certain options in a group of options
spacebar/enter ===== open selected menu/perform selected button's   action assigned
shift + f10 ===== open a shortcut menu/drop-down menu for selected gallery 
home/end ===== when a submenu/menu is visible, select last/first command on submenu/menu
page up/down ===== in selected gallery list, scroll up/down 
ctrl + home/end ===== move to bottom/top of selected gallery list

general shortcuts_13

f1 ===== help task pane display
f6 ===== switching between help task pane & active application
tab ===== in help task pane, select next item 
shift + tab ===== in help task pane, select previous item 
enter ===== perform action for selected item
down/up arrow ===== in a table of contents, select previous & next item
right/left arrow ===== in a table of contents, collapse & expand selected item
alt + left arrow ===== move back to previous task pane
alt + right arrow ===== move forward to next task pane
ctrl + spacebar ===== menu of pane options open 
ctrl + f1 ===== current task pane close & re-open 
right arrow ===== + /- list expand 
left arrow ===== + /- list collapse 

general shortcuts_14

tab ===== select next hidden hyperlink, text, show/hide all at top of a topic
shift + tab ===== select previous hidden hyperlink, text, browser view button at top of a microsoft office web site article
enter ===== perform action for selected item
alt + left arrow ===== move back to previous help topic
alt + right arrow ===== move forward to next help topic
ctrl + p ===== current help topic print 
up/down arrow ===== scroll small amounts up & down, within currently displayed help topic
page up/page down ===== scroll larger amounts up & down, within  currently displayed help topic
alt + u ===== change /separate from (untiled) active application
shift + f10 ===== display a menu of commands for help window

general shortcuts_15

alt + f + d + a ===== send active database object as an e-mail message
ctrl + shift + b ===== address book open 
alt + k ===== check address book's names in to, cc, bcc boxes 
tab ===== select next box in e-mail header/body of message 
shift + tab ===== select previous field/button in e-mail header
shift + right arrow ===== extend one character to right
ctrl + shift + right arrow ===== extend one word to right
shift + left arrow ===== extend one character to left
ctrl + shift + left arrow ===== extend one word to left

general shortcuts_16

tab ===== select next field
f2 ===== switching between edit & navigation mode
shift + spacebar ===== in navigation mode, switching between selecting current record & first field of current record
shift + up arrow ===== extend selection to previous record
shift + down arrow ===== extend selection to next record
ctrl + a/ctrl + shift + spacebar ===== select all records
f8 ===== turn on extend mode 
left/right arrow ===== in the same row in datasheet view, extend a selection to adjacent fields 
up/down arrow ===== in datasheet view, extend a selection to adjacent rows 
shift + f8 ===== undo previous extension
esc ===== extend mode cancel 

general shortcuts_17

ctrl + spacebar ===== in navigation mode only, select/cancel column selection
shift + right arrow ===== select column to right
shift + left arrow ===== select column to left
ctrl + shift + f8 ===== turn on move mode
right arrow ===== move one character to right
ctrl + right arrow ===== move one word to right
left arrow ===== move one character to left
ctrl + left arrow ===== move one word to left
end ===== in single-line fields, move it to end of field
ctrl + end ===== in multiple-line fields, move it to end of field 
home ===== in single-line fields, move it to beginning of field
ctrl + home ===== in multiple-line fields, move it to beginning of field

general shortcuts_18

backspace ===== delete selection/left character 
delete ===== delete selection/right character 
ctrl + delete ===== delete all characters to right
ctrl + z/alt + backspace ===== typing undo
esc ===== undo changes in current field/record
ctrl + ; ===== insert current date
ctrl + shift + ; ===== insert current time
ctrl + alt + spacebar ===== insert default value for a field
ctrl + ' ===== insert value from same field in previous record
ctrl + + ===== a new record add 
ctrl + - ===== current record delete 
shift + enter ===== save
spacebar ===== switching between values in a option button/check box
ctrl + enter ===== a new line insert 
f9 ===== in window, recalculate fields 
shift + f9 ===== in a subform, requery underlying tables
f9 ===== refresh contents of a lookup field list box/combo box

general shortcuts_19

f2 ===== switching between edit mode & navigation mode
f4 ===== switching to property sheet 
f5 ===== switching to form view/form design view
f6 ===== switching between lower & upper portions of a window 
f7 ===== switching to code builder from form/report design view 
f8 ===== invokes field list in a data access page, form, report
shift + f7 ===== switching from report design view/visual basic editor to form
shift + f7 ===== switching from a control's property sheet in form/report design view
alt + enter ===== in design view, display a property sheet 
enter/alt + o ===== in form view, open selected form 
ctrl + enter/alt + d ===== in design view, open selected report, data access page, macro,  table, query, form,  module 
ctrl + tab ===== with focus set to a section
shift + enter ===== a control to a section add 
right arrow ===== move selected control to right by a pixel along page's grid
left arrow ===== move selected control to left by a pixel along page’s grid
up arrow ===== move selected control up by a pixel along page’s grid
down arrow ===== move selected control down by a pixel along page’s grid
ctrl + right arrow ===== move selected control to right by a pixel 
ctrl + left arrow ===== move selected control to left by a pixel 
ctrl + up arrow ===== move selected control up by a pixel 
ctrl + down arrow ===== move selected control down by a pixel
shift + right arrow ===== increase width of selected control by a pixel
shift + left arrow ===== decrease width of selected control by a pixel
shift + up arrow ===== decrease height of selected control by a pixel
shift + down arrow ===== increase height of selected control 
shift + tab ===== when sending a page as an e-mail, move focus from page design surface to address/subject dialog box 
esc ===== move focus from field list/data outline back to data access page design surface

general shortcuts_20

f5 ===== move to record number box; then type record number & press enter
tab/right arrow ===== move to next field
end ===== in navigation mode, move to last field in current record
shift + tab/left arrow ===== move to previous field
home ===== in navigation mode, move to first field in current record
down arrow ===== move to current field in next record
ctrl + down arrow ===== in navigation mode, move to current field in last record
ctrl + end ===== move to the last field in the last record, in navigation mode
up arrow ===== move to current field in previous record
ctrl + up arrow ===== in navigation mode, move to current field in first record
ctrl + home ===== in navigation mode, move to first field in first record

general shortcuts_21

page down ===== go down 1screen
page up ===== go up 1 screen
ctrl + page down ===== go right 1 screen
ctrl + page up ===== go left 1 screen
f5 ===== from sub-data sheet to move to record number box
ctrl + shift + down arrow ===== from datasheet to expand record’s sub-data sheet
ctrl + shift + up arrow ===== collapse sub-data sheet
tab ===== enter sub-data sheet from last field of previous record in  data sheet
shift + tab ===== enter sub-data sheet from first field of following record in data sheet
ctrl + tab ===== exit sub-data sheet & move to first field of next record in data sheet
ctrl + shift + tab ===== exit sub-data sheet & move to last field of previous record in data sheet
tab ===== from last field in sub-data sheet to enter next field in data sheet
down arrow ===== from data sheet to bypass sub-data sheet & move to next record in datasheet
up arrow ===== from datasheet to bypass sub-data sheet & move to previous record in data sheet

1 comment:

thanks for the comments & the moment