MICROSOFT ACCESS AND ITS SHORT CUT KEYS
What is Microsoft Access?
Microsoft Access is a Database Management System offered by Microsoft. It uses the Microsoft Jet Database Engine and comes as a part of the Microsoft Office suite of application.
Microsoft Access offers the functionality of a database and the programming capabilities to create easy to navigate screens (forms). It helps you analyze large amounts of information, and manage data
IMPORTANCE OF MICROSOFT ACCESS
Microsoft Access, is an information management tool, or relational database, that helps you store information for reference, reporting and analysis. Access can also overcome the limitations found when trying to manage large amounts of information in Excel or other spreadsheet applications.
A spreadsheet program like Microsoft Excel cant do the work of ms accessin terms of maintaining and calculating large sets of information. Excel is easy to understand and easy to use. You can sort, filter and format the data quickly and easily. But spreadsheets are not ideal for handling hundreds of records when creating an important file for a client, a contact or an executive. It’s very easy to make errors in a spreadsheet, which then makes analysis, summing and reporting very challenging.This where ms access comes in to perform more efficiently.
MS ACCESS SHORT CUT KEYS
| Function | Keys |
|---|---|
| Select the active tab of the ribbon and activate KeyTips | Alt or F10 (to move to a different tab, use KeyTips or the arrow keys) |
| Open the Home tab | Alt+H |
| Open the Tell me box on the ribbon | Alt+Q, and then enter the search term |
| Display the shortcut menu for the selected item | Shift+F10 |
| Move the focus to a different pane of the window | F6 |
| Open an existing database | Ctrl+O or Ctrl+F12 |
| Show or hide the Navigation Pane | F11 |
| Show or hide a property sheet | F4 |
| Switch between Edit mode (with insertion point displayed) and Navigation mode in the Datasheet or Design view | F2 |
| Switch to Form view from the form Design view | F5 |
| Move to the next or previous field in the Datasheet view | The Tab key or Shift+Tab |
| Go to a specific record in the Datasheet view | Alt+F5 (then, in the record number box, type the record number and press Enter) |
| Open the Print dialog box from Print (for datasheets, forms, and reports) | Ctrl+P |
| Open the Page Setup dialog box (for forms and reports) | S |
| Zoom in or out on a part of the page | Z |
| Open the Find tab in the Find and Replace dialog box in the Datasheet view or Form view | Ctrl+F |
| Open the Replace tab in the Find and Replace dialog box in the Datasheet view or Form view | Ctrl+H |
| Add a new record in Datasheet view or Form view | Ctrl+Plus Sign (+) |
| Open the Help window | F1 |
| Exit Access | Alt+F4 |
| Function | Keys |
|---|---|
| Select the active tab of the ribbon and activate KeyTips | Alt or F10 (to move to a different tab, use KeyTips or the arrow keys) |
| Move the focus to commands on the ribbon | The Tab key or Shift+Tab |
| Move down, up, left, or right, respectively, among the items on the ribbon | The Down, Up, Left, or Right arrow key |
| Expand or collapse the ribbon | Ctrl+F1 |
| Display the shortcut menu for the selected item | Shift+F10 |
| Move the focus to a different pane of the window | F6 |
| Move to the next or previous command on the ribbon | The Tab key or Shift+Tab |
| Activate the selected command or control on the ribbon | Spacebar or Enter |
| Open the selected menu or gallery on the ribbon | Spacebar or Enter |
| Open the selected list on the ribbon, such as the Font list | The Down arrow key |
| Move between items in an open menu or gallery | The Tab key |
| Finish modifying a value in a control on the ribbon, and move the focus back to the document | Enter |
- [Tab] sets focus to the next field.
- [Ctrl]+[Enter] inserts a new line in multi-line controls.
- [Ctrl]+[C] copies the selected text onto the clipboard.
- [Ctrl]+[X] cuts the selected text, and put it on the clipboard.
- [Ctrl]+[V] pastes the clipboard contents.
- [Ctrl]+[F] opens the Find dialog.
- [Ctrl]+[Z] undoes the last action.
- [Ctrl]+[A] selects all text in the current field.
- [Shift]+[F2] opens zoom box to edit the current field in its own, larger, dialog box.
- [Spacebar] toggles the value of a check box or option button.
- [F7] checks spelling.
- [Esc] undoes changes to the current field or the current record (press [Esc] twice to undo both).
Please drop your comment.
Hits: 0
Comments and Responses