Saturday, 3 December 2016

Microsoft Terminology



Microsoft Terminology 

Normal.dotx – The default template provided by Word whenever you create a blank document. Macros, AutoText, or customization of toolbars or menus will be saved with this template unless otherwise indicated.

Numbering – The feature that enables you to apply numbering to text.

Office Clipboard – A place to store data temporarily pending retrieval.
Orientation – The direction of the paper for text flow; Portrait takes advantage of the length of the paper vertically whereas Landscape uses the length of the paper horizontally.

Orphan – When the last line of text from a paragraph is on the next page, separated from the rest of the paragraph.
Page – The number of lines designated to create a page of data. Word automatically divides the document into pages based on the margin settings, the line spacing and the size of text.

Page Break – The division between two pages. Word automatically creates Soft Page Breaks that are adjusted accordingly when you add or remove text. You can create Hard Page Breaks which are always in effect.

Page Numbering – The feature that enables you to have Word display the current page number in the document.

Page Setup – The process that determines how Word displays or prints the document, e.g., margins, paper size, etc.

Passwords – A feature you can apply to a document to make it more secure from access by other users unless authorized. You can choose from read only, modify only, or both. See Encryption for another method to secure documents.

Paste – The editing function of placing cut or copied data into a new location.

PDF (Portable Document Format) – A file format that is used when you do not want others to alter the contents of the document. Word can save and open files in this format.

Picture – A graphic file that can be inserted into a Word document. This can be in a large variety of file formats, including Windows Metafile (*.wmf), JPEG File Interchangeable format (*.jpg, *jpeg), Portable Network Graphics (*.png), Windows Bitmap (*.bmp), or Graphics Interchange format (*.gif).

Properties – A feature you can use to access or enter information about a file such as the author’s name, the department responsible for updates to this document, etc.

Proportional Spacing – The space used for individual characters and is measured in point size. With proportional spacing five WWWWW’s take up more space than five IIIII’s. Proportionally spaced text is easier to read than monospaced text and allows approximately 25% more text per page.

Quick Access Toolbar – By default, located next to the Office Button and contains popular commands such as Save, Undo, and Redo. This toolbar can be customized for those commands you use frequently.

Quick Part – A feature that enables you to store text or graphics for repetitive use. These can be stored as a Quick Part or in the Building Blocks Organizer. See Building Blocks.

Replace – A feature that enables you to find and then replace specified text throughout the document.

Ribbon – A collection of tabs located directly below the title bar, providing quick access to commands required to complete a task.

Ribbon Tabs – Relates to a type of activity, organizing command buttons into logical groups. The group name appears on the Ribbon tab below the group of command buttons.

Ruler – Located below the Ribbon. The ruler displays icons that allow you to perform functions such as changing margins, tabs and indents quickly.

Save – The process of storing or copying the information in the memory to a disk. If you turn the computer off without saving to a disk, you lose all the information you have entered in the memory.

Section Break – The division between two different sections or areas of text, indicating a change that affects only that section or area, e.g., portrait versus landscape orientation, different headers and footers, etc.

Shapes – Objects that can be selected from the Insert tab or the Drawing Tools tab to be drawn in a document.

SmartArt – An illustration type for common types of diagrams, containing a text pane for easy text entry.

Spacing – Refers to the amount of white space between individual characters, words, or lines of text or objects.

Styles – A feature that contains formatting attributes you can apply to text in a document for consistency purposes.

Symbol – A character that can be inserted into a document, either as a text character or for a bullet or numbering style.

Tab – A character that causes the text to move to an exact predefined location (tab stop). Could also refer to a divider indicator within a dialog box, or the key that moves the cursor by a set measurement.

Table – A grid design that allows you to enter columnar information that can then be formatted. Often considered to be easier to set up for columns of information instead of setting up tab positions.

Template – A pre-designed form created either by Microsoft or a user that can be used to create a specific type of document. Setting up a template enables documents of that type to have a consistent look.

Themes – A set of integrated document design elements that make your online documents appealing and effective.

