MS Access Shortcut Keys Download PDF
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 |
