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

FunctionKeys
Select the active tab of the ribbon and activate KeyTipsAlt or F10
(to move to a different tab, use KeyTips or the arrow keys)
Open the Home tabAlt+H
Open the Tell me box on the ribbonAlt+Q, and then enter the search term
Display the shortcut menu for the selected itemShift+F10
Move the focus to a different pane of the windowF6
Open an existing databaseCtrl+O or Ctrl+F12
Show or hide the Navigation PaneF11
Show or hide a property sheetF4
Switch between Edit mode (with insertion point displayed) and Navigation mode in the Datasheet or Design viewF2
Switch to Form view from the form Design viewF5
Move to the next or previous field in the Datasheet viewThe Tab key or Shift+Tab
Go to a specific record in the Datasheet viewAlt+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 pageZ
Open the Find tab in the Find and Replace dialog box in the Datasheet view or Form viewCtrl+F
Open the Replace tab in the Find and Replace dialog box in the Datasheet view or Form viewCtrl+H
Add a new record in Datasheet view or Form viewCtrl+Plus Sign (+)
Open the Help windowF1
Exit AccessAlt+F4

FunctionKeys
Select the active tab of the ribbon and activate KeyTipsAlt or F10
(to move to a different tab, use KeyTips or the arrow keys)
Move the focus to commands on the ribbonThe Tab key or Shift+Tab
Move down, up, left, or right, respectively, among the items on the ribbonThe Down, Up, Left, or Right arrow key
Expand or collapse the ribbonCtrl+F1
Display the shortcut menu for the selected itemShift+F10
Move the focus to a different pane of the windowF6
Move to the next or previous command on the ribbonThe Tab key or Shift+Tab
Activate the selected command or control on the ribbonSpacebar or Enter
Open the selected menu or gallery on the ribbonSpacebar or Enter
Open the selected list on the ribbon, such as the Font listThe Down arrow key
Move between items in an open menu or galleryThe Tab key
Finish modifying a value in a control on the ribbon, and move the focus back to the documentEnter
  • [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

Your email address will not be published. Required fields are marked *