View Options – Different ways of being able to view the document, usually to assist in working with the text, page layout, web layout, an outline, or reading.

Watermark – Text, graphics, AutoShapes, drawing objects, or pictures that usually appear behind text.

Widow – When the first line of a paragraph is at the bottom of the page and the rest of the paragraph appears at the top of the next page.

WordArt – A feature that enables you to create text objects that can be enhanced with various shapes, styles, rotation or formats. 

Friday, 18 November 2016

ACCESS KEYBOARD SHORTCUTS

ALTClose the visible menu and submenu at the same time; works with menu commands.
ALT+ letter key, where key is the underlined letter in the field or menu cmndSelect a menu or select or clear the check box by the letter underlined in the menu command; works within windows and dialog boxes.
ALT 1Go to previous folder; use within the Open, File New Database and Export dialog boxes in Microsoft Access.
ALT+2Open the folder one level up from the open folder (Up One Level button); use within the Open, File New Database and Export dialog boxes.
ALT+3Close the open dialog box and opens your World Wide Web search page (Search the Web button); use when working in the Open, File New Database and Export dialog boxes.
ALT+4Delete the selected folder or file; use within the Open, File New Database and Export dialog boxes.
ALT+5Create a new subfolder in the open folder; use within the Open, File New Database and Export dialog boxes.
ALT+6Switch between List, Details, Properties, and Preview views (click the arrow next to Views); use within the Open, File New Database and Export dialog boxes.
ALT 7Display the Tools menu; use within the Open, File New Database and Export dialog boxes in Microsoft Access.
ALT+AOpen Answer Wizard (In Help menu); use within Help menu.
ALT+A and ENTERUse from the field list to add table and fields to the data access page when working in Design view.
CTRL+SHFT+RIGHT ARROWSelect or unselect one word to the right of the cursor.
CTRL SHFT TABExit the subform and move to the previous field in the main form or previous record in Microsoft Access.
CTRL+SHFT+F8+LEFT ARROWActivate Move mode; then press the LEFT ARROW key to move selected columns to the left.
CTRL SHFT TABGo to the previous tab when working in Help dialog box in Microsoft Access.
CTRL+SHFT+TABExit the subdatasheet and move to the first field of the following record in the datasheet.
CTRL+SHFT+TAB or CTRL+PAGE UPGo to the previous tab when working in a tabbed dialog box.
CTRL SHFT UP ARROWCollapse the subdatasheet in Microsoft Access.
ALT+CDisplay Contents dialog box; use within Help menu.
ALT+DOWN ARROWDisplay more Help topics; works when using Office Assistant.
ALT+DOWN ARROWExpand a list inside a table while working in a Database Diagram.
ALT+DOWN ARROWOpen a selected drop-down menu; works within a dialog box.
ALT+ENTERDisplay the properties of a selected item while working in a window.
ALT ENTERDisplay the PivotTable Property Toolbar in Microsoft Access.
ALT+F+D+ASend the active database object as an E-Mail message.
ALT+F11Switch between the Visual Basic Editor and the previous window; works within a window.
ALT+F4Quit Microsoft Access, close a dialog box, or close a property sheet; works within an open window.
ALT F4Close the active Help window in Microsoft Access.
ALT+F4Close the PivotTable Property Toolbar.
ALT ISwitch to Index tab while working in Help menu in Microsoft Access.
ALT+KCheck the names in the To, Cc and Bcc fields against the Address Book while sending an E-Mail.
ALT LEFT ARROWGo to a previously viewed Help topic in Microsoft Access.
ALT+NCreate a new table, query, form, report, data access page, macro, or module when working with a database or spreadsheet.
ALT+numberSelect a Help topic while using Office Assistant. (where hitting key for 1 selects the leftmost option, 2 the next, and so on)
ALT+ODisplay Options dialog box (in Help menu).
ALT+PAGE DOWNDisplay the next screen to the right while working within Pivot Table Wizard.
ALT+PAGE UPDisplay the previous screen to the left while working within Pivot Table Wizard.
ALT RIGHT ARROWGo to a previously viewed a Help topic while in the Help dialog box in Microsoft Access.
ALT+SHFT+F11Move between the Microsoft Script Editor window and the previous window.
ALT+SHFT+TABMove from active application window to previously active application window.
ALT+SPACEBAROpen the menu of the leftmost icon on the main toolbar bar of the active window; this menu typically contains the following commands: Restore, Move, Size, Minimize, Maximize and Close.
ALT+SPACEBARDisplay the Control menu while working from Help menu.
ALT SPACEBARDisplay the Control menu while working from Help menu in Microsoft Access.
ALT+TABMove from active application window to the previously used application window; to select an application from a list of the open applications, hold ALT down and press TAB more than once to move through the list.
ALT+UP ARROWDisplay previously viewed Help topics while using Office Assistant.
CTRL+SHFT+BOpen the Address Book when sending an E-Mail.
CTRL SHFT DOWN ARROWExpand a record's subdatasheet from the datasheet in Microsoft Access.
CTRL+SHFT+F6Go to the previous database window.
CTRL+SHFT+F8+RIGHT ARROWActivate Move mode; then press the RIGHT ARROW key to move selected columns to the right.
CTRL+SHFT+LEFT ARROWSelect or unselect one word to the left of the cursor.
CTRL+SHFT+LEFT ARROWTo extend selection one word to the left.
CTRL+SPACEBARSelect or unselect the active column, in Navigation mode only.
CTRL+SPACEBARSelect an entire grid column while navigating in the Query Designer - Grid Panes mode.
CTRL SPACEBARSelect the field for the currently selected item of data, total or detail cell when working in a Pivot Table list in Microsoft Access.
CTRL+TABMove through the tabs of each object's type when navigating and opening objects in Access.
CTRL+TABExit the subform and move to the next field in the master form or next record when working in Form view.
CTRL+TABMove to the next tab on a tabbed, Help dialog box.
CTRL+TABExit the subdatasheet and move to the last field of the previous record in the datasheet.
CTRL+TAB or CTRL+PAGE DOWNMove to the next tab on a tabbed dialog box.
CTRL TAB or CTRL SHFT TABSelect the next or previous toolbar in Microsoft Access.
CTRL+UP ARROWMove to the current field in the first record, in Navigation mode.
CTRL+UP ARROWMove to the top of the active page when working in Access Print Preview and Layout Preview mode.
CTRL+UP ARROWMove the selected control up when working in Access Form and Report Design view.
CTRL+UP ARROWMove to the first row in the current column when working in Access Query Designer -Grid Panes mode.
CTRL+UP ARROWMove the selected control up by a pixel (regardless of the page's grid) when working in Access Design view.
CTRL+VPaste a copied item(s) from the Clipboard into a selected location (You also can choose Paste from the Edit menu.).
CTRL VPaste the contents of the Clipboard in the upper-left corner of the selected section when working in Form and Report Design view in Microsoft Access.
CTRL+VPaste a copied item(s) from the Clipboard into a selected location when working in Query Designer-Grid Panes (You also can choose Paste from the Edit menu.).
CTRL+VPaste a copied item(s) from the Clipboard into a selected location when working in dat access page Design view (You also can choose Paste from the Edit menu).
CTRL+W or CTRL+F4Close the active datasheet window.
CTRL+XCopy and remove the selected item(s) from their original location to the Clipboard. (You also can choose the Cut command from the Edit menu.).
CTRL+Z or ALT+BACKSPACEUndo the last action; note: some actions, like Shutdown, cannot be undone (You also can choose Undo from the Edit menu.).
DELETEDelete the selected item(s), or to delete the character to the right of the cursor; if items are files they will be moved to the Recycle Bin.
DELETEDelete the selected item(s), or to delete the character to the right of the cursor; if items are files they will be moved to the Recycle Bin.
DOWN ARROWTo move down one line in a Combo box, list box or Database window in Microsoft Access.
DOWN ARROWMove to the same field in the next record when navigating in Access Datasheet view.
DOWN ARROWScroll down a window or document in small increments when working in Access Print Preview or Layout Preview.
DOWN ARROWSelect the next book or Help topic in Microsoft Access.
DOWN ARROWScroll toward the end of a Help topic.
DOWN ARROWScroll through the items in a drop-down list, moving from top to bottom.
DOWN ARROWUse when starting from the datasheet in order to bypass the subdatasheet and move to the next record in the datasheet.
DOWN ARROW or UP ARROW (with the menu or submenu displayed)Select the next or previous command on the menu or submenu.
ENDGo to the end of the entry when editing a text box.
ENDGo to the last object in database window in Microsoft Access.
ENDGo to the end of the field, in single-line fields.
ENDGo to the last field in the current record, when working in Access Navigation mode.
ENDGo to the end of a Help topic.
ENDGo to the last cell in the row or to the end of the active cell.
END OR CTRL+RIGHT ARROWMove to the right edge of the page when working in Access Print Preview and Layout Preview.
ENTERPerform the action assigned to the selected default button in a dialog box.
ENTERRestore a selected minimized program window when all windows are minimized.
ENTEROpen the selected table or query in Datasheet view, or form in Form view.
ENTEROpen the selected report in Print Preview in Microsoft Access.
ENTERRun a selected macro.
ENTEROpen the selected data access page in Page Preview.
ENTEROpen or close a selected book, or open a selected Help topic.
ENTERActivate a selected hyperlink in Microsoft Access.
ENTERMove from a table's title bar to the last cell edited in a Database Diagram.
ENTERSelect an item in a list and move to the next cell in a Database Diagram.
ENTERPerform the action assigned to a selected button on a toolbar.
ENTEROpen a selected menu on a toolbar.
ENTEREnter text in a selected text box.
ENTER or ALT+OOpen the selected table or query in Datasheet view, or form in Form view.
ESCClose the visible menu; or, with a submenu visible, close the submenu only.
ESCCancel a command and close the dialog box in Microsoft Access.
ESCClose an Office Assistant message or tip.
ESCCancel Extend mode command.
ESCUndo changes in the current field or current record; if both have been changed, press ESC twice to undo changes first in the current field and then in the current record.
ESCClose a pop-up window in Help in Microsoft Access.
ESCMove from a table cell to the table's title bar when working in database Diagram.
ESCClose a shortcut menu without carrying out a command when working in a Pivot Table.
ESCCancel a Refresh command in progress when working in a Pivot Table.
ESC (when a drop-down list box is selected)Close a selected drop-down list in a dialog box.
F1Display Help or the Office Assistant in Microsoft Access.
F1Display the Office Assistant or Microsoft Access Contents and Index; context-sensitive help about the selected property, control, macro action, or Visual Basic keyword; or alerts with a Help button.
F1Display Help topics when working in a Pivot Table.
F10Activate, or select, the main toolbar beginning with the first toolbar option on the left, usually File; after the first option is activated you can navigate through toolbar and menu options using the appropriate ARROW keys; press F10 or ALT again
F11 or ALT+F1Bring the Database window to the front.
F12 or ALT+F2Display Save As dialog box (file menu).
F2Display the complete hyperlink address for a selected hyperlink.
F2Rename a selected object when working in Database window.
F2Move between Edit mode (with insertion point displayed) and Navigation mode when working in Design view.
F2Move between Edit mode and Cell Selection mode when navigating in the Query Designer -Grid Panes.
F4 or ALT+DOWN ARROWOpen a combo box.
F5Update the files visible in the Open or Save As dialog box (File menu).
F5Move to Form view from Form design or a Form module when working in Access Design view.
F5Navigate through records by moving cursor to the record number box, typing the record number and pressing ENTER when working in Datasheet view.
F5Navigate through records by moving cursor to the record number box, typing the record number and pressing ENTER when working in Form view.
F5Navigate through pages by moving cursor to the page number box, typing the page number and pressing ENTER when working in Print Preview and Layout.
F5Refresh the current window (You also can choose Refresh from the View menu.).
F5Navigate in subdatasheet records by moving to the record number box, typing the record number and pressing ENTER.
F6Move between the upper and lower portions of a window when working in Design view of tables, macros, and queries and the Advanced Filter/Sort window only.
F6Move between the navigation pane and topic pane when working with Help menu in Microsoft Access.
F6,SHFT+F6Use by pressing and then clicking anywhere in the target pane when navigating the Query Designer - Any Pane.
F7Display Spelling and Grammar dialog box (Tools Menu).
F8Activate Extend mode; EXT appears in the lower right corner of the window; pressing F8 repeatedly extends the selection to the word, the field, the record (in Datasheet view only), and all records; press ESC to cancel.
F9Refresh the contents of a Lookup field list box or combo box.
F9Recalculate the fields in the window in Microsoft Access.
F9Refresh the PivotTable list from the source data.
HOMEGo to the beginning of the current entry.
HOMEGo to the first object.
HOMEGo to the beginning of the current field, in single-line fields.
HOMEGo to the first field in the current record, when in Access Navigation mode.
HOMEGo to the beginning of a Help topic, with Help dialog box open.
HOMEGo to the first cell in the row, or to the beginning of the current cell.
HOME or CTRL LEFT ARROWGo to the left edge of the current page in Microsoft Access.
HOME or ENDSelect the first or last command on the menu or submenu.
INSERTToggle between insert and overstrike mode while editing a cell.
INSERT after you select any Or... columnInsert an Or... column when navigating the Access Query Designer - Grid Panes mode.
INSERT after you select grid rowInsert a row between existing rows when navigating the Access Query Designer - Grid Panes mode.
LEFT ARROWGo one character to the left of the cursor's current position in the field.
LEFT ARROWScroll to the left of the cursor's current position in small increments when working in Print Preview and Layout Preview.
LEFT ARROW or RIGHT ARROWWith a menu open, select the menu to the left or right of the original, or, with a submenu visible, switch between the main menu and the submenu.
LEFT ARROW or RIGHT ARROWMove one character to the left or right in a text box.
LEFT ARROW, or RIGHT ARROWExtend a selection to adjacent fields in the same row in Microsoft Access Datasheet view.
LEFT or RIGHT ARROWSelect a button on the record navigation toolbar when working in Access Page View.
Letter key, where the letter is the same as the first letter in optn you want on a selected menu,Choose a selected menu, drop-down list, or dialog box option by typing the first letter in the option name.
P or CTRL+PTo open the Print dialog box from Print Preview or Layout Preview.
PAGE DOWNMove down one page when using a Combo box or list box.
PAGE DOWNMove down one window when working in Database view in Microsoft Access.
PAGE DOWNScroll down one full screen when working in Print Preview and Layout Preview.
PAGE DOWNScroll toward the end of a Help topic in larger increments.
PAGE DOWNWhen navigating a Database Diagram, scroll to the next page inside a table or the next page of the diagram.
PAGE DOWNWhen working in a Pivot Table list, display the next screen.
PAGE DOWNWhen navigating in Form view, go down one page; at the end of the record, moves to the equivalent page on the next record.
PAGE DOWN or DOWN ARROWIn Print Preview and Layout Preview, view the next page (when Fit To Window is selected).
PAGE UPMove up one page when using a combo box or list box.
PAGE UPMove up one window when working in Database.
PAGE UPGo up one screen when working in Datasheet view in Microsoft Access.
PAGE UPGo up one page when working in Form view; at the end of the record, use to move to the equivalent page on the previous record.
PAGE UPScroll up one full screen when working in Print Preview and Layout Preview.
PAGE UPScroll toward the beginning of a Help topic in larger increments.
PAGE UPWhen navigating a Database diagram, scroll to the previous page inside a table or the previous page of the diagram.
PAGE UPDisplay the previous screen when working with a Pivot Table list in Microsoft Access.
PAGE UP or UP ARROWIn Print Preview and Layout Preview, view the previous page (when Fit To Window is selected).
RIGHT ARROWMove one character to the right of the cursor's current position in a field.
RIGHT ARROWIn Print Preview and Layout Preview, scroll to the right in small increments.
SIn Print Preview and Layout Preview, open the Page Setup dialog box.
SHFT+ARROW KEYExtend or reduce a selection in a Pivot Table list, depending on the direction of the arrow key chosen.
SHFT+CTRL+TABCycle through the tab of each object's type moving right to left.
SHFT DOWN ARROWExtend selection to the next record, if the current record is selected in Microsoft Access.
SHFT+DOWN ARROWIncrease the height of the selected control when working in Form and Report Design view.
SHFT+ENDSelect from the insertion point to the end of the text box entry.
SHFT+ENTERAdd a control to a section when working in Form and Report Design view only.
SHFT+ENTERSave changes to the current record when entering data in the Datasheet or Form view.
SHFT ENTERAdd a control to a section when working in data access page Design view in Microsoft Access.
SHFT+F1Display What's This? help; after pressing SHFT+F1, move the pointer to the menu command, toolbar button, dialog box option, or screen region to see definitions.
SHFT+F10Display a shortcut menu that shows a list of commands relevant to the selected object.
SHFT+F10Display a shortcut menu that shows a list of commands relevant to the selected object.
SHFT+F10Display the shortcut menu for the selected element of the PivotTable list.
SHFT+F2Open the Zoom box to conveniently enter expressions and other text in small input areas.
SHFT+F4Find the previous occurrence of the text specified in the Find or Replace dialog box when the dialog box is closed.
SHFT F8Undo a previous selection extension in Microsoft Access.
SHFT+F9Requery the underlying tables; in a subform, this requeries the underlying table for the subform only.
SHFT+HOMESelect from the insertion point in the text box to the beginning of the text box entry.
SHFT+LEFT ARROWSelect or unselect one character to the left of the cursor's position.
SHFT+LEFT ARROWReduce the width of the selected control when working in Form an Report Design view.
SHFT+LEFT ARROWSelect the column to the left, if the current column is selected, when working in Datasheet view.
SHFT+PAGE DOWNExtend the selection one screen down.
SHFT PAGE UPReduce a selection by one screen when working with a Pivot Table list in Microsoft Access.
SHFT+RIGHT ARROWSelect or unselect by one character to the right of the cursor's current position.
SHFT+RIGHT ARROWIncrease the width of the selected control when working in Form and Report Design view.
SHFT+RIGHT ARROWSelect the column to the right, if the current column is selected, when working in Datasheet view.
SHFT+SPACEBARSwitch between selecting the current record and the first field of the current record, when working in Navigation mode.
SHFT+SPACEBARSelect the entire row containing the currently selected cell when working in a Pivot Table list.
SHFT TABMove to the previous option or option group in a dialog box in Microsoft Access.
SHFT+TABMove to the previous field when navigating in Form view.
SHFT+TABEnter the subform from the following field in the main form when navigating in Form view.
SHFT+TABGo to the last or previous hyperlink in Help.
SHFT+TABSelect the previous field or button in the E-Mail header.
SHFT+TABEnter the subdatasheet from the first field of the following record in the datasheet.
SHFT+TABSelect the previous field or the entire Pivot Table list.
SHFT+TAB, or LEFT ARROWMove to the previous field when navigating in Datasheet view.
SHFT UP ARROWExtend selection to the previous record, if the current record is selected in Microsoft Access.
SHFT+UP ARROWReduce the height of the selected control when working in Form and Report Design view.
SPACE or ENTERExpand or collapse a group of records corresponding to the expand indicator in a grouped data access page.
SPACE or ENTERActivate the selected button on the record navigation toolbar when working in Page view.
SPACEBARPerform the action assigned to the active button, or select or clear the active check box in the dialog box.
SPACEBARSwitch between the values in a check box or option button.
SPACEBARChange the setting in a check box when navigating a Database Diagram in Microsoft Access.
SPACEBARToggle the check box in the Output column when navigating the Query Designer-Grid Panes.
SPACEBAR or MINUS SIGNRemove the selected data column form the query output when navigating the Query Designer-Diagram Pane.
SPACEBAR or PLUS SIGNChoose the selected data column form the query output when navigating the Query Designer-Diagram Pane.
TABMove to the next option or option group in a dialog box.
TABExit the combo box or list box.
TABSelect the next field in Microsoft Access.
TABMove to the next field when working in Form view.
TABTo enter the subform from the preceding field in the main form when working in Form view.
TABGo to the first or next hyperlink in Help.
TABSelect the next box in the E-Mail header, or the body of the message when the last box in the E-Mail header is active.
TABMove from table title bar to table title bar, or from cell to cell inside a table, when navigating a Database Diagram.
TABEnter the subdatasheet from the last field of the previous record in the datasheet in Microsoft Access.
TABMove from the last field in the subdatasheet to the next field in the datasheet.
TABSelect each field and then the entire Pivot Table list, going through these selections in sequence.
TAB or SHFT+TAB (when a toolbar is active)When a toolbar is active, select the next or previous button or menu on the toolbar.
TAB, ENTER, or RIGHT ARROWMove to the next field when navigating in Datasheet view in Microsoft Access.
TAB, SHFT+TABMove between input source windows (and to join lines, if available) when navigating the Query Designer-Diagram Pane.
LETTER KEY, where the key corresponds with the underlined letter in an optn nameSelect and choose a command on the shortcut menu when working in a Pivot table.
UP ARROWMove up one line in a combo box or list box.
UP ARROWMove up one line in a database window.
UP ARROWMove to the current field in the previous record when navigating in Datasheet view.
UP ARROWScroll up in small increments when working in Print Preview and Layout Preview.
UP ARROWSelect the previous book or topic in Help in Microsoft Access.
UP ARROWScroll toward the beginning of a Help topic.
UP ARROWMove to the previous item in a list when navigating in a Database Diagram.
UP ARROWUse from the datasheet to bypass the subdatasheet and move to the previous record in the datasheet.
UP ARROW or DOWN ARROWMove up or down in a drop-down list when navigating the Query Designer - Grid Panes in Microsoft Access.
UP ARROW, DOWN ARROWExtend a selection to adjacent rows in Datasheet view.
ZZoom in or out on a part of the page when working in Print Preview and Layout Preview.
ARROW KEYMove between options in a selected drop-down menu or dialog box or between some options in a group of options.
ARROW KEYMove between columns in an input source window when working in the Query Designer-Diagram Pane.
ARROW KEYMove selected elements in the given direction of the arrow key while working within a Pivot Table.
ARROW KEYS or TAB or SHFT TABMove between cells when working in the Query Designer-Diagram Pane in Microsoft Access.
ARROW KEYMove between options in a selected drop-down menu or dialog box or between some options in a group of options; add ENTER to select an option.
BACKSPACEDelete selected text or to delete the character to the left of where the cursor is positioned within a document while editing.
C or ESCCancel Print Preview or Layout Preview and return to Normal view.
CTRL+7Display or hide the main toolbar of the active window.
CTRL+ASelect the entire Help topic when working in the Help menu or dialog box.
CTRL ASelect the entire active Pivot Table list in Microsoft Access.
CTRL+A or CTRL+SHFT+SPACEBARSelect all records in an active database.
CTRL+ALT+SPACEBARInsert the default value for a selected field when entering data in a Datasheet or Form view.
CTRL+APOSTROPHE (')Insert the value from the same field in the previous record to the selected field in the current record within a database.
CTRL CCopy selection to the Windows Clipboard in Microsoft Access.
CTRL+CCopy the selected control to the Windows Clipboard.
CTRL+CCopy the selected Help items to the Windows Clipboard when working in Help menu.
CTRL+CCopy selected text to the Windows Clipboard when working in the Query Designer - Grid Panes.
CTRL CCopy selected text to the Windows Clipboard when working in Design View in Microsoft Access.
CTRL+CCopy selected data from the Pivot Table list to the Windows Clipboard when working in a Pivot Table.
CTRL+COLON (:)Insert the current time at the cursor's current position.
CTRL+DELETEDelete text to the end of the line in which the cursor is positioned.
CTRL+DOWN ARROWMove to the same field in the last record while in Navigation mode in Datasheet view.
CTRL+DOWN ARROWMove to the bottom of current page in which you are working while in Print Preview and Layout Preview.
CTRL DOWN ARROWMove the selected control down in the presentation while in Form and Report Design view in Microsoft Access.
CTRL+DOWN ARROWMove to the last row in the current column while working in Query Designer-Grid Panes mode.
CTRL+DOWN ARROWMove the selected control down by a pixel (irrespective of the page's grid) while working in Data Access page in Design View.
CTRL EExport the selected Pivot Table list to a Microsoft Excel document in Microsoft Access.
CTRL+ENDMove to the end of the active field, while working working with multiple-line fields in Access.
CTRL+ENDMove to the last field in the last record while in Navigation mode in Access.
CTRL+ENDTo move to the last field in the last record while in Navigation mode and Form view in Access.
CTRL+ENDMove to the lower-right corner of the page while working in Print Preview and Layout Preview.
CTRL+ENDMove to the last position in the current cell or the last column in the active window while in Query Designer - Grid Panes view in Access.
CTRL ENTERInsert a new line when entering data in Datasheet or Form view in Microsoft Access.
CTRL+ENTER or ALT+DTo open the selected table, query, form, report, macro, or module while working in Design view in Access.
CTRL+ESCDisplay Windows Start menu.
CTRL+FDisplay the Find dialog box while working in Access Datasheet view, Form view or Module Window only.
CTRL+F11Toggle between a custom menu bar and a built-in menu bar while working in Access.
CTRL F2Invoke a Builder while working in Microsoft Access.
CTRL+F6Go to the next database window in the active application.
CTRL F6Move between open windows in Microsoft Access.
CTRL+F8Activate Resize mode for the active window when it is not maximized; press the arrow keys ro resize the window.
CTRL+GDisplay the Immediate window in the Visual Basic Editor.
CTRL+HTo open the Replace dialog box (while in Datasheet view, Form view, and Module Window only).
CTRL+HOMEGo to the beginning of the field, in multiple-line fields, when workin in Access.
CTRL+HOMEGo to the first field in the first record when working in Navigation mode in Datasheet view.
CTRL+HOMEGo to the first field in the first record when working in Navigation mode in Form view.
CTRL+HOMEGo to the upper-left corner of the page when in Print Preview and layout Preview mode.
CTRL+HOMEGo to the first position in the active cell or the first column in the active window when working in the Query Designer -Grid Panes.
CTRL LEFT ARROWMove cursor's position one word to the left in Microsoft Access.
CTRL+LEFT ARROWMove the selected control to the left when working in Form and Report Design view.
CTRL+LEFT ARROWMove the selected control to the left by one pixel (irrespective of the page's grid) when working in data access page Design view.
CTRL+LEFT ARROW or CTRL+RIGHT ARROWMove cursor's position one word to the left or right.
CTRL+MINUS SIGN (-)Delete the current record when working in Datasheet or Form view.
CTRL NOpen a new, blank, database in Microsoft Access.
CTRL+ODisplay the Open dialog box in order to find and open an existing database.
CTRL+PDisplay the Print dialog box in order to print the active selection.
CTRL+PPrint the active Help topic.
CTRL+PAGE DOWNGo right one screen.
CTRL PAGE DOWNGo to the same field in the next record in Microsoft Access.
CTRL+PAGE UPGo left one screen when working in datasheet view in Access.
CTRL+PAGE UPGo to the same field in the previous record.
CTRL+PLUS SIGN (+)Add a new record while working in Datasheet or Form view in Access.
CTRL+RIGHT ARROWMove cursor one word to the right.
CTRL+RIGHT ARROWMove the selected control to the right when editing controls in Form and Report Design view.
CTRL+RIGHT ARROWMove the selected control to the right by a pixel (irrespective of the page's grid) when working in data access page Design view.
CTRL S or SHFT F12 or ALT SHFT F2Save a database object in Microsoft Access.
CTRL+SEMICOLON (;)Insert the current date into active Datasheet or Form view.