By | August 14, 2017
MS Access

MS access Shortcuts. Microsoft get right of entry to is a database management system (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software program-development gear. it’s miles a member of the Microsoft office suite of applications, protected inside the professional and better variants or bought one at a time. Microsoft get right of entry to shops data in its very own format primarily based on the access Jet Database Engine. it may also import or link directly to records saved in different packages and databases.


MS Access Shortcut Keys

Ctrl + N Open a new database Opening databases
Ctrl + O Open an existing database Opening databases
Ctrl + P Print the current or selected object Printing and saving
S Open the Page Setup dialog box from Print Preview Printing and saving
Esc Cancel Print Preview or Layout Preview Printing and saving
Ctrl + S Save a database object Printing and saving
F12 Open the Save As dialog box Printing and saving
F4 Open a combo box Using a combo box or list box
F9 Refresh the contents of a Lookup field list box or combo box Using a combo box or list box
Bottom Arrow Move down one line Using a combo box or list box
PgDN Move down one page Using a combo box or list box
Top Arrow Move up one line Using a combo box or list box
PgUp Move up one page Using a combo box or list box
Tab Exit the combo box or list box Using a combo box or list box
Ctrl + F Open the Find tab in the Find and Replace dialog box Finding and replacing text or data
Ctrl + H Open the Replace tab in the Find and Replace dialog box Finding and replacing text or data
Shift + F4 Find the next occurrence of the text specified in the Find and Replace dialog box when the dialog box is closed Finding and replacing text or data
F2 Switch between Edit mode and Navigation mode in a datasheet. Working in Design view
F4 Switch to the property sheet Working in Design view
F5 Switch to Form view from form Design view Working in Design view
F6 Switch between the upper and lower portions of a window Working in Design view
F7 Open the Choose Builder dialog box Working in Design view
Shift + F7 Switch from the Visual Basic Editor back to form or report Design view Working in Design view
Ctrl + C Copy the selected control to the Clipboard Editing controls in form and report Design view
Ctrl + X Cut the selected control and copy it to the Clipboard Editing controls in form and report Design view
Ctrl + V Paste the contents of the Clipboard in the upper-left corner of the selected section Editing controls in form and report Design view
F2 Display the complete hyperlink address for a selected hyperlink Miscellaneous
F7 Check spelling Miscellaneous
Shift + F2 Open the Zoom box to conveniently enter expressions and other text in small input areas Miscellaneous
Alt + Enter Display a property sheet in Design view Miscellaneous
Alt + F4 Exit Access Miscellaneous
Ctrl + F2 Invoke a Builder Miscellaneous
Shift + F10 Show the shortcut menu Work with menus
F10 Show the access keys Work with menus
Alt + Space Show the program icon menu Work with menus
Home Select the first on the menu or submenu Work with menus
Alt Close the visible menu and submenu at the same time Work with menus
Alt + Tab Switch to the next program Using a program window
Alt + Shift + Tab Switch to the previous program Using a program window
Ctrl + Esc Show the Windows Start menu Using a program window
Ctrl + W Close the active database window Using a program window
Ctrl + F6 Switch to the next database window Using a program window
Enter Restore the selected minimized window when all windows are minimized Using a program window
Home Move to the beginning of the entry Editing in a text box
End Move to the end of the entry Editing in a text box
Shift + Home Select from the insertion point to the beginning of the entry Editing in a text box
Shift + End Select from the insertion point to the end of the entry Editing in a text box
Shift + Left Arrow Change the size of the selection by one character to the left Editing in a text box
Shift + Right Arrow Change the size of the selection by one character to the right Editing in a text box
Ctrl + Shift + Left Arrow Change the size of the selection by one word to the left Editing in a text box
Ctrl + Shift + Right Arrow Change the size of the selection by one word to the right Editing in a text box
Alt + 1 Go to the previous folder Work with the Open File
Alt + 2 Open the folder up one level from the open folder Work with the Open File
Delete Delete the selected folder or file Work with the Open File
Alt + 4 Create a new subfolder in the open folder Work with the Open File
Alt + 5 Switch between Thumbnails, Tiles, Icons, List, Details, Properties, and Preview views Work with the Open File
Alt + L Show the Tools menu Work with the Open File
F4 Toggle the property sheet tab Work with property sheets
Bottom Arrow Move among choices in the control drop-down list one item at a time Work with property sheets
Tab Move to the property sheet tabs from the control drop-down list Work with property sheets
Shift + Tab With a property selected, move up one property on a tab; or if already at the top, move to the control drop-down list Work with property sheets
Ctrl + Tab Toggle forward between tabs when a property is selected Work with property sheets
Ctrl + Shift + Tab Toggle backward between tabs when a property is selected Work with property sheets
F4 Toggle the property sheet tab Using a property sheet with a table or query
Ctrl + Tab Move to the property sheet tabs when a property is selected Using a property sheet with a table or query
Shift + Tab Move up one property on a tab; or if already at the top, select the tab itself Using a property sheet with a table or query
Alt + F8 Toggle the Field List pane Work with the Field List pane
Enter Add the selected field to the form or report detail section Work with the Field List pane
Shift + Tab Move to the upper Field List pane from the lower pane Work with the Field List pane
Tab Select the next hidden text or hyperlink, or Show All or Hide All at the top of a topic Keyboard shortcuts for using the Help window
Shift + Tab Select the previous hidden text or hyperlink, or the Browser View button at the top of a Microsoft Office Web site article Keyboard shortcuts for using the Help window
Tab Perform the action for the selected Show All, Hide All, hidden text, or hyperlink Keyboard shortcuts for using the Help window
Ctrl + P Open the Print dialog box Keyboard shortcuts for using the Help window
Shift + F10 Display a menu of commands for the Help window; requires that the Help window have active focus Keyboard shortcuts for using the Help window
Alt + F + E Send the active database object Send e-mail messages
Ctrl + Shift + B Open the Address Book from within Outlook Send e-mail messages
Alt + K Check the names in the To, Cc, and Bcc boxes against the Address Book Send e-mail messages
Shift + Tab Select the previous field or button in the e-mail header Send e-mail messages
Ctrl + C Copy the selection to the Clipboard Copying, moving, or deleting text
Ctrl + X Cut the selection and copy it to the Clipboard Copying, moving, or deleting text
Ctrl + V Paste the contents of the Clipboard at the insertion point Copying, moving, or deleting text
Backspace Delete the selection or the character to the left of the insertion point Copying, moving, or deleting text
Delete Delete the selection or the character to the right of the insertion point Copying, moving, or deleting text
Ctrl + Delete Delete all characters to the right of the insertion point Copying, moving, or deleting text
Ctrl + Z Undo typing Undoing changes
Ctrl + ; Insert the current date Entering data in Datasheet
Ctrl + Shift + : Insert the current time Entering data in Datasheet
Ctrl + Alt + Space Insert the default value for a field Entering data in Datasheet
Ctrl + + Add a new record Entering data in Datasheet
Ctrl + – delete the current record Entering data in Datasheet
Shift + Enter Save changes to the current record Entering data in Datasheet
Ctrl + Enter Insert a new line Entering data in Datasheet
F9 Recalculate the fields in the window Refreshing fields with current data
Shift + F9 Requery the underlying tables; in a subform, this requeries the underlying table for the subform only Refreshing fields with current data
Shift + F6 Move among the Query Designer panes Any Pane
Shift + Tab Move among tables, views, and functions Diagram Pane
Space Choose the selected data column for output Diagram Pane
Remove the selected data column from the query output Diagram Pane
Delete Remove the selected table, view, or function, or join line from the query Diagram Pane
Tab Move among cells Grid Pane
Ctrl + Bottom Arro Move to the last row in the current column Grid Pane
Ctrl + Top Arrow Move to the first row in the current column Grid Pane
Ctrl + Space Select an entire grid column Grid Pane

549 total views, 1 views today