Using the Function Keys

Access assigns specific purposes to all 12 function keys of the 101-key extended keyboard. Some keys, such as Shift+F4 (which you press to find the next occurrence of a match with the Find dialog), derive from other Microsoft applications in this case, Word.

Global Function Keys

Windows, rather than Access, uses global function-key assignments, except for F11, Ctrl+F1, and Alt+F1, to perform identical functions in all Windows applications. Table 3.4 lists the global function-key assignments.

Table 3.4. Global Function-Key Assignments

Key

Function

F1

Displays context-sensitive help related to the present basic function and status of Access. If a context-sensitive help topic isn't available, F1 opens the Microsoft Access Help task pane page, which lets you search online help for a keyword or open its table of contents.

Shift+F1

Adds a question mark to the mouse pointer when hovering over an element that has a description. Place the mouse pointer with the question mark over an object onscreen for which you want more information and then click.

graphics/new.gif Ctrl+F1

Toggles (alternates) visibility of the task pane in all Office 2003 members.

Ctrl+F4

Closes the active window.

Alt+F4

Exits Access or closes a dialog if one is open.

Ctrl+F6

Selects each open window in sequence as the active window.

F11

Selects the Database window as the active window.

F12

Opens the File Save As dialog.

Shift+F12

Saves your open database; the equivalent of the File menu's Save command.

Function-Key Assignments for Fields, Grids, and Text Boxes

Access assigns function-key combinations that aren't reserved for global operations to actions specific to the basic function that you're performing at the moment. Table 3.5 lists the function-key combinations that apply to fields, grids, and text boxes. (To present complete information, this table repeats some information that appears in the previous tables.)

For an extensive list of Access shortcut key assignments, see "Using Keyboard Operations for Entering and Editing Data," p. 218.


Table 3.5. Function Keys for Fields, Grids, and Text Boxes

Key

Function

F2

Toggles between displaying the caret for editing and selecting the entire field.

Shift+F2

Opens the Zoom box to make typing expressions and other text easier.

F4

Opens a drop-down combo list or list box.

Shift+F4

Finds the next occurrence of a match of the text typed in the Find or Replace dialog, if the dialog is closed.

F5

Moves the caret to the record-number box. Type the number of the record that you want to display.

F6

In Table Design view, cycles between upper- and lower parts of the window. In Form Design view, cycles through the header, body (detail section), and footer.

F7

Starts the spelling checker.

F8

Turns on extend mode. Press F8 again to extend the selection to a word, the entire field, the whole record, and then all records.

Shift+F8

Reverses the F8 selection process.

Ctrl+F

Opens the Find dialog.

Ctrl+H

Opens the Replace dialog.

Ctrl++ (plus sign)

Adds a new record to the database.

Shift+Enter

Saves changes to the active record in the database.

Esc

Undoes changes in the current record or field. By pressing Esc twice, you can undo changes in the current field and record. Also cancels extend mode.



Special Edition Using Microsoft Office Access 2003
Special Edition Using Microsoft Office Access 2003
ISBN: 0789729520
EAN: 2147483647
Year: 2005
Pages: 417

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net